Viewing 15 posts - 7,846 through 7,860 (of 9,720 total)
Just an FYI:
Earlier, I was seeing 3 duplicate numbers when running your original NewID() solution. Repeated runnings seems to generate between 0 - 5 duplicate numbers with no discernible pattern...
July 16, 2010 at 6:54 am
Eugene Elutin (7/12/2010)
Sorry, but your real issue is not reading answers carefully and not trying to run given samples of code.
And perhaps you should test your own code too?
Yes, I...
July 16, 2010 at 5:38 am
Ah. Yes. Pivot does require aggregation. Sorry. I didn't realize that's what you're doing.
Hmm. Now I'm wondering if there's a way to trick Pivot into doing an aggregation that isn't...
July 12, 2010 at 11:32 am
Bleargh. I had a feeling that was going to be the answer.
Oh, well. If I hadn't asked the question, there would have been an alternative. @=)
Thanks, Gail.
July 12, 2010 at 11:25 am
So many potential solutions. I like Steve's solution stuffed in a sub-query and broken out into separate columns. Then just do a count in the outer query and group by...
July 12, 2010 at 11:19 am
Alan G-436699 (7/12/2010)
As my loop is generic code, I really don't want to define a column list (I am copying 600 tables).
Column List in the SELECT part of the...
July 12, 2010 at 11:09 am
Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.
July 12, 2010 at 11:05 am
Glad I could help. Let me know if you have any more questions regarding this issue.
July 12, 2010 at 5:47 am
Well that depends on where the .exe file is located. If it's on a UNC or Share drive, you just need to add the proxy account to that path's Security...
July 12, 2010 at 5:43 am
Does the proxy account have permissions on MSDB to execute the dbmail procs? Does it have write permissions on the share where the log file is kept? Does it have...
July 9, 2010 at 10:53 am
Nevermind. We have a clustered server and the users in question keep getting shunted to the node that isn't quite working right. When we have them use the literal address...
July 9, 2010 at 9:14 am
will s (7/8/2010)
The "new alert" wizard doesn't have a "when this job fails" option, which is what I really want.
Maybe I'm misunderstanding, but failed jobs can send out Notifications which...
July 9, 2010 at 8:43 am
That's your problem right there. You cannot save the password for that login when using "DontSaveSensitive". The point of that protection level is that the package does not save passwords....
July 9, 2010 at 4:00 am
TravisDBA (7/8/2010)
So I spend the first week reading up on the database, then find myself receiving troubleshooting emails. So I ask my co-worker (the only other DBA team on the...
July 8, 2010 at 11:09 am
Viewing 15 posts - 7,846 through 7,860 (of 9,720 total)