Maybe try CASTing to an explicit length?:

,CASE 
WHEN T.[PD_ID] in (@Part)
THEN CAST('PD_ID_Match' AS varchar(30))
WHEN T.[Flat_PD_ID] in (@Part)
THEN CAST('FLAT_PD_ID_Match' AS varchar(30))
WHEN T.[Like_PD_ID] in (@Part)
THEN CAST('Like_PD_ID_Match' AS varchar(30))
WHEN T.[Flat_Like_PD_ID]...

Off the top, just streamline it as much as you can:

BEGIN
    RETURN (
        SELECT product = CASE...

What row was just FETCHed from, that is the row that SQL will delete, since that is the current position of the cursor.

Don't force SQL to fully reprocess the conditions before DELETEing each row, instead use WHERE CURRENT OF in the DELETE:

DECLARE @user VARCHAR(50)
DECLARE @role VARCHAR(50)

DECLARE db_cursor CURSOR LOCAL...

;WITH
cteTally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cteTally100 AS (
    SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS number
  ...

FYI, just in case you care, I was able to get my code fully corrected.

I personally wouldn't use "+2", as it's nebulous unless you already know what it's doing; instead, I'd use the actual base date.  And, if you shift from Excel, the base...

Under no circumstances should you use the actual SSN to link accounts.  You might have to store the SSN in one place, but you sure don't have to store it...

Sorry, I thought you only wanted it down to the minute based on your initial description

duration in terms of minutes

SELECT SUM(DATEDIFF(MINUTE, '1899-12-30', duration)) AS duration_in_mins

SELECT emailaddress, COUNT(DISTINCT emailID) AS emailID_Count
FROM ##myTable
GROUP BY emailaddress
HAVING COUNT(DISTINCT emailID) > 1

Table "C" only has each unique Name and EIN combination only 1 time, no matter how many fiscal years or amounts it has.  That't the whole point of the "C"...

You can use either VALUES or SELECT, you can't combine them:

Insert into Cntrl.tbl_Entity_master

select distinct [Entity Name], [Entity EIN] from B

Yep, just create another table.

CREATE TABLE dbo.Entity_master (

[Entity Name] nvarchar(60) NOT NULL, [Entity EIN] char(10) /*or whatever*/ NOT NULL,

CONSTRAINT Entity_master__PK PRIMARY KEY ( [Entity Name], [Entity EIN] )

)

• This reply was modified 6 years, 11 months ago by ScottPletcher.

Itzik Ben-Gan books and/or videos.

Books will typically you a much more in-depth knowledge.  If you'd rather just have an overview level of knowledge, then a video(s) would work.