Hi,
Is there a way to create a Store Proc that returns a non-integer value? e.g.

ALTER PROCEDURE dbo.spGetProjectDateOfWeek
( @ProjectID nvarchar(10),
  @BatchCode nvarchar(10),
  @WeekNo int,
  @DateOfWeekN datetime OUTPUT
   )
AS
    SELECT @DateOfWeekN = DateOfWeekN FROM ProjectDateOfWeekTable
    WHERE ProjectID = @ProjectID
    AND BatchCode = @BatchCode
    AND WeekNo = @WeekNo


I would like the stored proc to return the @DateOfWeekN. I tried this code but it doesn't return any value.

When I used "RETURN @DateOfWeekN", @DateOfWeekN must be integer. This returns an integer value and not the actual date of @DateOfWeekN. I would like the actual date to be returned by the stored proc not the integer type.

Thanks so much in advance!

Why dont you use a function to do that rather than using a stored procedure?

_________________________
- Vijay G
Strive for Perfection

To get the output parameter of your SP, you do it this way:

declare @DateofWeekN DATETIME
execute dbo.spGetProjectDateOfWeek 'ProjectID', 'BatchCode', 1, @DateofWeekN OUTPUT
select @DateofWeekN

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Hi Vijay G,
I have created a UDF in SQL and it worked. But how do I call that in my application, ASP.Net for example. Thanks again! :)

You should be calling it using Hope that helps.
Cheers.

_________________________
- Vijay G
Strive for Perfection