Without seeing your actual script the error could be caused by a permissions issue...

nice, thank you!

Using SSMS, does this work:?

EXEC master..xp_readerrorlog

I answered all the questions correctly but it still scored me as wrong!

What's up with that?

Yet again the answers don't match the questions, so it is impossible to get right.

Can SSC fix this one?

( I choose three answers, since the fourth correct answer is unavailable...

Have SSC fixed the problem of questions not matching the answers?

I got 0.46875 when I ran the script.

What's up with that?

use except to find the records you need

wrap that up as a sub query

use the sub query as a filter for the records you want all columns from

If you consider that SSRS 2008 has many of the fancy Dundas charts (along with many other features) you can kind of understand why it's not simple to have that...

You cannot deploy SSRS 2008 reports to SSRS 2005

Try

select

case

when vCurrencyValue < 1 then replace(convert(varchar,cast(vCurrencyValue*100 as decimla(20,2)),1),'.00','')

else replace(convert(varchar,cast(vCurrencyValue as decimal(20,2)),1),'.00','')

end as vCurrencyValues,

iDYNCurrencyId,vCurrencyType,vCurrencyDesc,bFCurImagePath,bBCurImagePath,vAltName

from DYNCurrency

where iDYNCatId=6

order by iOrderNo,vCurrencyValue

Your are casting to a money type which may not hold the result of a decimal(18.2) * 100

Try casting to a larger decimal type.

have you tried a full outer join?

If you could group your products in some way that would help.  Then you could have two dropdowns, the first would select the product group and the second would display...

There is a mistake in the article.

Where it says "Returns a value of 5.", the line above should be scope_identity() instead of @@identity

Jim.