MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
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
|MS SQL: Create User Function to Remove Long Words||5||32|
|Getting invalid Syntax SQL.||3||20|
|SQL Find Carriage Return and Delete it.||3||13|
|MS SQL and inserting dates into tables using stored procedures||6||17|