Michael L John (5/26/2015)

---

anjaliagarwal5 (5/26/2015)

---

Hi All,

I have to modify a stored procedure that is written by someone else.Basically the stored prcoedure uses a cursor to fetch the data...

Luis Cazares (5/26/2015)

---

This might work for you. I'm not sure if we're missing something you left out, so you might need to tweak some things.

BEGIN TRY

BEGIN...

Thanks for all your help. Works great!!

Learned something new!!

Thank you.

In the above code, after creating the table, should I insert the data into the #OUTPUT table right after creating it so

BEGIN TRY

BEGIN TRAN

...

Sorry, they are typos.

I created the table this way

create TABLE TableA

(

HNum VARCHAR(4)

,DTG BIGINT

,mID VARCHAR(6)

,filterKey VARCHAR(6)

...