FYI - I modified the query and removed the max_end column(s) as that isn't needed since we are now using @max_id.

In Oracle - I wouldn't use this structure at all.  I would generate a sequence as needed using INTERVAL - and of course, dual.  But then again I haven't done...

This appears to be a design issue - not really a coding issue.  The design should be modeled on a header/detail type model - where you have a table (and...

This will need to be tested with many more rows/conditions - but should get you started:

SELECT iif(B1 < A1, B1+A1+(max(A1) over()-A1), B1) - A1 FROM CTE

I assumed...

Here are the modifications:

Declare @orderCodeSets Table (order_id int, code_type varchar(20), start_id int, end_id int);

 Insert Into @orderCodeSets (order_id, code_type, start_id, end_id)
 Values (1, 'all_code_sets', 1, 20000)
 ...

• This reply was modified 4 years, 11 months ago by Jeffrey Williams. Reason: Removed the max_end column from the query - isn't needed since we switched to using @max_id

You can add two more tables in the itally.  That should generate more than enough rows.

As for performance, that needs to be tested.

We can shortcut the number of rows generated,...

Here is my take:

Declare @orderCodeSets Table (order_id int, code_type varchar(20), start_id int, end_id int);

 Insert Into @orderCodeSets (order_id, code_type, start_id, end_id)
 Values (1, 'all_code_sets', 1, 100)
 ...

There is no reason to set anything there for SQL Server - if the SQL Server service fails you really don't want it attempting to restart multiple times and possibly...

I don't see those 'few more differences' in the code...the following could replace...

I guess I am not seeing the problem - wouldn't just using TOP 1 with ORDER BY Cond desc return that one row?  Why the need for a case expression?

Unless...

p.s.  The reason why I brought the subject up is because the "condition" we're talking about is that Inserts don't follow the Fill Factor but there is that one...

Accessing PHI through a patient portal is much trickier than just granting access to an individual.  There are laws (HIPAA in the US) that govern what data can be accessed...

Microsoft only supports an OS cluster migration to a version + 1, and that only from Windows Server 2012 R2 and higher.  So - you cannot go directly from 2012...

The problem is how much data you are trying to push across the network to the secondary instances.  The send and redo queues get backed up and that causes the...

To get the equivalent of a last_value - you have to be able to define the order that determines first/last.  If you can do that - then a simple CROSS...