Viewing 7 posts - 1 through 7 (of 7 total)
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.
May 12, 2009 at 7:01 am
#992842
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...
May 12, 2009 at 6:36 am
#992803
could you just
cast(@yournumber as money)
March 12, 2009 at 6:48 am
#958261
The trick is in the order by! One ascending & one descending...
January 22, 2009 at 5:48 am
#931055
You can change the numbers in the TOP 🙂 Its just to give you an idea of where to look... good luck
January 22, 2009 at 5:33 am
#931038
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
January 22, 2009 at 5:26 am
#931032
IF ((SELECT a.holidaydate FROM holidays a WHERE a.holidaydate = @datepassed-7) IS NOT NULL)
SET @datereturn = @datepassed-8
ELSE SET @datereturn = @datepassed-7
December 8, 2008 at 8:38 am
#909173