February 16, 2012 at 3:32 pm
Hi guys, the below query works fine until I try to put it into SSRS when it complains that I have already defined the @ variables. Can you help please?
declare @week int
declare @month int
declare @rest int
set @week=(SELECT count(vrs.name0) from v_r_system vrs
inner join v_gs_workstation_status gsw on vrs.resourceid=gsw.resourceid
where DATEDIFF(day, gsw.LastHWScan, GETDATE()) <=7 and active0=1)
set @month=(SELECT count(vrs.name0)
from v_r_system vrs
inner join v_gs_workstation_status gsw on vrs.resourceid=gsw.resourceid
where (DATEDIFF(day, gsw.LastHWScan, GETDATE()) >7 and DATEDIFF(day, gsw.LastHWScan, GETDATE()) <=30))
set @rest=(SELECT count(vrs.name0)
from v_r_system vrs
inner join v_gs_workstation_status gsw on vrs.resourceid=gsw.resourceid
where DATEDIFF(day, gsw.LastHWScan, GETDATE()) >30 and active0=1)
SELECT count(vrs.name0) as 'Total',@week as 'Week',@Month as 'Month',@rest as 'Rest'
from v_r_system vrs
left outer join v_gs_workstation_status gsw on vrs.resourceid=gsw.resourceid
where active0=1
February 16, 2012 at 3:49 pm
Ignore, I've sorted....:crazy:
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy