Hi

Even we are doing the same way (Storing date as int) but how we handle the same is as follows.

In SQL Server if you use cast or Convert there...

Have you tried table Variables in SQL Server ? Try to use that instead of Cursor. it will improve the performace in comparison to Cursor.

If you are doing the same within a stored procedure then define one table variable or a temp table as you said and put the UDF output in that table...

I think the usage of EXEC or Sp_execute will improve the performance as the SQL Server dont have to findout the type of Command you are entering

I think the usage of EXEC or Sp_execute will improve the performance as the SQL Server dont have to findout the type of Command you are entering

Hi, Yes you are right about WA authentication. It really creates a security problem more over i have the experoience of user opening the database using his login ID of...