SELECT '2500------' AS Field1,
       '------' AS Field2,
       '------' AS Field3,
     ...

SELECT d.*, p.CurrentSizeGB - d.CurrentSizeGB size_diff 
  FROM [dev_db_size] d
 INNER JOIN [prod_db_size] p
         ON RIGHT(p.FileName, 3) =...

Using THROW will save...

While I'm not an AWS expert by any means when you deploy an RDS instance of SQL it looks to in the backend just put the MDF/NDF/LDF/BAK/TRN all on...

The purpose of a data warehouse is to be able to query the data quickly. If you only insert values that have changed with start and end dates, the table...

with cte as (select 'PartNbr|#@|Machine|#@|CCode|#@|Cost|#@|  ttxx23|#@|plc1|#@|  ttxx24|#@|plc2' Value)
,cte2 as (select x.value, x.position from cte
           cross...

Thanks for spotting that Jeff. I deliberately wrapped an LTRIM around the return value so if a manually written csv sometimes had comma space or just comma it would return...

If you use this nvarchar(MAX) STRING_SPLIT function

You can do it with the following code:

with cte as (select 'PartNbr|#@|Machine|#@|  ttxx23|#@|plc1|#@|  ttxx24|#@|plc2' Value)
,cte2 as (select x.value,...

I need to add a single quote in each of the alternate characters. The input string could be a variable length.

As an example:

Input String: 5,1,6,1,69,1

output: '5',1,'6',1,'69',1

Input String: 5,1,6,1,3,2,5,3,69,1

output:...

Ah, I see, test driven development:

;with cte as
(
    select * from (values ('Restaurant'),
           ...

Considering there's something urgent going on, why not tell us exactly what it is that you're trying to do and then we might be able to better help. All...

IF OBJECT_ID('tempdb..#temp','u') is not null
    DROP TABLE #temp
GO
SELECT *
  INTO #temp
  FROM (VALUES ('MN', 'KL'),
       ...

That's...

That may work but I need something a little different:

I need the if it is State = MN then Exclude ProdCodes IN ('Kl', 'Kjh')  Else if State not =...

Thanks for the reply, but that is not what I need.

I need a way to write this that when the state is MN then these ProcCodes are Excluded, but...