Viewing 15 posts - 1,681 through 1,695 (of 4,820 total)
Scheduling the run of the stored procedure is something you do using a SQL Agent Job. The SQL Server Agent Service runs under the security context of its "service account",...
March 15, 2018 at 6:51 am
March 15, 2018 at 6:32 am
declare @firstofprevmonth date = datefromparts(year(dateadd(month,-1,getdate())), month(dateadd(month,-1,getdate())),...March 15, 2018 at 6:28 am
March 15, 2018 at 6:27 am
ZZartin - Wednesday, March 14, 2018 1:44 PMWhy not just CASE WHEN DATEDIFF(month, getdate(), C.PricingDate) = -1 THEN ...
That's not quite the...
March 14, 2018 at 2:00 pm
March 14, 2018 at 1:29 pm
Runs fine on my machine. Not sure where the trouble is... Any chance of an accidental keystroke that messed with your copy after you pasted it into SSMS ?
March 14, 2018 at 1:19 pm
Might want to try it this way:DECLARE @command AS varchar(2000) = '
USE ?
PRINT ''--=========================================================================='';
PRINT ''USE ?'';
PRINT ''--=========================================================================='';
DECLARE @note AS varchar(2048), @id AS...
March 14, 2018 at 12:48 pm
I think the cart has come before the horse. I suspect what is needed is that the cursor SQL needs to be the contents of the @command variable.
EDIT:...
March 14, 2018 at 12:23 pm
March 14, 2018 at 12:18 pm
March 14, 2018 at 11:41 am
Nita Reddy - Wednesday, March 14, 2018 9:05 AMNo it don't work
What doesn't work? What, exactly, did you try? Was there an...
March 14, 2018 at 10:55 am
Viewing 15 posts - 1,681 through 1,695 (of 4,820 total)