In addition to anthony.green, you'll probably need a while loop where you'll have WAITFOR that would make delays between job status checks. Don't forget to add some logic to exit...

• This reply was modified 4 years, 4 months ago by  dkultasev.

If you can't add columns\objects that can only be done by dynamic SQL. If you can create objects, then you can create view that will have placeholder in some databases...

The query is doing following:

• Get counts for every salesman_id from customer table (SQL Server automatically GROUP BY by it as you are not returning any columns, so it takes...

It seems that you are doing something wrong. Normally you don't need to update the history records. If you need to get the update time not in UTC, you just...

• This reply was modified 4 years, 5 months ago by  dkultasev.