This is actually rather simple. When a stored procedure that is written as a select statement is returned from VB, it is returned as a recordset.
First create your stored proc and make sure it's installled on SQL Server See the example in this thread. If it's a simple stored proc without...
OK, I want to return a result set that looks similar to this:
id region
----- -------
00001 US
EUR
ASIA
00002 EUR
ASIA
00003 SA
US
What's happening here is that the id is the same where the blank spaces are. So...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.