August 26, 2008 at 9:45 am
Could you provide the DDL (create statements) for the table, some sample data for the tables (in the form of insert statements that can be cut, paste, and run to load the tables), and the expected results from the procedure based on the sample data?
This will help us help you.
This article will help you if you need more info: http://www.sqlservercentral.com/articles/Best+Practices/61537/
😎
September 2, 2008 at 6:26 am
Lynn-
I appreciate the advice and the help you offered on this topic, after further review it seems to be a known, old but known issue with the difference between the '=*' join syntax and where the WHERE clause is applied, found 2 articles that seems to point to the issue I am having.
This was the clearer of the articles to me. Thanks again.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply