ok, that's not what I thought you meant. I thought you meant flip all the bits.

This works for 0 and 1:

DECLARE @smallint smallint = 0
select...

ok, that's not what I thought you meant. I thought you meant flip all the bits.

This works for 0 and 1:

DECLARE @smallint smallint = 0
select @smallint ^...

1

SELECT t.*
  FROM MyTable t
 CROSS APPLY (VALUES ('Jan', 1),('Feb', 2),('Mar', 3),('Apr', 4),('May', 5),('Jun', 6),('Jul', 7),('Aug', 8),('Sep', 9),('Oct', 10),('Nov', 11),('Dec', 12))...

1

SELECT t.*
  FROM MyTable t
 CROSS APPLY (VALUES ('Jan', 1),('Feb', 2),('Mar', 3),('Apr', 4),('May', 5),('Jun', 6),('Jul', 7),('Aug', 8),('Sep', 9),('Oct', 10),('Nov', 11),('Dec', 12)) M(Name,N)
  ...

• This reply was modified 3 years, 2 months ago by Jonathan AC Roberts. Reason: updated order by date

1

SELECT t.*
  FROM MyTable t
 CROSS APPLY (VALUES ('Jan', 1),('Feb', 2),('Mar', 3),('Apr', 4),('May', 5),('Jun', 6),('Jul', 7),('Aug', 8),('Sep', 9),('Oct', 10),('Nov', 11),('Dec', 12)) M(Name,N)
    ...

First option is the correct relational way to design it.

I took "I need to update my sql...

I took "I need to update my sql script and...

Probably so he can get away from having to run two separate queries and then merge the results with a distinct UNION.  That may or may not be faster,...

Yes, but it doesn't have a union which is all that was asked.

Why do you think the OP wants to...

This SQL is functionally equivalent and there is no UNION:

drop table if exists #t;

WITH cte_mas AS 
(
    SELECT *,
     ...

With a table of that size it might be better to look at partitioning the table.

I don't know the specific answer to your question but I have generally found it better to create a temp table or table variable (depending on size) and insert...

A half column; a column bisected longitudinally, or along its axis.

A low-relief, vertical pillar or pilaster in a wall, usually without a base or capital;...

I think you want IDENTITY not AUTO_INCREMENT