Link to home
Create AccountLog in
Avatar of dkilby
dkilbyFlag for Canada

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 ?
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Be aware that MERGE has sometimes has performance issues.  There are also some claims of faulty logic.

For now, I'd stick the "standard" UPDATE and then INSERT.