don't know what happened to the prior post....here it is.

I misunderstood what you were asking for. Usually you would use a GROUP BY to get some aggregate like MIN, MAX,...

Is this what you mean?

SELECT DISTINCT col1, col2, col3

FROM yourTable

Can you show some schema and sample data?

like i said...."but I'm no mathematician;-)"

i think the teacher's question is either incorrectly phrased or the student's description (or interpretation) of the question is incorrect.

perhaps give each answer a point value.

if question 1 has choices A B C D, then value them as 1 2 3 4 and do your calculations on the values....

as far as i know, there is no such thing....but I'm no mathematician;-)

books online, look up STDEV

create an ssis variable like, varSQLCommand string

then use an expression for varSQLCommand:

"select LastName, First name from tblemployer where EmployeeID = " + varEmployeeID +

"union

select LastName, First name from tblemployer

inner...

i've had this same pain myself....

read this:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e7950060-397f-4bbb-b7c9-c2b6b1a7f7c1

basically, try setting "ByPassPrepare" to true and see if that helps.

another way is to build up the entire sql command as a variable and...

and change the query to:

select LastName, FirstName from tblEmployee where EmployeeID = ?

bc

I agree, this is an excellent series. Very thorough. Looking forward to more.

bc

Would this work for you? It will also find 2 letter combinations that aren't valid US state abbreviations, though...

SELECT * FROM sys.databases WHERE name LIKE '%[_][A-Z][A-Z]'

bc

Professional "SQL Server 2005 Integration Services" is a good book from WROX to start with.

You can do your updates and deletes prior to the Fuzzy Lookup Data Flow...

Is Reporting Services an option? Because its incredibly easy using a straight forward query and letting RS group your data in a matrix.

Otherwise take a look at the sql...