Sean Lange (3/27/2014)

---

Yeah this is pretty much exactly what Scott already posted.

I changed the name Case to MyCase because I hate working with reserved words and typing brackets around table...

Here the scripts:

Create table tmp.[Case]

(

CaseID varchar (50),

Resolution varchar(50),

);

INSERT INTO tmp.[Case] (CaseID, Resolution)

VALUES ('4647018364','Void')--no subcase available

,('4647018265','Parts')--no subcase available

...

Sean Lange (3/27/2014)

---

Then you will need to...

Correct, I want to create rows in the SubCase table when a Case has no SubCase. This is permanent, not during a query.

Jeff Moden (2/2/2014)

---

Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know how...

Hello,

Yes, it doesn't make sence for this fiedl to be char(7), but that is so in the source system. I guess I can contact the admin, but just in case...

Sean Lange (11/14/2013)

---

Pretty sparse on details here. Not sure...

Hello Veteran,

Thank you for the reply.

First it is a space issue and also design issue.

However what I need is to keep only the data from the last ~90 days.

Yes, the last one works within my whole script.

Thanks a lot!

Hello and thanks for the replies!

My problem is that I need to use this transformation in SSIS.

Basically Table 1 is my source and table 2 is my destination.

If I use...

For example if I have this table:

Column 1Column 2Column 3Column 4Column 5

A 22 ...

Just a small hint - check if the columns in your destination table allows NULLs and change that.

Thanks a lot!!!

Thank you! 🙂

ok, lets say that the script look like this:

USE master

GO

--Create the main Persons table

CREATE TABLE Persons

(

FirstName varchar(20)

,LastName varchar (20)

,Title varchar(10)

,Email varchar (20)

,IsRowCurrent tinyint

,LastUpdated DATETIME

,ValidFrom DATETIME

,ValidTo DATETIME

)

--Populate...