Here is the Question:

I'm fine with declaring the table in the beginning.

I want to check the temp table while selecting - first time through temp table will be empty.

So I...

DML

OUTPUT from Stored Procedure

FOUND a copy of the stored procedure I'm working with----- see below----

DECLARE @ItemClient TABLE

(

ClientSSN Varchar (11),

LastName Varchar...

Mainframe programmer, How would you write an SQL stored procedure to achieve this?