Viewing 15 posts - 54,241 through 54,255 (of 59,065 total)
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
Absolutely nothing... NOT IN is evaluated to <> for single values and some exclusionary AND's using both for multi-values.
November 7, 2007 at 6:03 pm
Matt Miller (11/7/2007)
Regular expression CLR functions would do that as well.... But you still need a search string...
November 7, 2007 at 4:31 pm
brendt hess (11/7/2007)
November 7, 2007 at 4:19 pm
Viewing 15 posts - 54,241 through 54,255 (of 59,065 total)