Viewing 15 posts - 1,561 through 1,575 (of 15,381 total)
tripleAxe (5/6/2016)
Ed Wagner (5/6/2016)
Yes, we all know this by now and it was a simple mistake.
I agree. I don't undertand why some peoples get so upset and frustrated...
May 6, 2016 at 7:14 am
spam reported
May 6, 2016 at 7:07 am
spam reported
May 6, 2016 at 7:06 am
DAJOB (5/6/2016)
May 6, 2016 at 7:04 am
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1783907-68-1.aspx
May 6, 2016 at 7:01 am
Gosh it is hard to say what is happening or even what you really want as there is not much provided in the way of details. Perhaps using a GROUP...
May 5, 2016 at 2:56 pm
Another option is to use crosstabs. I find the syntax less obtuse and they even enjoy a slight performance improvement over a PIVOT. See the links in my signature about...
May 5, 2016 at 2:53 pm
spam reported
May 5, 2016 at 1:13 pm
PrettyMegaDBA (5/4/2016)
Thank you both for replying.Sean, what would an alternative be?
well...you could start by reading the article I posted. It has a link to Aaron's version which works better. Or...
May 4, 2016 at 12:59 pm
Be careful using sp_msforeachdb. It can sometimes skip databases. Even more shocking is many of the major players don't really know why. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx
May 4, 2016 at 12:45 pm
WayneS (5/4/2016)
Anyone else having trouble receiving the SSC newsletters? I just received Saturday's "Database Weekly", and I haven't received any of the daily ones this week.
Yeah they seem to be...
May 4, 2016 at 9:39 am
Well you formatted the question but obviously didn't bother to actually see if your sql will execute. You don't have the same number of columns in each query but they...
April 27, 2016 at 12:50 pm
Viewing 15 posts - 1,561 through 1,575 (of 15,381 total)