• REPLACE INTO would be great, but it doesn't exist in SQL Server. This is what MERGE is supposed to do.

    I'm just moaning about what I can't have. 🙁 As a developer/DBA I do as much as I can to take the work off of the server. Some times it's nice to have SQL take the work off of me. I like to preprocess data and funnel the data through one pipe. That way I have fewer places to look when things go wrong.

    I get into projects that interface with lots of databases. I like MySQL REPLACE INTO and hate the way they are so picky about string to date conversions. SQL Server will take pretty near anything for a date string without complaint but does not support REPLACE INTO.

    I'm not saying take MERGE away, I would just like the other goody added.

    ATBCharles Kincaid