If I do it like this, I just get one record...

Thanks for your help!

CSDunn

Sorry for the confusion. Each Acctcode can be associated with up to seven products. I need to return all acctcodes with each assciated product unless the acctcode = 'xh364'. In...

Thanks for your responses. I'm going to do more troubleshooting, and I'll come back to this if a solution does not arise from my findings.

Thanks for the responses. I'm going to have to take another look at it.

It looks like this might work.

Thanks again for your help!

with the CASE nested in the SUM, I got this:

Msg 130, Level 15, State 1, Line 5

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

I never thought to just copy and paste the 'box' into a replace function. That worked. I set the 'convert binary data' in the DSN first, but that had no...

A Sample of errant data looks like this:

901 Hwy 282 SW?

You should see a box...

Thank you for your help!

CSDunn

tbl_PaymhistCurrentWeek

( AcctCode varchar(10) Default '' Not Null,

Co char(2) Not Null,

AcctCodeWithZeros varchar(20) Null

CONSTRAINT (PK_PaymhistCurrentWeek) Primary Key Clustered

(AcctCode, Co)

)

Check out the information in this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1209825&SiteID=1

There is at least one other URL within this post that you should also look at.

CSDunn

Never mind on this. I wound up using a script task.

CSDunn

Never mind on this. I put the code into a table UDF, and the UDF appears to overcome whatever beef SSIS has with the raw SQL statement.

I can't belive I didn't see that BEGIN and END were out of place. Thanks!

CSDunn