/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
+ '~0^0?0!' + CAST(t.int_priority_id AS VARCHAR(1)) -- ~0 - do not notify when missed; ^0 - do not notify when complete; ?0 - should be completed by customer; !1or2 - required priority. --and how it wil be parsed SUBSTRING(str_value, 1, charindex(':', str_value) - 1), NULLIF(SUBSTRING(str_value, charindex(':', str_value) + 1, charindex(';', str_value) - charindex(':', str_value) - 1), ''), NULLIF(SUBSTRING(str_value, charindex(';', str_value) + 1, charindex('~', str_value) - charindex(';', str_value) - 1), ''), SUBSTRING(str_value, charindex('~', str_value) + 1, charindex('^', str_value) - charindex('~', str_value) - 1), SUBSTRING(str_value, charindex('^', str_value) + 1, charindex('?', str_value) - charindex('^', str_value) - 1), SUBSTRING(str_value, charindex('?', str_value) + 1, charindex('!', str_value) - charindex('?', str_value) - 1), SUBSTRING(str_value, charindex('!', str_value) + 1, 8000)