Just wait until the company has a WTF moment and you know what hits the fan.

Also, could you post a small sample set of data being passed into the stored procedure that is at least representative of the data actually passed in to the stored...

Would you please post the DDL for the user defined table?

Lynn- I'm really fascinated by your solution. I don't think I've come across that concept of outer joining to the FROM table using the VALUES constructor. Is that functionally...

This is one way, not sure if it is the best way:

Declare @TheTable table (ID int, V1 varchar(1), V2 varchar(2), V3 varchar(1), V4 varchar(1)); -- End all...

Got here by a web search and didnt see a straight answer.   72 cores in a host and 72 sql standard per core licenses allows up to have...

If asked that in an interview I would ask why it was being designed that way.  It is inefficient and a waste of resources.  Breaking it up in to...

If asked that in an interview I would ask why it was being designed that way.  It is inefficient and a waste of resources.  Breaking it up in to three...

To be honest, I wouldn't design it that way.  Each Dataflow Task would be in its own package and scheduled to run as SQL Agent job at the appropriate times.

Here is my take:

CREATE TABLE [#temp_Imports]
(
  [ImportId]       uniqueidentifier NOT NULL
, [ImporterNumber] nvarchar(100)    NOT NULL
, [ImportFreq]  ...

You can use the following written by Jeff Moden:

/****** Object:  UserDefinedFunction [dbo].[DelimitedSplitN4K]    Script Date: 4/18/2019 3:03:22 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


 CREATE...

• This reply was modified 6 years, 10 months ago by Lynn Pettis.

Never hide a mistake, that will get you more trouble than the actual mistake.  Tell your supervisor or manager.  leave it up to them if it should go higher.

>> I currently have two tables: << where is the DDL for these two tables? You expect us to write the DDL for you because you feel you're so...

One way:

CREATE TABLE #myTable (emailID int, emailaddress VARCHAR(20), activitydate datetime);
INSERT INTO #myTable (emailID,emailaddress, activitydate)
VALUES (100,'abctest@test.com','2019/02/18')
     , (102,'xyzabc@test.com','2019/01/28')
     , (105,'xyzabc@test.com','2019/02/20')
...

What exactly do you want the output to look like?