i create a Table valued userdefined function in sqlserver,,
in the table two columns inserted ,,
iwant to call a a One colum within a select statemet
.....
I eant this mode answer
my fuction name is Balance
My table is @Table (Dr,Cr)
i call the function
Select Dr from dbo.balance
This query gives correct answer,,,,
but i want to Select
Select Dr from dbo.balance,Select Cr from dbo.balance ?
is this possible at select statement?
Loading
Anil KumarPosted Jun 1, 2012, 2:17 AM
The syntax is like -
SELECT mycolName1, myColName2,....
FROM [dbo].[myFunctionNameWhichReturnTableResultSet] (myParameterValue)
But this type of function makes performance issues. So you should aware about this and go for alternates.