Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @zone_peril VARCHAR(MAX)
- DECLARE @input_table VARCHAR(MAX)
- DECLARE @SQL VARCHAR(MAX)
- SET @input_table = '2018_1_PROJECTED_INPUT_AUAP'
- SELECT @SQL = 'SELECT RIGHT('''+@input_table+''',4)'
- EXEC(@SQL)
- SELECT @SQL = 'SET'+@zone_peril+' = SELECT RIGHT('''+@input_table+''',4)'
- EXEC(@SQL)
- SELECT @zone_peril
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement