Table-Valued Function - Returning Specific Column Values in Stored Procedure 1

[larrydavid]

Hello,

I have 6 possible values that can appear for 6 columns in a join table. Is it possible to return specific column values from a table-valued function and map those values to these columns? If so, could someone please provide a quick snippet or link to where I could see a code sample of this?

I am trying to avoid writing 6 separate scalar functions. Hope this makes sense.

Thanks,
Larry

 

[bborissov]

You can use table-valued function as an ordinary table, just give it an alias:

SELECT Something
FROM MyTable
INNER JOIN dbo.TableFunction Tbl1 ON MyTable.Cloumn1 = Tbl1.ColumnName ...

Borislav Borissov
VFP9 SP2, SQL Server

 

[larrydavid]

THANK YOU BORIS! You're the man! --Larry