Hi,
If the record is inserted all you may need is the generated ID, all the
other info being inserted you already have it. In this case you can use a
parameter.
If the record exists then you already have all the info you need, why are
you getting back the same info?
unless you do some transformation of the data you already have the info
being inserted .
Additionally IIRC the DataReader can access all the result sets, it does has
a NextResult that advance to the next recordset
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Varangian" <of****@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
>I have an SQL Server 2005 Express Stored Procedure .. which first I
select if that record exists, if it exists I update that record .. if
not I insert. It then selects the record with the new data updated or
inserted...
however the .NET SqlDataReader always takes the first query results
(which the query that first ran to check if that record exists) .. How
can I take the second query results?. I can use the Try Catch but that
will reduce the system performance..
thanks all!