Query between SQL server and Client side

Posted by Karim on Stack Overflow See other posts from Stack Overflow or by Karim
Published on 2010-04-22T14:36:48Z Indexed on 2010/04/22 14:53 UTC
Read the original article Hit count: 171

Filed under:

I create a query: Select * from HR_Tsalary where month='3' and year ='2010' the result is 473 records and I found 2 duplicate record, then I create another query to find duplicate record only: SELECT Emp_No, COUNT(*) FROM HR_Tsalary WHERE year = '10' AND month = '3'GROUP BY Emp_No HAVING COUNT(*) > 1 the result is zero record from client side (thru Visual Basic Adodb code). But when I use same query from server the result is 2 records. Is there any different when create a query between from server side and client side?

© Stack Overflow or respective owner

Related posts about sql