At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.