Wednesday, January 28, 2015

Query for getting label of Optionset Used in SSRS report


  select t1.activityid,t1. abc_tasktype,t2.value as ActivityName   FROM Task t1
   left outer join StringMap t2 on 
        (t2.AttributeName = 'abc_tasktype'
        and t2.ObjectTypeCode = 4212)

No comments:

Post a Comment