Viewing 15 posts - 6,016 through 6,030 (of 39,754 total)
November 30, 2017 at 11:51 am
November 30, 2017 at 11:27 am
If you want inserts, Luis' code is easy to use. Create the Calendar table, then you can merge/insert/update using that joined to your table. This will do inserts:
November 30, 2017 at 11:14 am
November 30, 2017 at 8:54 am
November 30, 2017 at 8:50 am
November 30, 2017 at 8:46 am
November 30, 2017 at 8:44 am
November 29, 2017 at 11:27 am
They shouldn't be. CI and CS are case insensitive and case sensitive.
November 28, 2017 at 12:12 pm
Here's what I'd suggest first. Make this simpler.
Create a table in msdb or in your db. Just a couple fields, something like
CREATE TABLE MyJobs
November 28, 2017 at 11:15 am
Lynn Pettis - Tuesday, November 28, 2017 6:38 AMWell, Steve was right, he managed to snatch defeat from the jaws of victory.
Not...
November 28, 2017 at 9:28 am
November 27, 2017 at 12:01 pm
November 27, 2017 at 11:52 am
November 27, 2017 at 11:29 am
Viewing 15 posts - 6,016 through 6,030 (of 39,754 total)