sql server set a variable from With table result code example

Example: sql declare table variable

DECLARE @TABLE TABLE( COL1 INT, COL2 VARCHAR(30))