I have two databases, each having the same table (the table is the same structurally--tables, indexes, constraints, etc.--but could have different data). One particular set of data is exactly the same. When I query that set of data, using a query with no sort parameters, the data is returned in a different...

Hi All, I spent considerabale amount of time on tuning the following query.I tried to remove temp table with derived table,but while executing, i was getting errors. I dont have any idea about tuning on Cursors in the below query.My major concerns are, how can i replace cursors and temp tables in the...

Hello, I have a question about an SQL query that I am having trouble figuring out and I was hoping you could help. I have the following tables; Person_telecom (This table has multiple records per contact where the telecom_type and phone_number would differ.) Person_id Telecom_type Phone_number Contacts...