Welcome to (andygiddings.com) (
email
)
T-SQL Programming Tips
Raiseerror Example
-- Each visible error can show about 300 characters --SET @strWhere = SUBSTRING (@strWhere,2100,8000) --RAISERROR('%s', 16, 1, @strWhere ) --RETURN
Order by variable Example
-- @strOrderBy comes from sprSurvey_ReportOrder_Lookup originally ORDER BY CASE WHEN @strOrderBy='BUILDINGNAME' THEN prpDisplayName ELSE ISNULL (prpAddressStreet, '') + ISNULL (adrDirection, '') END , prpAddressNumberSort, prpID