Viewing 15 posts - 17,656 through 17,670 (of 18,926 total)
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...
May 25, 2005 at 10:49 am
Please refer to this demo.
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
May 25, 2005 at 10:25 am
I see Frank... Looks like I'm gonna get to 10k posts before you do at your current pace.
May 25, 2005 at 9:01 am
Nice one Frank... it's nice to see you back here. Where have you been?
May 25, 2005 at 8:36 am
I'll remember to check for that someday... good thing you're there
.
May 25, 2005 at 8:11 am
Or there's always the trick of dividing by a decimal :
Select 2 / 1000 as [int], 2 / 1000.0 as [decimal]
int ...
May 25, 2005 at 7:56 am
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...
May 25, 2005 at 7:54 am
Here's where the 24 thing comes in handy :
DATEADD(hh, DATEDIFF(hh, 0, TIME_STAMP), 0) % 24
May 25, 2005 at 7:37 am
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.
May 25, 2005 at 7:28 am
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...
May 25, 2005 at 7:23 am
Select Y1.Org_Name, Y2.Org_Name from dbo.YourTable Y1 inner join dbo.YourTable Y2 on Y1.Region_Key = Y2.Org_Key
May 25, 2005 at 7:19 am
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...
May 25, 2005 at 7:11 am
can you post the table definition along with some sample data?
May 25, 2005 at 7:06 am
Declare @StartDate as datetime
set @StartDate = DATEADD(M, DATEDIFF(M, 0, getdate()), 0)
select * from dbo.transmast where trans_date between @StartDate and GetDate()
May 25, 2005 at 7:04 am
Viewing 15 posts - 17,656 through 17,670 (of 18,926 total)