Hi Seth,

I have included the code saying

If not Exists(select * from EmpGrpwiseData join AposGrpwisetest on...

Simply awesome that worked like a magic. Final question is that if i execute the procedure with the same payor. It is appending the data again. How would i insert...

Hi Seth,

Yes it is a Temp Table preceded with #.

Please see the code below. Am selecting data from the AposGrpwisetest and dumping it into AposGrpwisetemp Table.

Not quite...

oops forgot to mention the error

Error:

Msg 208, Level 16, State 1, Procedure pGetReportData

Invalid object name 'AposGrpwisetemp'.

Awesome u da man. I changed the field length and it worked. The only final work remaining will be. Can i select the process data into a table or something...

Sorry my bad i was still referencing the old table. I got rid of the error.

Now i have added an update statement after the exec statement and the...

Hi seth,

Thanks for the reply. I am able to gain some knowledge i guess. I created the...

Yes i just want to add the report numbers literally regardless of the client. There is no relation. Also i want to update the client_id,client_name that i get from oracle...

I think i have the wrong code posted. Please check the code below.

My whole requirement is dump the data from the oracle which doesnt have report numbers into the sql...

Hi seth Tahnks for your patience. Well actually i dont have the report number in the SUmmary Table in the Oracle. So am trying to add the report numbers dynamically...

Hi seth, I have tried the query with rownum and it has data in it.So i dont think am having any problem with that. Only problem i think now is...

Thanks for getting back again. Okay i think i should be more clearer when explaining this stuff. The procedure is executing now but it is not pulling any data.

My question...

Hi seth you da man. After following your instructins i was able to nail down on the errors. but i still cannot find the logic for looking into all payors...

Hi there Thanks for getting back. The links reaaly helped me a lot. Am actually was able to execute the procedure with some values. But am having difficulty in selecting...