Viewing 15 posts - 21,871 through 21,885 (of 26,490 total)
Luke L (3/19/2009)
GSquared (3/19/2009)
March 19, 2009 at 2:25 pm
foxjazz (3/19/2009)
Lynn, you have completely and utterly convinced me to look for a set based solution to the problems that come as part of the job.Cudos for that!
Thank you for...
March 19, 2009 at 2:11 pm
Whoa! I think we had an epiphany!!! From The Rant:
foxjazz (3/19/2009)
March 19, 2009 at 2:06 pm
Bruce W Cassidy (3/19/2009)
[font="Verdana"]Thanks folks! Would you believe I was doing this sort of thing with a pivot? :blush:[/font]
Tell me, please, did it hurt? 😉
March 19, 2009 at 1:58 pm
Bob Hovious (3/19/2009)
Arrogance, it seems, returned it has. Oh well, much hope I have no longer.
Is it possible he's been doing it all with cursors since 1995 ??
Suprise...
March 19, 2009 at 1:57 pm
RBarryYoung (3/19/2009)
Dang it! I hate how slow I am on posts... :angry:
Nothing to be upset about. Your explanation helps as well.
Thank you for taking the time add...
March 19, 2009 at 1:22 pm
Arrogance, it seems, returned it has. Oh well, much hope I have no longer.
March 19, 2009 at 1:19 pm
I have to concur with Bob, but I would still like to know if you still think that cursors are the only way to solve problems or if we have...
March 19, 2009 at 1:16 pm
Okay, so the concatenation of ', ' + Col1 results in the loss of the column name and the FOR XML PATH ('') replaces the . I think...
March 19, 2009 at 1:05 pm
It's the FOR XML PATH part that I am not really sure about myself. That's why I was asking for some help here. I'd like to understand it...
March 19, 2009 at 12:27 pm
Okay, I can use stuff((select ', ' + cola from dbo.table1 t1 for xml path ('')), 1, 2, '') but I sure can't explain the how's and why's. Anyone...
March 19, 2009 at 11:54 am
I am going to have to defer your questions to someone who has a better knowledge of FOR XML PATH. I picked up this little trick here on SSC...
March 19, 2009 at 11:38 am
A Little Help Please (3/19/2009)
the problem is, the source table sysjobhsitory has the run_date set as INT.
In my SSIS I converted it to a...
March 19, 2009 at 11:30 am
Derek Dongray (3/19/2009)
Bob Hovious (3/19/2009)
What I know of chaos theory leads me to disbelieve the concept of "Temporal Inertia", although conversely it leads me...
March 19, 2009 at 11:27 am
Christopher Stobbs (3/19/2009)
are you sure?My script when run seems to work!
could that be became of the format settings on the server?
Yes I am. Try taking the single quotes...
March 19, 2009 at 11:15 am
Viewing 15 posts - 21,871 through 21,885 (of 26,490 total)