Must declare the scalar variable "@select"

Transact-SQL
1

[SqlException (0x80131904): Must declare the scalar variable "@select".]

2

That is not helpful at all. You need to post your SQL Statement that is generating that error.