Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- STUFF((SELECT DISTINCT '','' + VALUE_FOR_GENERAL + '''' FROM #TEMP_CASE B WITH (NOLOCK) WHERE A.[SYSTEM_CODE] = B.[SYSTEM_CODE] AND A.[FIELD_FOR_GENERAL]= B.[FIELD_FOR_GENERAL] FOR XML PATH(''''),TYPE).value(''(./text())[1]'',''NVARCHAR(MAX)''), 1, 1, ) VALUE
Add Comment
Please, Sign In to add comment