Hi,
On executing CROSS APPLY Clause using UDF:
create function Reg(@pc int,@pp varchar(15))
Returns Table
As
Return select cr from crt where piod=@pc and cr=@pp
Go
select distinct a.cr from cdet AS a CROSS APPLY
Reg(a.cr,a.piod) AS a
where a.piod='208'**
Am getting this following errors: Incorrect Syntax near '-'. Thanks.