Viewing 15 posts - 40,666 through 40,680 (of 59,070 total)
Adam Haines (12/14/2009)
Jeff Moden (12/14/2009)
Aaron Gonzalez-394690 (12/14/2009)
I was involved in a similar situation before and since we were working with sql server 2005 I had the developer...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 11:45 am
Roland Howard Boorman (12/14/2009)
Using XML whole complex structures can be passed to SQL and treated as Tables.
You can use Functions with the XML to render these...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 11:20 am
Aaron Gonzalez-394690 (12/14/2009)
I was involved in a similar situation before and since we were working with sql server 2005 I had the developer pass a xml value...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 11:18 am
Pratap Prabhu (12/14/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 11:15 am
Traversing hierarchies is about the only one I can think of although there are methods that will blow the doors off that, as well.
Also, since we're dropping names and articles,...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 11:11 am
Pratap Prabhu (12/14/2009)
I however do feel a few minor tweaks are needed ...
The best minor tweek you could make to the code is to write it so it doesn't use...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 10:03 am
I have some great bit of difficulty in believing that people are still using While Loops and the "Hidden RBAR" method of recursive CTE's for such a thing.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2009 at 8:06 am
Matt Miller (#4) (12/13/2009)
Jeff Moden (12/12/2009)
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this carMan, I used to love "Spanky and his gang".
Oh - were you madly...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:51 pm
You bet, Wayne.
As a side bar... now you know why I don't care to store flags as bits. A single bit flag in a row still takes a whole...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:42 pm
Steve is correct. It's not what you're logged in as... it's what the server is logged in as. Do you know how to find which login SQL Server...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:38 pm
naveenreddy.84 (12/13/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:30 pm
No way to explain it better than that, Steve.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:26 pm
anitha.cherukuri (12/13/2009)
Hi JeffI solved my problem by using temp table concept.
sorry for giving trouble....
Sorry... didn't see this before I posted my last message. Two way street here, Anitha... please...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:23 pm
anitha.cherukuri (12/13/2009)
Hi JeffI am very new to functions concept ,and i can not create table to hold the results.
I wrote the function,but getting errors...
Writing a function for this will just...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:22 pm
sav-457805 (12/11/2009)
This is brilliant Jeff. Very Well explained. One for my Useful SQL script collection.
Thank you, Sav... the feedback is always appreciated. Glad I could help.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 13, 2009 at 5:19 pm
Viewing 15 posts - 40,666 through 40,680 (of 59,070 total)