An ORDER BY either has an OFFSET clause or it doesn't.  There is no "sometimes it does, sometimes it doesn't".

In this structure, rather than use 0 for the count, could...

Sorry, thought I changed it to jma.... (which I'll now do in my orig post as well).  But I'm assuming that such a column exists just because or your comments...

Seems like the table must be empty.

Make sure you are in the correct db.

A long shot, but you should always put the schema name on the table anyway, for performance...

Here's my best guess at what you're trying to do.

SELECT 
    JO.jmoJobID, JA.jmaPartID, JO.jmoWorkCenterID, 
    JO.jmoProcessID, JO.jmoOperationQuantity, 
   ...

For a little disk space, you can create staging tables in DB2.  Load to the staging tables.  You then don't need a separate back up of the original tables because...

I believe it's because you're doing "MAX" but the value is a string not a number.  Therefore '9' is greater than '10', or '1', so '9' becomes the MAX value. ...

If they log into SQL initially as themselves, ORIGINAL_LOGIN() might give you their own name rather than the generic name.  It may not, but it's worth a try first.

DECLARE @cod_pattern varchar(50)
SET @cod_pattern = 'NCREC-CL'+'.'+'CMP'+'-'+'%'

;WITH cte_next_numbers AS (
    SELECT LEFT(cod, cod_base_length) AS cod_base,
        MAX(CAST(SUBSTRING(cod, cod_base_length +...

Ok, Category appears to not be a reserved word and appears in white.  Period and Value are both blue.  So it's brackets, no brackets, and brackets instead of brackets,...

Ooh, right.  I tired to change the sort because you formatted BatchDatte to mm/dd/yyyy which will not sort correctly.

SELECT DISTINCT 
    BatchID, EDIProviderSort,
    CONVERT(varchar(10), BatchDateConv, 101) AS BatchDatte,
    DName

FROM UPSBatchInvNo

CROSS APPLY (
    SELECT...

SQL Server doesn't store, and thus doesn't know, the "last accessed date" for each db.

After SQL starts, when any index is accessed, an entry for that db and index is...

The first two are not full but don't have room to expand by the specified amount.

Alter the first two files to have a maxsize of their current size.  That will...

with testCostTable([Period], [Category], [Value]) as (

Also, the column names used are all SQL Server reserved words.  That's something many SQL developers find annoying :).  In my...

What's the best way to know which index statistics need to be updated on a daily basis?  I currently update stats on Friday, but I've noticed SQL is...