Hi,
I want to retrieve data from 2 tables with a single procedure by, so how can it be possible if a 1st table returns 2 tuple rows and 2nd table return 1 row and I want to combine the 2nd table data to the rows of 1st table.So how can it be possible.I need
for Crystal Report.
Okay,data need not be combined, the deisrable result is that I want get data of two table in a single dataset ds when I called this procedure form my .aspx page.
Here's the procedure
ALTER PROCEDURE billDetails
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
@billno varchar(10)
AS
BEGIN
select orderid,bookid,bookname,quantity,price,totalprice,billnumber FROM ShoppingCart WHERE billnumber=@billno
select name,contact,shipaddress,amount from PaymentDetails where ...
Go to the complete details ...