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