Viewing 15 posts - 33,571 through 33,585 (of 59,102 total)
Almost forgot. Please see the following link for how Cross Tabs work and how they compare to Pivot.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:19 pm
roshan.zanwar (6/19/2011)
I am trying to print characters after rd occurance of character 'a'.
Suppose My column name is Emp_Name & one of the record like ababaccc.
So i am trying to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:14 pm
Here's one solution. As normal for me, the details are in the comments in the code. Post back if you have any questions. I'd also like...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:09 pm
kickersdj (6/16/2011)
I have one table where the person's name could appear in many columns. Instead of having the name...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 7:19 pm
mcasuman2004 (6/19/2011)
--' RootNode
--' ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 7:13 pm
m.dunster (6/19/2011)
Thank you for your responses. I guess the final answer is... the code is efficient as it is going to be. I thought about JOINS, but it is a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 6:41 pm
mcasuman2004 (6/19/2011)
I am using sql server 2005 and in that one table with values 5,6,7,9,1.
Note:- Feild data type is varchar.
Just I need the sum(5,6,7,9,1) =...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 5:44 pm
Grant Fritchey (6/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 5:30 pm
SQLRNNR (6/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 5:12 pm
Steve Jones - SSC Editor (6/18/2011)
Heh... glad you clarified what that was. I thought maybe you got a picture of Celko in his natural environment. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 5:06 pm
Tom.Thomson (6/19/2011)
Dave Ballantyne (6/19/2011)
Ok , so we all have differing opinions of Celko, but a response after three and a half years :crazy:
I don't think many threadizens will find...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 5:02 pm
opc.three (6/18/2011)
It sounds like you're driving towards the "someone has to have the keys to the kingdom" debate.
Heh... gosh no. Quite the opposite, actually. A lot of good...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 12:03 pm
drew.georgopulos (6/19/2011)
I am wiping the blood and hair off the monitor trying to adapt what i read here to my own problem but need to be dragged from the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 11:13 am
SJTerrill (6/19/2011)
Mr. Moden,Is there any chance you might publish a book?
Please?
--SJTerrill--
I started one over a year ago. Got about 3 chapters into it and was overtaken by events. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 10:19 am
malachyrafferty (6/16/2011)
when i check sp_configure xp cmdshell has max value of 1 - what does this 1 mean?
It means what it says. There are two possible values for this...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 18, 2011 at 11:32 pm
Viewing 15 posts - 33,571 through 33,585 (of 59,102 total)