I did not really time it as there was no need..:) it completed without causing any concerns. May be a minute or so.

Thanks guys for pointing me to the article...

This works for me - let me know if you see some thing wrong in here...

drop table tmptst

select cast('a' as varchar(5)) act,

cast(1 as tinyint) nbr,

cast('nick' as varchar(10)) name,

cast('2008-01-01' as smalldatetime)...

Here is the test data for the situation...

select cast('a' as varchar(5)) act,

cast(1 as tinyint) nbr,

cast('nick' as varchar(10)) name,

cast('2008-01-01' as smalldatetime) dt

into tmptst

insert into tmptst values('a', 1,...

I am on SQLServer2K and it does not seem to recognize the ROW_NUMBER function.

This what I have come up with let me know if you see an issue with this or a way to make it efficient.

select b.emp_nbr, begin_rng, end_rng

from range...

This one from Kent is cool - thanks a lot.

Thanks for looking into this odd request.

Lime is also not acceptable.

Actually the definitions are later to be concatenated - so each region must have same number of lines for the...

FYI - Even Spell check is not going to be 100 % reliable for words like - MESSAGE - if it splits in two line like MESS being the last...

This is using a recent post on PIVOT SQL technique.

--Creating a table with your type of data

create table TT

(

SUPKEY varchar(100),

value tinyint

)

insert into TT values ('BF5EC5CA-C0D8-4402-AA1E-3ACEB6F45A28', 70)

insert into TT values ('BF5EC5CA-C0D8-4402-AA1E-3ACEB6F45A28',...

ISNULL(@SQL1+',','')+CHAR(10)

Just curious - what does this line of code do and how?

Noticed that if this is not there we just get one row but with this we get all the...

Thanks to all you guys.

So, it becomes sort of a cursor logic where I will be calling the function for each distinct ID. Can it be done in some set based manner - or...

This sure is a good way Thanks -

My problem here is a little different. I have a table (say TABLE1) carrying two columns   ID and VALUE.

An ID can have multiple...