Lowell (1/31/2014)

---

not sure how much help this would be.

the CTE below is just so I have a table that represents the data you provided.

only the select is the part you'd want to look at.

i think this brackets the data you are asking for; it does identify the rows based on a beginning value and an ending value.

so do you need the subsequent rows as a single row of data?

;WITH MyCTE([ID],[FullContent])

AS

(

SELECT '446','Primary days: Mon Tue Wed Thu Fri' UNION ALL

SELECT '447','Secondary days: Sat Sun' UNION ALL

SELECT '448','No access restrictions' UNION ALL

SELECT '449','Expiration: (none) Pwdminimum: 8 Login Fails: 0' UNION ALL

SELECT '450','Pwdlifetime: 30 00:00 Pwdchange: (pre-expired)' UNION ALL

SELECT '451','Last Login: (none) (interactive), (none) (non-interactive)' UNION ALL

SELECT '452','Maxjobs: 0 Fillm: 1024 Bytlm: 130000' UNION ALL

SELECT '453','Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0' UNION ALL

SELECT '454','Maxdetach: 0 BIOlm: 4096 JTquota: 8192' UNION ALL

SELECT '455','Prclm: 10 DIOlm: 4096 WSdef: 100000' UNION ALL

SELECT '456','Prio: 4 ASTlm: 250 WSquo: 200000' UNION ALL

SELECT '457','Queprio: 0 TQElm: 20 WSextent: 210000' UNION ALL

SELECT '458','CPU: (none) Enqlm: 2000 Pgflquo: 4000000' UNION ALL

SELECT '459','Authorized Privileges:' UNION ALL

SELECT '460','ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS' UNION ALL

SELECT '461','CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP' UNION ALL

SELECT '462','GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT' UNION ALL

SELECT '463','NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL' UNION ALL

SELECT '464','PRMMBX PSWAPM READALL SECURITY SETPRV SHARE' UNION ALL

SELECT '465','SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX' UNION ALL

SELECT '466','UPGRADE VOLPRO WORLD' UNION ALL

SELECT '467','Default Privileges:'

)

SELECT * FROM MyCTE

WHERE ID > (SELECT ID FROM MyCTE WHERE FullContent = 'Authorized Privileges:')

AND ID < (SELECT ID FROM MyCTE WHERE FullContent = 'Default Privileges:')