need help with db-query on sql-server 2005.
- by Avinash
We're seeing strange behavior when running two versions of a query on SQL Server 2005:
version A:
SELECT otherattributes.* FROM listcontacts JOIN otherattributes
ON listcontacts.contactId = otherattributes.contactId WHERE listcontacts.listid = 1234
ORDER BY name ASC
version B:
DECLARE @Id AS INT;
SET @Id = 1234;
SELECT otherattributes.* FROM…
