Viewing 15 posts - 55,141 through 55,155 (of 59,067 total)
Yes... sp__ will still go to MASTER first because it still contains sp_ as the first 3 characters.
Yes, you can do this without a function... it'll be a bit (maybe...
September 7, 2007 at 7:56 am
Ah... Matt's right... I left out a step... I should have said to insert all your missing rows into YourTable first, then run my code... don't need to add extra...
September 7, 2007 at 7:52 am
Roger that... still shouldn't matter but "can do"...
This obviously won't work if foreign keys exist... ![]()
First things first... make a "backup" of the table...
September 7, 2007 at 7:32 am
Jude,
What are you actually using?
Using CAST(anynumber AS MONEY) always results in 4 decimal places, not the 2 that you claimed it does...
September 7, 2007 at 7:06 am
Wow... lot's and lot's of suggestions... but I've gotta ask... the code runs almost instantaneously in QA even when there's not enough qualifying rows to satisfy TOP but causes the GUI to...
September 7, 2007 at 6:51 am
Mick,
Yeah, it can be done but I gotta ask... doesn't the ID field mean anything?
If you do this, any joins that reference...
September 7, 2007 at 6:37 am
The connections are not active and, therefor, nothing you really need to worry about.
September 7, 2007 at 6:33 am
Because of the contraints you have in the CTE, you might not even need MIN in the sub-selects.
September 7, 2007 at 6:32 am
Copy a quote from an existing post... paste it to yours... edit the quote using CPR (Copy, Paste, Replace).
September 7, 2007 at 6:14 am
Very nicely done, David, and a lot closer to set based! And you even remembered the brackets for "odd" table names that I forgot
...
September 7, 2007 at 6:11 am
It's a naming convention... see the following for more details...
September 6, 2007 at 8:11 pm
... and, it makes beer taste bad ![]()
September 6, 2007 at 7:34 pm
Or...
Create a view or a reporting table and use Excel's "Get External Data".
September 6, 2007 at 6:02 pm
Serqiy is spot on... a split function will make this easy and quite fast even without indexes. But... before we can make a decent split funtion, we need a little...
September 6, 2007 at 5:31 pm
Viewing 15 posts - 55,141 through 55,155 (of 59,067 total)