Take the 2-minute tour ×

i have scalar valued function which is called and it gives a new column values in the table, now I want to join this new column value to a column of new table which I have added as derived table in sql server 2005.

share|improve this question
Can you provide more details? A code sample, even a non-working one, of what you've tried so far would be helpful. –  Joe Stefanelli Sep 20 '12 at 15:48
add comment

1 Answer

You can certainly use that function in a JOIN, something like this:

SELECT {fieldlist}
FROM {tablename} a
    JOIN {tablename} b ON b.{fieldname} = dbo.{functionname}({parameters})

But, as Joe stated, a code sample would make this a bit less theoretical and more useful for the rest of the community.

share|improve this answer
add comment

Your Answer


