if you are using vista premium, you wont be able to preview the report - unless via Visual Studio or BIDS. The SSRS wont run on vista premium.

Are you sure you managed to install Reporting Services on Vista? I dont think that will work....

Also what are you expecting to see? For example connecting to IS will only...

could you just

cast(@yournumber as money)

The trick is in the order by! One ascending & one descending...

You can change the numbers in the TOP 🙂 Its just to give you an idea of where to look... good luck

Would something like this work??

SELECT TOP 9 *

FROM mytable a

WHERE a.mycolumn IN (SELECT TOP 10 *

FROM mytable b

ORDER BY mycolumn)

ORDER BY mycolumn DESC

IF ((SELECT a.holidaydate FROM holidays a WHERE a.holidaydate = @datepassed-7) IS NOT NULL)

SET @datereturn = @datepassed-8

ELSE SET @datereturn = @datepassed-7