That's how I would do it.  Use a tally table or table function to generate the values needed, then left join the tally table to your dataset , then us...

What is the PK of the Insurance Table?  Include that in your cursor, then update the MsgSent to 1 after the send email proc call

I created DDL based on your sample.  You hardcoded the orderid in your union all statement.  Can you provide usable DDL and data to help show what you are looking...

Looks like Min/Max works for your scenario

IF OBJECT_ID('tempdb..#Codes') IS NOT NULL
DROP TABLE #Codes

Create table #Codes (
Code_Type varchar(20),
Start_Id int,
End_Id int)

insert into #Codes values
('all_codes_set',1,5 ),
('all_codes_set',7,14 ),
('all_codes_set',17,49 ),
('all_codes_set',61,100),
('voided',6,6),
('cancelled',50,60),
('unused',15,16)

Select Code_type, min(Start_Id)...

• This reply was modified 3 years, 10 months ago by  Mike01.

You have to do some outer applies.

declare @x xml

SELECT @x = CAST(MY_XML AS xml)

FROM OPENROWSET(BULK 'C:\Users\MyUser\Documents\Lukasz\Apps\Ramo\SIN\SecutrityUsers.xml', SINGLE_BLOB) AS T(MY_XML)

...

• This reply was modified 3 years, 10 months ago by  Mike01.

removed - duplicate from above

• This reply was modified 3 years, 10 months ago by  Mike01.

always start in lower environments (Dev, Test, Stage, Prod) or something similar.  The Environments should be relatively the same.  There may be different code in different environments depending on where...

You can do merge to #L in the proc and output the insert/deleted values to a temp table, then use the temp table to merge values to #P table

Select t.column1, (SELECT STUFF( 
                      ...

how do you know the order of the values to concatenate?  You can use Stuff to accomplish this, but you'll need a way to know which ones to include. (i.e....

Something like this?

select CustomerID, Create_Date,
(select count(1)
from #Customers c1
where c1.Create_date between DateAdd(hour, -1, c.Create_date) and c.Create_date) as NumberOfSignups
--,Count(1)
from #Customers c
where c.Create_date between DateAdd(hour, -1, c.Create_date) and c.Create_date
order by...

• This reply was modified 3 years, 11 months ago by  Mike01.

SELECT s.[BusinessEntityID] ,
s.[Name] ,
at.[Name] AS [AddressType],
A.AddressID,
a.[AddressLine1] ,
a.[AddressLine2] ,
a.[City] ,
sp.[Name] AS [StateProvinceName] ,
a.[PostalCode] ,
cr.[Name] AS [CountryRegionName]

FROM [Sales].[Store] S Join [Person].[BusinessEntityAddress] BEA ON bea.[BusinessEntityID] = s.[BusinessEntityID]
Join [Person].[Address] a ON...

• This reply was modified 3 years, 11 months ago by  Mike01.

Check the data source task. Right Click --> Open Advanced Editor. On Input/Output tab open External Columns and Output Columns. Find your column and see what the...

Wow, Joe!!! Condescending much??

I'm not sure that will work.  The CloseDatabase command takes source_database_name and target_database_name as parameters, so it creates a read-only copy on the same server.