can't you concatenate then split in excel?

Or actually why don't you just join the tables then using 2 while loops, you could generate the results on the client, which would...

Please refer to this demo.

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

I see Frank... Looks like I'm gonna get to 10k posts before you do at your current pace.

Nice one Frank... it's nice to see you back here. Where have you been?

I'll remember to check for that someday... good thing you're there .

Or there's always the trick of dividing by a decimal :

Select 2 / 1000 as [int], 2 / 1000.0 as [decimal]

int ...

Not really a strange way.. but I would suggest you try to write a stored proc to resolve this search problem Read this for more details : Dynamic...

HTH.

Here's where the 24 thing comes in handy :

DATEADD(hh, DATEDIFF(hh, 0, TIME_STAMP), 0) % 24

BTW my name is Remi, ten centuries is because I posted 1000+ message. Just like you'll be flagged as a newbie untill you post your 10th message.

Well this is really something that should be done on the client side of the app... but if you insist on doing this on the server :

Select C1.Name, (Select...

Select Y1.Org_Name, Y2.Org_Name from dbo.YourTable Y1 inner join dbo.YourTable Y2 on Y1.Region_Key = Y2.Org_Key

I understand that, but the fact is that the query is still wrong. You can use select into in combinaison with the inner join.

Also if this is something that will...

can you post the table definition along with some sample data?

Declare @StartDate as datetime

set @StartDate = DATEADD(M, DATEDIFF(M, 0, getdate()), 0)

select * from dbo.transmast where trans_date between @StartDate and GetDate()