when this is in there, it screws things up and the query brings back no results:

WHERE DR.customernumber IS NULL

when I take that out, the query brings in all the numbers...

Tables have the same data types

This below brings back no results which is not possible, it should be brining back some accounts.  I also tried a top 1 because I basically just want one instance...

jeff, but I don't want a left join...I don't want ALL customers, only the ones who are not in the DR table AND then in my list...all others should not...

Whitespace shouldn't matter in a sql query.

also, my query runs the where clause, just that it's picking up all accounts.  I want it to insert only those customers who are...

rdl is here, the 2nd InHouse footeter field

http://www.photopizzaz.biz/dcr.zip

oh, no, what i need is one sum returned..the value by the rollup...there should only be one value, not a whole line

Ken could you help me form mine with your suggestion?

I tried:

Select (cast(FGoal as numeric(30,2)) / FeeSched) * 100 AS gt

from DR WHERE branch='00002'

group by CustomerName,

           CustomerNumber,

           FGoal,

           FeeSched

order by...

Thanks a lot!

Tried that already.  When I tried this:

SUM(Fields!GrossGoal1.Value,"CustomerNumber_Grp")

it tells me that I cannot reference a field that is not in the footer scope

See my other 2 posts (read...

Thanks, the ISNULL worked!!

Thank you!

Thanks both of you!

Ok, for now I tried this but get errors:

            CASE WHEN Len(c.FeeSchedule) < 3 then

                  CONVERT(int, c.feeSchedule)

            ELSE

                  CASE WHEN (Select Count(*) FROM FeeScheduleDetails fd INNER...