Viewing 15 posts - 676 through 690 (of 7,187 total)
wak_no1 - Thursday, August 16, 2018 4:58 AMYou mean in the IF statement?
Yes. At the moment, it will evaluate to true...
August 16, 2018 at 5:05 am
The problem appears to be that you're not using the @inserted table. (By the way, you don't need to insert that into a table, just use Inserted directly.)
But,...
August 16, 2018 at 4:50 am
Santosh
How many rows are being updated? Please post the actual (not estimated) execution plan.
John
August 16, 2018 at 4:29 am
What is your question?
Actually, I have a question. Why not just create a unique index on ACCOUNTID and COUPONID, filtered on PREVBALANCE = 4 AND BALANCE = -2...
August 16, 2018 at 4:25 am
I have created a workaround:
...
if month(getdate()) = '9'
delete FROM dbo.CounterData WHERE CounterDateTime like '%-07-%'
go
August 10, 2018 at 9:31 am
August 10, 2018 at 2:21 am
Jose
Yes, the more often you back up your log, the smaller the log file needs to be and the smaller your log backups will be. But there comes...
August 10, 2018 at 2:05 am
Have the first step of the second job test sysjobhistory, and if the first job failed, raise an error. Set the second job to fail if the first step fails.
August 9, 2018 at 9:47 am
Daniel
Well, if you deleted it all, then you're going to struggle to keep today's data! Seriously, though - if you deleted all data then it must mean that...
August 9, 2018 at 9:24 am
SELECT counterdatetime
FROM CounterData
WHERE TRY_CONVERT(datetime,counterdatetime) IS NULL
John
August 9, 2018 at 9:00 am
August 9, 2018 at 8:18 am
A full backup doesn't mark the space in the log file as reusable. Have a read through this, and let us know if you have any questions.
August 9, 2018 at 4:58 am
August 9, 2018 at 4:50 am
I really don't know what's happening, then. If you're more interested in fixing this than finding out why it's happening, check that the schedule isn't being used for any other...
August 9, 2018 at 4:36 am
I don't think you understand. Please have a look through this. You may find that it points you in the right direction to solve the problem yourself. If...
August 9, 2018 at 4:19 am
Viewing 15 posts - 676 through 690 (of 7,187 total)