Viewing 15 posts - 3,466 through 3,480 (of 5,590 total)
David Webb-200187 (8/31/2010)
Shouldn't the coalesce be around the column, not the variable?
For the way it's coded, it actually needs to be around BOTH.
declare @Notes VarChar(Max)
Select @Notes = COALESCE(@Notes + ',','')...
August 31, 2010 at 11:53 am
Bezan,
Lutz is right on with how to handle it. However, if you are still having problems, please take a look at the first link in my signature. Then, if you...
August 31, 2010 at 11:32 am
coolwebs (8/31/2010)
Three databases running on the same physical hard drive will perform no better than a single database on that same physical hard drive.
Well, the three databases will be in...
August 31, 2010 at 11:29 am
I appreciate your trying to get something that will duplicate the issue. However, as you've mentioned, it isn't making sense why the table variable won't work with the temp table...
August 31, 2010 at 11:25 am
Mark did a good job.
If you also need dates to show if there were zero tickets for all reps for that date, then you need to utilize a calendar table....
August 31, 2010 at 11:20 am
I think that you also have to deal with the spreadsheet tab names - if they are unknown, SSIS won't be able to open up your spreadsheet.
August 31, 2010 at 10:39 am
skcadavre,
This isn't really a good example, since table variables don't participate in transactions to begin with.
August 31, 2010 at 9:37 am
GilaMonster (8/31/2010)
WayneS (8/31/2010)
GilaMonster (8/31/2010)
I tend to use the term 'Database Specialist', as I do everything around DBs, architecture, admin, dev, BI, optimisation, DR, etc.
Over here in the US, we tend...
August 31, 2010 at 9:20 am
Any looping code can have an "infinite looping error". After all, that is just bad programming.
The real solution is to remove all loop processing, and to convert it to set-based...
August 31, 2010 at 9:08 am
subha.msc2007 (8/31/2010)
thanks for your solution..&
what is diff between active/active VS active/possive clustering.
Subha
Active/Active - there is at least one SQL instance running on each of two nodes.
Active/Passive - there is...
August 31, 2010 at 8:51 am
Steve Jones - Editor (8/31/2010)
Paul White NZ (8/31/2010)
Good job on the scheduling, Steve. Very neat.Thanks.
Look for Mr. White's optimizer series over the next few weeks.
AWESOME!
August 31, 2010 at 8:26 am
GilaMonster (8/31/2010)
I tend to use the term 'Database Specialist', as I do everything around DBs, architecture, admin, dev, BI, optimisation, DR, etc.
Over here in the US, we tend to call...
August 31, 2010 at 8:24 am
Steve,
Thanks for the feedback. Sounds like you came up with a do-able solution.
(Isn't it amazing how many people run into the "can't see the forest for the trees" type of...
August 31, 2010 at 8:09 am
Viewing 15 posts - 3,466 through 3,480 (of 5,590 total)