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...

Why does your body need to access the page number?