Problem returning two values from stored procedures

Hi, i am trying to return two values from SQL 2000 using a single stored procedure. The stored working fine in Query Analyser and returns the two values and two grids in the results window.

My problem is that when i execute the stored procedure using ADO.Net the dataset only has one of the values. e.g TId : 2, where it should read 'TId' : 2, 'ConfigPath': 'C:\blah'

Please could anyone shed ligth on this problem?

here the code for the stored procedure:

CREATE PROCEDURE dbo.GetTillInfo
(
@.TillIdR varchar(50),
@.Password varchar(50)
)
AS

declare @.TillId int
declare @.configpath varchar(150)

IF Exists (SELECT Id FROM Tills WHERE TillRef=@.TillId and TillPassword=@.Password)
BEGIN

set @.TillIdR = (SELECT Id FROM Tills WHERE TillRef=@.TillId and TillPassword=@.Password)
select @.TillIdR as 'TId'

set @.configpath = (SELECT configpath from customer,tills where
tills.customerid = customer.id and tills.id = @.login)
select @.configpath as 'ConfigPath'
END
ELSE
BEGIN
set @.TillIdR = 0
select @.TillIdR as 'TId'
set @.configpath =''
select @.configpath as 'ConfigPath'
END
GOOff the top of my head, the two results may be returned but in two tables as you are performing two selects.

To get round this you could change your select query to return the two values like:-

IF ...
 set @.TillIdR = (SELECT Id FROM Tills WHERE TillRef=@.TillId and TillPassword=@.Password)
 set @.configpath = (SELECT configpath from customer,tills where
 tills.customerid = customer.id and tills.id = @.login)
 select @.TillIdR as 'TId', @.configpath as 'ConfigPath'
END
ELSE
BEGIN
 set @.TillIdR = 0
 set @.configpath =''
 select @.TillIdR as 'TId', @.configpath as 'ConfigPath'
END
GO

This is off the top of my head at work - you may have to play with the stored proc.

Rob

Problem Report Making.

Hi !

I've an table which have 32 Columns. Table will Normally have 15 records. Because in A-4 Size paper 32 Columns cannot appear in single partition. I want to make double partitioned report which contains 16 column with 15 records in upper portion & remaining 16 columns and records in lower half portion.

I've attached word file for example.

How I complete this task ?

thanks in advance.You can use a subreport in this case.
Show columns 1-16 in your main report and 17-32 in a subreport.|||thanks.

I'm using ado .net dataset as a datasource. In the main report dataset showing table schema but in the sub report it is not showing table schema. can u guide me ?|||I guess you've used a cross-tab in your mail report. Right?
Use a cross-tab in your subreport as well.