Viewing 15 posts - 16 through 30 (of 373 total)
Iulian -207023 (8/26/2014)
yes, nice question, thanks for it.
+1 - Nice explanation too
August 26, 2014 at 4:15 am
crussell-931424 (8/21/2014)
Thank you for the question.
+1
Nice easy one
August 21, 2014 at 11:49 pm
It would be great if you also provide table schema & sample data. Without schema & sample data, it is difficult to provide help.
Refer - http://dotnetbites.com/grand-total-pivot-sql-server and try...
August 18, 2014 at 4:52 am
Koen Verbeeck (8/18/2014)
SQLRNNR (8/15/2014)
sestell1 (8/15/2014)
XML... yuck. :sick: :laugh:+1
+2
Thanks for the question.
+1 😛
August 18, 2014 at 4:36 am
Hany Helmy (3/3/2014)
paul.knibbs (2/26/2014)
August 14, 2014 at 7:04 am
Hany Helmy (8/14/2014)
Koen Verbeeck (8/13/2014)
Great question, and a fine example of why sp_rename should be avoided.Yeah, that`s why I prefer to Drop & re-create the SP instead of using sp_rename.
+1
Once...
August 14, 2014 at 2:58 am
jramirezgt (8/12/2014)
INSERT...
August 12, 2014 at 10:05 pm
Raghavendra Mudugal (8/12/2014)
Cliff Jones (8/12/2014)
Hugo Kornelis (8/12/2014)
August 12, 2014 at 10:02 pm
Raghavendra Mudugal (8/12/2014)
SqlMel (8/12/2014)
+1. Thanks.By the way, this also works the same in 2008 R2.
+1
(I have started a new thing ... testing each code block of the qtod...
August 12, 2014 at 7:11 am
Iulian -207023 (8/12/2014)
OK I got it, so the key is in SET IMPLICIT_TRANSACTIONS ON ... interesting. Thank you for the question.
Correct 😛
August 12, 2014 at 5:39 am
jcb (8/11/2014)
For me I considering to create a new instance with the correct collation and just move the few staging...
August 12, 2014 at 2:41 am
Koen Verbeeck (8/6/2014)
Nice question. I use SQLPrompt by Redgate so I immediately get all the column names and data types through the IntelliSense without even doing anything 😎 :w00t:
Same here...
August 6, 2014 at 12:42 am
Viewing 15 posts - 16 through 30 (of 373 total)