I want to create a UDF for some common calculation.
In that, i want to create tables (temporary or using table variable), with some records and later on do some calculations on these.
Finally, the UDF is required to return the processed recordset.
Could somebody please help me on this.
I have tried creating Global Temporary tables inside UDF, which is giving an error.
Can someone tell me how to use Table variables in this?