SQLTeam.com | Weblogs | Forums

Scalar variables

Am executing this scripts on sql 2016 and am getting this error messages

DECLARE @PigSmart_DB_Restore VARCHAR(MAX)

EXEC Import.VerifyPSdbs @PigSmart_DB_Restore OUTPUT

 Msg 137, Level 15, State 2, Line 4

Must declare the scalar variable "@PigSmart_DB_Restore".

DECLARE @Invalid_RFIDs VARCHAR(MAX)

EXEC Import.RFID_Audit @Invalid_RFIDs OUTPUT

Msg 137, Level 15, State 2, Line 5

Must declare the scalar variable "@Invalid_RFIDs"

you are trying to get stored procedure output into variable !!!!

hi hope this helps :slight_smile: