Exporting SQL server table variable

Hello

I am trying to export data from SQL server table variable

Here is simple T-SQL code I use

Declare @CSA table (ContractID int, CustomerID int, DuesAmount varchar(9),
FreezeDuesAmount varchar(9), ItemID int, Proration varchar(9), TermCost varchar(9))
Insert @CSA
Select 1 ContractID, 2 CustomerID, 3 DuesAmount, 4 FreezeDuesAmount,
5 ItemID, 6 Proration, 7 TermCost
select * from @CSA

It fails with an error and does not export anything

Please help me asap,
Antonio

Antonio

Put nocount on into the script than it will work.

begin
set nocount on
Declare @CSA table (ContractID int, CustomerID int, DuesAmount varchar(9),
FreezeDuesAmount varchar(9), ItemID int, Proration varchar(9), TermCost varchar(9))
Insert @CSA
Select 1 ContractID, 2 CustomerID, 3 DuesAmount, 4 FreezeDuesAmount,
5 ItemID, 6 Proration, 7 TermCost
select * from @CSA
end