View: dbo.Full_Tax_Code_View | |||
View definition | |||
CREATE VIEW dbo.Full_Tax_Code_View AS SELECT code.tax_code_KEY , code.client_KEY , CASE WHEN (code.tax_subcode = N'') THEN code.tax_code ELSE (code.tax_code + N'-' + code.tax_subcode) END AS description , dbo.sf_Generate_Sortable_Id(CASE WHEN (code.tax_subcode = N'') THEN code.tax_code ELSE (code.tax_code + N'-' + code.tax_subcode) END) AS description_sortable FROM dbo.Tax_Code AS code | |||