yes i have tried to refresh the local cache and no different

Tom,

Thanks for the guidance. This works for the single PCN_Key but we have 7 other PCN keys that i would the sproc to pull together at...

I am not that familiar with SPROCs and am learning on the fly here. I tried to create another callout sproc that would identify the values for the parameters...

I receive the command completed successfully message. I can even execute the sproc with no issues but when i query the tblStdCost table, there is no data in there.

The sproc166848_58075_1335485 does not act upon the tblStdCost as i am just trying to get the results on this sproc to populate this table at the end of the processing....

that is correct. delete from table and then reinsert.

what we are utilmately trying to do is run this procedure on a daily or weekly basis to pull in the actual price of our material to load into a...

One last piece of advice i need. i am able to run this for the first time, but i need to delete the dbo.tblPlexActualPrice table everytime the SPROC runs...

worked perfect. thank you

Thanks for the information but i dont what the table to be a temporary table in the tempdb database. I need it to appear in the ConstarOLAP_PROPHIX_FactDB where the...

When executing the SPROC, i still receive this error message about line 7 at or after the <AS> token

OLE DB provider "MSDASQL" for linked server "PLEXREPORTSERVER" returned message "[Plex][ODBC ODBC...

actually received this error at the end of the message when the SPROC was executed

Msg 214, Level 16, State 3, Procedure sp_executesql, Line 1

Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

When i go into my tables, i do not see the tblActualPrice table. The SPROC when it was executing did return a value.

When i copied the sql code from...

The SPROC was able to execute but i cannot see the table of dbo.tblActualPrice anywhere.

adding the PRINT @finalquery statement throws an incorrect syntax near the keyword 'PRINT' error message.

We have it listed twice so i sp_executesql will run.