Is it possible to combine a stored procedure result set and a table into one dataset? For example, if I have a stored procedure with field "TradeID", and a table with "TradeID", can I join the them in a dataset?
Thanks.
Brad
If you mean a SQL style join at the dataset level then the answer is no.
You could always use a batch of SQL instead of a simple select and use temporary tables within the query to perform the JOIN. Even better create a stored procedure to do it.
If the data is coming from different databases/platforms then could use linked servers.
sqlsql
No comments:
Post a Comment