Thanks All. Got it working.

DECLARE @CustNo VARCHAR(MAX)

DECLARE @SQLQUERY VARCHAR(MAX);

SET @SQLQUERY = ''

SET @CustNo = ''

declare c1 cursor for

select CUST_NO from AR_CUST where TERMS_COD = 'CASH'

open c1

fetch next from...

I did get the xp_cmdshell to work correctly by fixing the apostrophes. But how do I get the @CustNo variable to equal whatever value the loop is currently on?

DECLARE @CustNo...