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, 4 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?

And, in your case, you don't need the CREATE TABLE statement(s) as the tables already exist.  All you need to write are the ALTER TABLE statements to change the correct...

Steve provided a very short tutorial up above.  He shows a simple CREATE TABLE script,  inserts data into the table, and then modifies the table to increase the size of...

thanks all for the input.  I have been doing other searches as well (not that I don't trust the advice here, but trying to get the whole picture before...