Viewing 15 posts - 11,671 through 11,685 (of 59,102 total)
pcreddy1005 - Friday, August 3, 2018 12:59 AM
Dude... do your own homework. We're not the ones that need to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 6:30 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 11:06 am
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 10:55 am
In SSMS, you can click on the jobs folder of the Object Explorer (press the F8 key to get there if you don't already know how) and then press the F7...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 9:54 am
Heh... I didn't see Drew's post because I had opened this thread and let it sit for a while. So sorry for the double post with the same answer.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 9:48 am
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 9:46 am
The error message was telling you exactly what is wrong... you weren't using the VALUES Table Valued Constructor correctly. 😉
create table ##Test ([Primary KW] varchar...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 9:12 am
Just a word of caution from a crusty ol' DBA that's long in tooth and has many battle scars...
Adding RAM is always nice but that may not be...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 9:01 am
coolchaitu - Thursday, August 2, 2018 6:02 AMTry writing a script using cursor
Why?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 8:49 am
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 8:44 am
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 8:41 am
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2018 at 8:38 am
Don't forget that, unless there's a NOT NULL constraint on these columns, a NULL could end up being the fly in the ointment.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2018 at 8:07 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2018 at 7:49 pm
Heh... tough crowd! 😉 Have a good one!
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2018 at 7:30 pm
Viewing 15 posts - 11,671 through 11,685 (of 59,102 total)