Here is a cut-down example, which you should be able to expand to do what you want. There is much that can be done to refine it, but as it...

A table-valued function might do what you need. Have a look at the following link and see whether it gets you on the way:

https://www.sqlservertutorial.net/sql-server-user-defined-functions/sql-server-table-valued-functions/

As you've no doubt already discovered,...

Best guess. Please provide your sample data in consumable format in future.

DROP TABLE IF EXISTS #Somedata;

CREATE TABLE #SomeData
(
    Id INT
   ,SomeData VARCHAR(50)
...

How are you ordering the data? I do not see what makes the second row come after first.

Thanks @Phil

I've just looked and foreign keys are set to TRUE which is odd.

I'll keep an eye on it and see if it happens again.

I'll also go through the...

I've only seen it when using the designer.

Can you point in the direction of the specific (if there is one) default that needs changing to stop this happening?

I've had...

Hello,

Of course the COMMIT TRAN have been put within IF and the same has been deployed already.

The question here is why in first couple of days this error did...

stp = Stored Procedure?

I suspect 'simulated' is not the right word here ... but I'm not sure what you really mean. Please clarify.

What to be done? Fix the bug! You...

Thanks for that.   We use synonyms to refer to other databases so hopefully that shouldn't cause too many issues.

I'll give it a go with a test database and...

Should be...

If you've got this all inside a VS database project, editing the .sql files for the tables and then Publishing does everything for you.

But behind the scenes, it is still...

One idea is to put your dataset queries into stored procs and call those from your report.

My preference is to keep complex business logic such as this within the database....

I had to look up "corpuscles", for a moment I thought it was a new drink at starbucks.

Thank you all for taking the time and giving me your take...

Jeff, that's nice code, well done!

I would define first week as any days of the month that land on the first week of the month.  i.e. if September 1 lands on Friday, then September...

• This reply was modified 2 years, 7 months ago by Phil Parkin.
• This reply was modified 2 years, 7 months ago by Phil Parkin.