Hi Lynn

receiving this error executing the code:

HResult 0x8B, Level 15, State 1

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Server NSAB-SS80-SQL-N, Line 5

Must declare the scalar variable "@idxname".

Jim