I have a transformation that I copy over the contents of a dbase table. I have added a column and would like to call a function that returns a value based on the sku, and storeno in that dbase table. So I call the function in query analyzer as so

select dbo.SKUAverageCostPerStore (@sku, getdate(), @storeno

* returns a float AVG_COST which goes into column AVERAGE_COS

I can get the @sku, @storeno from the record that I have am transforming into a sql table

How can I call this function to return the AVG_COST and then map that to the column AVERAGE_COST

Thanks for the help

You could use a plain and simple SQL Query right?

How about lookups

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"AshleyT" <anonymous (AT) discussions (DOT) microsoft.com> wrote

based on the sku, and storeno in that dbase table. So I call the function
in query analyzer as so: