Reasonable To Assemble FullName W/ A UDF

Mar 1, 2006

I break somone's name in a table in fields as First, Last, Middle,
Suffix.

Is it reasonable to use a UDF to create the full name as a string if I
need it, by passing it the First, Last, Middle, & Suffix fields?

Is this really slow to do? It's just sometimes I want to do a GroupBy
Query and I want to include the person's name in the Select of the
query and I don't know if the group by would work if I returned each
column seperately.

Any opinions on this?

Thanks.

View 2 Replies


ADVERTISEMENT

Is It Reasonable That A Table Has 240 Fields

Aug 16, 2006

Hi,

I have 240 sensors to sample one time per second,then store the data in sql server.

Is it reasonable that the table has 240 fields?If do,it will generate about 70,000 records every day.One month records will be 2,100,000.

If I divide the 240 sampling data into 10 records,every record has 24 fields.Then every day 700,000 records will generate.One month the record number is 21,000,000.It is terrible.

Which method is better,or who can give me another better method or some suggestions.

I need your help.Thank a lot.

View 9 Replies View Related

Split A Fullname

Mar 22, 2001

I want to know how to parse a fullname into a fname and lname.

View 2 Replies View Related

Break Fullname Into First And Last Name

Jun 21, 2001

Hi, Guys,

I need to break a column Fullname into two columns called Firstname and Lastname. The Fullname column contains users fullname with a space between first and last name, for example (jonh smith). I want the first name to be in Firstname and last name in Lastname. Can any one help me on this? Thanks in advance.

View 1 Replies View Related

Break Fullname Into First And Last Name

Jun 21, 2001

Hi, Guys,

I need to break a column Fullname into two columns called Firstname and Lastname. The Fullname column contains users fullname with a space between first and last name, for example (jonh smith). I want the first name to be in Firstname and last name in Lastname. Can any one help me on this? Thanks in advance.

View 2 Replies View Related

Splitting FullName In A SQL String..

May 28, 2004

I use to use the Instr() method, but that is not allowed in SQL..

Any suggestions?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved