The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
SELECT at.shortname as assetshortname, en.shortname as entityshortname, st.shortname as statusshortname, cer.cermodelid, cer.assettypeid, cer.statusid, cer.createuserid, cer.entityid, cer.createdate, description = case when Len( cer.description ) >= 25 then Left( cer.description, 25 ) + '...' else cer.description end from cer_Model cer inner join fin_AssetType at on at.assettypeid = cer.assettypeid inner join ptl_Entity en on en.entityid = cer.entityid inner join ptl_Status st on st.statusid = cer.statusid where cer.createuserid = @UserID order by cer.createdate
Join the community of 500,000 technology professionals and ask your questions.