Viewing 8 posts - 1 through 8 (of 8 total)
guruprasat85 (10/26/2008)
thanks Dinesh but in Sql Server 2005 its easy too.. All you have to do is to use a data flow task and you are on!! 😀
Can you elaborate...
July 14, 2009 at 2:03 am
If I've understood your SQL then the below may help. Be warned I haven't checked the syntax and obviously haven't any data. Basically the principle is make your original UNION...
July 2, 2007 at 3:57 am
Got it now. The coalesce is just to prevent trying to concatenate with a null (so would also work using Isnull). Basically the output from the select goes into @string...
June 29, 2007 at 2:37 am
Thank you, that is a smart bit of code Harley. I've never seen coalesce used in that way before, not sure I understand completely why it works! Will do some...
June 29, 2007 at 1:56 am
Great!
Is there a category for 'Just' users? They come in all walks of life : "you just have to re-build the server", "you just need a one line edit", "you...
April 19, 2005 at 3:35 am
Hmmm I was never brought up to write code and just assume it would work, so I would presume that the junior developer had made some attempt at debugging before...
July 9, 2004 at 3:05 am
As somebody who is considering the exams (and paying for them myself!) I found the article pretty useful particularly the opinions of books and teaching aids. However as a VB6/SQL/Access developer my...
March 22, 2004 at 6:58 am
There is 1 GByte of Ram and the vendor set a fixed size of 0.5 GB. There are no other applications running on the server so I would have expected...
December 20, 2003 at 1:34 pm
Viewing 8 posts - 1 through 8 (of 8 total)