Function returning two values....?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lance Sanders SSC Eights! Points: 903 More actions · Answer 1

Scalar? No.

Table-valued? Sure...

CREATE FUNCTION SalesByStore (@storeid varchar(30))

RETURNS TABLE

AS

RETURN (SELECT title, qty

FROM sales s, titles t

WHERE s.stor_id = @storeid and

t.title_id = s.title_id)

GO

select * from SalesByStore(3)

Bagath SSCrazy Points: 2409 More actions · Answer 2

SSCrazy

Points: 2409

August 1, 2006 at 11:17 pm

Thanks For your solution...:-)

Rao Aregaddan.

Cookies on SQLServerCentral