Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TMR.TMR_ID AS "T0_DQ_ID",
- TMR.TMR_CHANGE_COUNT AS "T0_DQ_CC", /* ActionEnablerMarkAsStaffed */ isNull(((CASE
- WHEN TMR.TMR_TSA_ID IN (2, 10)
- AND /* IsPlanner */ isNull(((CASE
- WHEN N'Yes' IN
- (SELECT fna_access
- FROM fna
- WHERE fna_function=(N'teamPlanner')
- AND ((fna_rol_id IN
- (SELECT url_rol_id
- FROM url, usr
- WHERE (usr_id= 104
- OR usr_logon=N'Default')
- AND url_usr_id=usr_id))
- OR (fna_rol_id IN
- (SELECT rgl_rol_id
- FROM rgl, urg, usr
- WHERE (usr_id= 104
- OR usr_logon=N'Default')
- AND urg_usr_id=usr_id
- AND urg_rgp_id=rgl_rgp_id ))) ) THEN N'Y'
- ELSE N'N'
- END)),N'N')=N'Y' THEN N'0'
- ELSE N'1'
- END)),N'1') AS "FldAls87082640"
- FROM TMR TMR
- WHERE ((TMR_ID=372006))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement