Is the value of the variable itself an expression?

Risking sounding repetitive, but...

What does this mean?

Please answer Sean's question. 'To deal' is not a well defined verb in the T-SQL world.

This needs to be refined....

If you create a constraint that void < ticket, does that help? (Assuming ticket is an identity column.)

svanduffelen 83303 (4/27/2015)

---

This is a single table problem with two columns and 5 data integrity rules.

1.) The First Column is the primary key, Ticket, of type Integer

2.) The Second is...

As an aside, storing dates as nvarchar(50) is generally considered a really bad idea.

You could try something like this (untested because you did not post DDL, sample data etc):

with OrderedSet

as (

...

This won't help you right now, but maybe in future. You should put some sort of unique constraint on your table which would result in an error if such a...

Anshul Parmar (4/24/2015)

---

Package 1 –

It is not a good practice to create a database and tables in SSIS packages.

I'll suggest if it is an initial load, create all databases and...

De-duplicate your source before merging, or find a better match key.

Sure. Always match on a unique key (must be unique in both source and target).

Do you mean a fixed-width file?

I've never heard of a fixed-length file before.

One way of achieving this is by creating your source query such that you get one row per job code history. So, get results that look like this:

(EmployeeNumber, FirstName, LastName,...

This is correct. It needs to exist at design time.