Skip to content

Instantly share code, notes, and snippets.

@ivanjr0

ivanjr0/alvaro.txt

Created April 27, 2017 20:50
Show Gist options
  • Save ivanjr0/22f0f1cdcfd8139d287b187b4d3a0e07 to your computer and use it in GitHub Desktop.
Save ivanjr0/22f0f1cdcfd8139d287b187b4d3a0e07 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alvaro.txt
DECLARE @SQL varchar(max);
set @SQL =
'
SELECT ''TFA-2073-TR04-PIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-PIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-13'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-13" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-06'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-06" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-05'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-05" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-WIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-WIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-14'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-14" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-07'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-07" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-PIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-PIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-SIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-SIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-07'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-07" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-08'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-08" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-05'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-05" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-11'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-11" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-WIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-WIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-SIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-SIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-10'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-10" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-09'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-09" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-08'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-08" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-06'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-06" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-10'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-10" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-SIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-SIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-PIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-PIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-12'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-12" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-TIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-TIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-PIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-PIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-15'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-15" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-TIT-09'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-TIT-09" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR2073VG02-WIQ-001'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR2073VG02-WIQ-001" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-IIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-IIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-AL01-SIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-AL01-SIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-07'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-07" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR2073VG02-WIQ-002'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR2073VG02-WIQ-002" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-06'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-06" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-JIQ-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-JIQ-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-IIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-IIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-IIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-IIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-JIQ-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-JIQ-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIQ-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIQ-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-JIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-JIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-JIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-JIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-JIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-JIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-JIQ-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-JIQ-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIQ-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIQ-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-09'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-09" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-SIT-05'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-SIT-05" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIQ-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIQ-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-08'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-08" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-IIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-IIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-SIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-SIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-IIT-03'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-IIT-03" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-JIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-JIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-JIQ-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-JIQ-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-SIT-04'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-SIT-04" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-IIT-01'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-IIT-01" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-JIT-02'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-JIT-02" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-SIT-05'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-SIT-05" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-SIT-001'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-SIT-001" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR03-WIQ-001'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR03-WIQ-001" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR04-WIQ-001'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR04-WIQ-001" ORDER BY ip_trend_time UNION
SELECT ''TFA-2073-TR02-WIQ-003'' as tag, MIN(ip_trend_time) FROM "TFA-2073-TR02-WIQ-003" ORDER BY ip_trend_time UNION
SELECT ''VGR2-2073-WIQ-02-D'' as tag, MIN(ip_trend_time) FROM "VGR2-2073-WIQ-02-D" ORDER BY ip_trend_time UNION
SELECT ''VGR2-2073-WIQ-01-D'' as tag, MIN(ip_trend_time) FROM "VGR2-2073-WIQ-01-D" ORDER BY ip_trend_time
'
EXEC (@SQL) AT IPTFA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment