Thank you for all the replies. i used LEFT OUTER JOIN and solved the problem. So far i have added 9 tables and some SELECT sub queries to get the...

Lowell

Thank you for the reply. I will check on this matter deeply as I have seen the same issue in few SPs earlier

Jeff Moden:

I thought a UDF will improve performance....

Thank you very much for your valuable comments and help.

BY using the guidelines provided here and little bit of syntax correction (and small modification in NAV database), the code now...

Okey, great.

This is the scenario. I need to pull only selected information from a NAV Customer table. So, I bult a stored procedure in CLR to accept a customer code...

Hi

Questions:

1) What permission set is your assembly installed with?

I used EXTERNAL permission in the project. VS 2008

2) Why are you using ODBC instead of ADO.NET?

The reason is I am very...