|
rtimson261 -> How do I amend my query to select specific row numbers? (6/18/2008 10:14:38 AM)
|
Hi,
I have the following query and wish to amend it to be able to specify which rows I want to select from it. the reason for this is to be able to split the output into manageable chunks for an Excel workshhet to handle it. So in essence I want to be able to say select row 1-70000 then change the query to return rows 70001 - 140000. The query I am starting with is.
select o2.Name0 AS 'Machine Name',
o1.Name0 AS 'User ID',
o1.ScreenSaverActive0,
o1.ScreenSaverExecutable0,
o1.ScreenSaverSecure0,
ScreenSaverTimeout0
from v_gs_desktop o1
left outer join v_r_system o2 on
o1.resourceID = o2.resourceID
Order by o2.Name0
Hope someone can hepl as this has been driving me nuts for hours now. I have trawled the web and all I have found I have not been able to adapt to this query.
Thanks
Rob
|
|
|
|
