Viewing 15 posts - 47,806 through 47,820 (of 59,064 total)
maynor_ramirez (10/9/2008)
I need to pivot on some not all rows, I have search the sqlservercentral site for the answer but nothing yet..Thanks
[url="Cross Tabs and Pivots, Part 1 – Converting Rows...
October 9, 2008 at 7:35 pm
That would grab /*__*/ if it's on the same line as some code of embedded within a statement.
October 9, 2008 at 7:28 pm
Vincent Central (10/9/2008)
Thank you all for your replies. I have "coached" the offending developers and...
October 9, 2008 at 6:47 pm
cdex3 (10/9/2008)
Thanks for the info!This is my first post so I apologize for any lack of etiquette.
Your never too old or too young to learn new things and ideas.
Heh......
October 9, 2008 at 6:17 pm
Oh yeah... almost forgot... you can usually get away without using an Index "Hint", but like ORDER BY in a Select, it's always best to have one to force the...
October 9, 2008 at 6:04 pm
That and you need a "anchor" column even if it doesn't do anything for the code... one that is just @variable = @column. Sometimes it works without one... don't...
October 9, 2008 at 6:01 pm
rbarryyoung (10/9/2008)
Select *
From Locations
Where NOT EXISTS( Select * From Excludes
Where Location LIKE '%'+Excludes+'%')
This is probably close to what Jeff intended to write,...
October 9, 2008 at 5:58 pm
Sergiy (10/9/2008)
Jeff Moden (10/9/2008)
change all the delimiters to a "thorn" and go for it.
There is no guarantee "thorn" is not or will not be used within the filed for...
October 9, 2008 at 5:56 pm
Heh... I was hoping you had an IDENTITY PK... I won't have to make many changes to the script I just wrote above...
October 9, 2008 at 5:54 pm
Michael Earl (10/8/2008)
SELECT * FROM TempDB..Sysobjects WHERE Type = 'u'
A table variable usually has to get pretty big before it spills over...
October 9, 2008 at 4:27 pm
G Bryant McClellan (10/8/2008)
Thanks for the reply. I can see that testing is the only sure-fire method to compare the performance, but there must be some indication that the switch...
October 9, 2008 at 4:26 pm
Dang it... I forgot about RegEx. That might work... change all the delimiters to a "thorn" and go for it.
October 9, 2008 at 1:15 pm
riga1966 (10/9/2008)
I have a very clear understanding of how to do a Cross-Tab now.How about Uncross-Tab?
Does anyone have any samples?
Thanks,
Heh... that's called either "UnPivot" or "Normalizing". You could probably...
October 9, 2008 at 1:12 pm
You bet. Thanks for the feedback.
Just remember... if you can't wedge a clustered index in there like I did, this solution will not work correctly.
October 9, 2008 at 5:59 am
Viewing 15 posts - 47,806 through 47,820 (of 59,064 total)