Interesting Idea Phil, a CLR would certainly work, but the question is would the company allow a CLR to be placed on the server.

I know a few companies are...

Ok, I would ask why the change from SSIS to SQL.

IN SQL check out the HASHBYTES function.

eg

SELECT

COL1,COL2, HASHBYTES('MD5',COL1+'|'+COL2+'|')

FROM aTable

One other thing there's no guarantee that you will get...

Could you provide the Basic DDL for the source table along with the INSERT Script with the sample data, as like many others I'm adverse to opening Excel workbooks from...

A similar concept to Eirikur, but with a single CTE and LEFT Join in the main SQL.

WITH CTE_GetLatest

AS

(

SELECT

[Pax Id]

,[Flight Date]

,[Flight Number]

,[Status]

,[Last Mod Date]

,ROW_NUMBER()

OVER

(PARTITION BY [Pax Id],[Flight Date],[Flight Number]...

But why do you want to do this?

What...

Looking at what's been posted I'm linking this is some sort of ETL (or similar) process where you are trying to create a hash key on columns, in order to...

ChrisM@Work (2/12/2015)

It's not uncommon practice for a DBA to pass a poorly-performing query or stored procedure back to the cowboy developer with instructions to improve it. Here are a few...

What you've got is pretty close to what I was thinking, and it resembles a Party Data model, with 4 key tables, and you should get a reasonable normalisation of...

This is the point I was trying to make why cant you just do this

CREATE TABLE #result

(

[Subject] varchar(100)

)

Create Table #result2

(

[Subject] varchar(100)

)

insert into #result ...

Why would you loop through a record set if the output is already a record set...

This article might provide you with the answer http://www.sqlservercentral.com/articles/Tally+Table/72993/

It provides a very efficient string splitter that return a Table.

In addition to Alan.b's link to Gails articles, there are is also another series called Stairway to SQL server Indexes, by David Durant, which is located here http://www.sqlservercentral.com/stairway/72399/

Technically SSIS isn't designed for this type of thing.

You can do Item 1 is simple just use a derived column with IIF logic see here : http://www.programmersedge.com/post/2008/09/30/SSIS-Using-IF(IIF)-logic-in-Derived-Column.aspx#.VNoLb02zVQs

The issue...

For Database design patterns Wiley has a set of three books this is a link to volume 1

http://eu.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html

In terms of Data Warehousing, any book by Inmon or Kimball will give...

This link should help

http://www.mssqlgirl.com/editing-published-ssis-package-in-sql-server-2012.html

I haven't tried to do this.