Thanks a lot Louis, just now i did using the row_number function.

select case when rn = 1 then Client else null end as Client

...

it would be great if i have the query. can you show me the sample query please

sorry for the confusion. i am done with my requirement. thanks for your time.

can any one please suggest me

Yes i agree that credit goes to Jeff.

by the way, i am good with insert statement. Any suggestion with update statement? how can i update the sample table with...

Hello Ed Wagner,

I totally agree that "DelimitedSplit8K" function is much faster. thanks for your time.

wow,

thanks a lot everyone for your time on this post.

dwain's suggestion will be more simple.

Hi Lynn,

thanks for your reply. i haven't changed my requirement. anyhow apologize for the miss communication here.

What i told was about the code provided by ssc and not...

Also, none of the above queries executing correctly. i tried to check the query is working fine or not using

http://sqlfiddle.com. Somethign wrong with the declaration. could you please suggest...

Hi Jeff Thanks for your response and great article. But i have a concern that you are using custom year next to the declaration.

SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

I don't want this...

Thank you lynn.

wow, thanks a lot lynn and SSC.

Hi lynn,

I would like to understand your concept. Is it possible to give me brief explanation about your logic would be great.

Many Thanks!! Lynn.

Can this Develoepr edition be used on staging environment? the reason why am asking is my staging site will be used to give demo to the outside client.

So it's more...

Ahhhhh!!! i got it. it's not free of cost. i need to purchase license. The cost is $49.

http://stackoverflow.com/questions/1843376/sql-server-developer-standard-enterprise-for-local-development

the question is $49 per one user or multiple user?