sql server 2000 - Variables and stored procedures -


As a follow-up to me, I have to know that there is a simple way to do the following (which is not compiled ):

  create table # PV ([ID] INT, [date] Datestim, Dis Float, Del Float, Sold Float) INPET # PV @ ID, APP PACSUMRI Report @ ID, @ PID , @ S, @ till  

I need to join # PV on the second table through [ID] But the basic stored procedure does not have the required parameters.

It is difficult to update SP (not impossible) because the code is 'out-in-the-wild' and I get 'GetPVSummaryReport2' Already many) do not want to like

  create table # PV ([date] datetime, dis float, del float, sold float ) Select INSERT # PV as GetPVSummaryReport @ID, @ PID, @, @ ID, [ID], * PV  

or

or

  Create Table # PV ([ID] INT Zero, [Date] Datestim, Disable Float, Del Float, Sold Float) INPART #PV ([Date], Dispatch, Del, Sold) GetPVSummaryReport @ID, @PID, @ From, @To UPDATE #PV SET [ID] = @ID SELECT * FROM #PV  

Comments

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

sockets - Delphi: TTcpServer, connection reset when reading -

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -