Tracker


		Advanced Search

HOME

TRACKER

MS SQL Server

SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.

Reasonable To Assemble FullName W/ A UDF

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 Complete Forum Thread with Replies

Related Forum Messages:

Is It Reasonable That A Table Has 240 Fields
Split A Fullname
Break Fullname Into First And Last Name
Break Fullname Into First And Last Name
Splitting FullName In A SQL String..

Is It Reasonable That A Table Has 240 Fields
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 Replies !

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

View Replies !

Break Fullname Into First And Last Name
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 Replies !

Splitting FullName In A SQL String..
I use to use the Instr() method, but that is not allowed in SQL..

Any suggestions?

View Replies !