you are very welcome. 🙂

You cant use output parameters in functions

if i understand correctly you want to return more than one value, i.e.

you could use table functions...so you can return a table.

create function TableFunction(@parameter1...

a function is used in select, and returns a resultset (scalar or table, depends on the function type)

thats why a function cant use output parameters

i think this article would help...

why you want an output parameter?

why dont just return a scalar value.

http://msdn.microsoft.com/es-es/library/ms186755.aspx

i think this is what you want..

select convert(datetime,convert(varchar,getdate(),112))

and you will get this...

-----------------------

2009-09-18 00:00:00.000

(1 row(s) affected)

hello emily-1119612

why dont you try this

UPDATE #Manufacturers

SET Manufacturer_Date = B.MIN_PRODUCT_DATE

FROM #Manufacturers

INNER JOIN #Products ON #Manufacturers.ManufacturerID = #Products.ManufacturerID

INNER JOIN

(

select ProductId, MIN(Product_date) MIN_PRODUCT_DATE

from #productinfo

GROUP BY ProductId

) B

ON #Products.ProductID =B.ProductID

hello middletree.

Im not sure if thats possible.

what you could do, is restore that backup on a new database, and copy the data you need