Can you upload the execution plan from the ID 446211 UPDATE statement? It would be good to see what it's planning for one of those updates. You may want to...

What do you mean by "The ID isnt a primary key its just a normal int column and i cant use a PK because the table is created such that...

What major problem? The only question you have asked is "Just curious, how many people here would need this function ?"; What function?

It almost seems like you're...

What is your question exactly? It seems like you're asking if people need help, rather than asking for it; unless I'm mistaken?

Did the task actually do what it performed? I note that you have your success exit code set to 0, so SSIS see a 2 as a failure. If so,...

Thanks Scott, didn't really consider using Math logic. Although, I'll admit, not as readable, does perform quicker. 🙂

I would say that a better option would be use a Date Table, and secondly, convert this to a Inline-Table function.

Firstly, have a look Bones of...

Considering that you are using a ? to define your parameter, can i assume that this in actually an SSIS SQL Execute task?

If so, you could do:

I've not used Azure, so my answer won't be 100% complete. I can, however, confirm that going from 2008 to 2016 shouldn't pose any problems. The reprots I have here...

You can do this on the search page. If you go https://www.sqlservercentral.com/Forums/Search, make sure your on advanced search, and type your username in the username field. Then on...