Hello,
I have strange problem.
I had 5 tables and joined them.I got resultset with 3 date fields.I used max function in select statement to weed out duplicates.the problem I have is that when I run just the select statement in query analyser ,I get 45 rows but when I run the Stored Procedure,Im getting 175 rows with duplicates.
Please advice.
Thanka
I have strange problem.
I had 5 tables and joined them.I got resultset with 3 date fields.I used max function in select statement to weed out duplicates.the problem I have is that when I run just the select statement in query analyser ,I get 45 rows but when I run the Stored Procedure,Im getting 175 rows with duplicates.
Please advice.
Thanka