I don't remember which of the SSC forums I saw this on, but this is a duplicate post and the other post had some suggestions that were, apparently, ignored. ...

Thanks for the feedback, John...

Greg Snidow (11/7/2007)

---

Greg Snidow (11/7/2007)

---

Wait a minute...I could have sworn I copied and pasted an example of yours right in to QA and it retained its format. Maybe I'm...

Heh... no, that's ok, Matt... there's some pretty good short books on RegEx... it's about time I picked one up. 😉

I've not wallowed through the labyrinth of your cursor code to see exactly what you're doing, but why are you using cursors to do a simple dupe check/delete? There...

I see this quite often... people auditing INSERTs, I mean... why would you double (or more) the storage requirements by auditing INSERTs? Audits are supposed to keep track of...

Create a formatted spreadsheet... use it as a template... use VBS to copy it to a new file... use OPENROWSET to populate the new file.

Ok there... it's time for YOU to hit the books Mr. Senior Software Engineer with an MCA... look in Books Online...

Lookup "Merge" in Books Online...

You've told us what you want to do... but not why you think you need to do it. This smacks of RBAR (pronounced "ree-bar" and is a "Modenism" for...

... and, by the way, COALESCE works in both Oracle and SQL Server ...

... and NVL is the Oracle equivelent for ISNULL in SQL Server...

... and CURRENT_TIMESTAMP works in both...

GETDATE() worked in Oracle? I don't think so...

I agree with Mayank... just to add to that, the != will actually appear in execution plans as <>. Sounds strange, but I can always tell who wrote the...

Why not just make it an auto-exec macro that get's executed when the spreadsheet is opened?

Ok, Karth... your turn to explain something... How could the use of 'OR' cause a Cartesian product?