/SQL/Store select query result in variable sql server

Store select query result in variable sql server

DECLARE @result1 TABLE (a INT, b INT, c INT)

INSERT INTO @result1
SELECT a, b, c
FROM table1

SELECT a AS val FROM @result1
UNION
SELECT b AS val FROM @result1
UNION
SELECT c AS val FROM @result1

Source: stackoverflow.com

Similar codes

3 votes166 views1 answer
What is having clause
SQL
0 vote202 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote192 views1 answer
Postgres cast as currency format
SQL
3 votes169 views2 answers
Mysql create timestamp column
SQL
0 vote179 views1 answer
Oracle procedure chain step
SQL
0 vote180 views2 answers
Oracle chain rules
SQL
0 vote171 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes180 views6 answers
List all tables in postgres
SQL
0 vote261 views1 answer
Linux upload database to mysql
SQL
16 votes174 views1 answer
CTE statement sql server
SQL