dkilby
asked on
MS SQL Query + Merge Data
I have a table that i am using to load data in my database, i want to move the data to another table, and merge the rows that have the same Call_ID into one row.
so if call_id is the same, then it would only create one row in the new table, is this even possible with a query ?
so if call_id is the same, then it would only create one row in the new table, is this even possible with a query ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For now, I'd stick the "standard" UPDATE and then INSERT.