I can think of a few ways to do this and I think the easiest is to grab the MAX(RefNum) into a variable and then use ROW_NUMBER in your INSERT...

I would start by reviewing the logs. Check the SQL logs and windows logs during that period as one of the logs will have something that will tell you where...

My opinion - this is not a SQL related question, but a WFC related question, so you will get better results from looking on a WFC related forum. Now that...

My opinion - I wouldn't do this. The reason, lets say this scenario comes up:

User A is doing a massive update on a table and it will take 35 minutes...

If I remember right, the BEST way to do the inserts is by inserting at the END of the index. So if your data is ordered by the clustered index,...

You say he won't be updating, but is it because he lacks permissions OR because he promised he wouldn't?

I would make sure your backups are good too. You do NOT...

Best guess - BigQuery is not expecting a column list in your CTE. BUT BigQuery is NOT the same thing as SQL Server 2022... You will likely get better results...

My opinion - if an end user is connecting to a DB using SSMS that isn't a DB Developer or DBA, they should only connect to the TEST system, not...

for question 1, I personally don't see the point. The windows event log has all that data, so why bother moving it to a new location PLUS you would need...

Another question - how many schedules do you have on the job right now? If you have more than 1, it could be that one of the other schedules is...

Are you expecting it to run today? if not, then set the start date to the date you want things to run.

To confirm, if you try to access SSRS via the web instead of your C# app, HTTPS is working correct? I would make sure that it is working from the...

With the new job, did you use the same start date? If so, may not hurt to bump the new start date up to the next expected run date.

Another question for you then - is it consistently FAST and SLOW if you run the same query in SSMS and the ERP OR is it only fast/slow in the...

So that is based on your start date. Jan 1st, 2015 + 26 months is March 1st, 2017. Next run is May 1st, 2019, then July 1st, 2021, then September...

• This reply was modified 1 year, 7 months ago by Mr. Brian Gale. Reason: better solution provided by another poster