Hey man - thanks for the reply! Wow - it works great and is definitely a start! Your query was pulling in the 1 number of the duplicated...

I get the following error when trying to run it:

The 'VsDebugPresentationPackage, Version=10.0.0.0, Culture=neutrail, PublicKeyToken=B03f5f7f11d50a3a' package did not load correctly.

However - if you run it as the administrator it runs...

I wasn't able to figure it out in SSIS. I was however able to pass a date variable in a stored procedure and pull the data via linked server....

There wasn't. However - I checked for new MS Office updates and applied those and I am now able to connect just fine. Still not entirely sure what...

So I figured out one solution - which is to go off of the rownumber.

SELECT distinct Order_number, sequnce_num,

--get the special handling codes and show them as columns, max of 3...

Thanks for the replies guy! I used your combined logic and got it to work! Thanks again - love this site!

Thanks for the reply - the problem I have is that I don't always know what the number will be. I have the rules to which I apply to...

Thanks guys - those both worked! Thanks for the help!

That is an awesome and impressive query. Thanks for the help!