Viewing 15 posts - 54,241 through 54,255 (of 59,068 total)
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. ...
November 7, 2007 at 9:13 pm
Thanks for the feedback, John...
November 7, 2007 at 9:00 pm
Greg Snidow (11/7/2007)
Greg Snidow (11/7/2007)
November 7, 2007 at 8:24 pm
Heh... no, that's ok, Matt... there's some pretty good short books on RegEx... it's about time I picked one up. 😉
November 7, 2007 at 7:45 pm
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...
November 7, 2007 at 7:38 pm
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...
November 7, 2007 at 7:34 pm
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.
November 7, 2007 at 7:27 pm
Ok there... it's time for YOU to hit the books Mr. Senior Software Engineer with an MCA... look in Books Online...
November 7, 2007 at 7:23 pm
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...
November 7, 2007 at 7:17 pm
... 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...
November 7, 2007 at 7:14 pm
Nili S (11/7/2007)
.... And it worked!! For both Oracle and SQL Server.Thanks!
GETDATE() worked in Oracle? I don't think so...
November 7, 2007 at 7:10 pm
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...
November 7, 2007 at 6:18 pm
Why not just make it an auto-exec macro that get's executed when the spreadsheet is opened?
November 7, 2007 at 6:09 pm
But we are using 'OR' which could generate cartesian product.
Ok, Karth... your turn to explain something... How could the use of 'OR' cause a Cartesian product?
November 7, 2007 at 6:05 pm
Viewing 15 posts - 54,241 through 54,255 (of 59,068 total)