RE: Resultset from SP into table

From: bknopp@xxxxxxxxxxxxxxxxxxxx (Brian Knopp)
Date: Tue, 28 Nov 2006 23:20:18 GMT

Hey, Joe,

I've taken a few cuts at this issue, looking for a pure SQL Server based
solution based solely on the stored procedure, with no success. I know you
don't want to modify the stored procedures -- how much flexibility do you
have with such things as adding a vew that matches the query at the end of
the stored procedure, that sort of thing?

Best regards,

Brian Knopp
Microsoft SQL Developer Support

Note: This posting is provided "AS IS" with no warranties, and confers no
rights.

.

Prev by Date: RE: TDS_RET_STATUS exception
Next by Date: RE: JDBC 1.1 - Problem SP with resultSet + output parameter
Previous by thread: RE: TDS_RET_STATUS exception
Next by thread: RE: JDBC 1.1 - Problem SP with resultSet + output parameter
Index(es):
- Date
- Thread

Relevant Pages

Re: Stored Procedure Error Question
... be to return a value different from zero, for example 1 in case of success ... parmReturn is zero if the SP fails. ... creating a test table and stored procedure. ... DECLARE @err2 INT ...
(microsoft.public.access.adp.sqlserver)
OLE DB CAccessor problem
... that is used for giving parameters to a Stored Procedure and retrieving the ... The stored procedure saves the message text in the database, ... success or failure. ...
(microsoft.public.data.oledb)
Re: Appdomain.CreateDomain throws SecurityException
... Communication of any success or failure messages back to the calling ... Launching the external process may be quite costly, ... a good choice if the stored procedure is called often from client code. ...
(microsoft.public.dotnet.security)
OLE DB template probs
... The stored procedure saves the message text in the database, ... success or failure. ... However, when I run the SP from my code, I get a debug assertion ...
(microsoft.public.vc.atl)