Call user defined Function within select Statement
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?