Viewing 15 posts - 3,241 through 3,255 (of 6,486 total)
Oblio Leitch (5/20/2008)
match rows. I mean, I suppose I *can*, but it means joining back on like four or five columns to be unique.
Again - not nearly enough info...
May 20, 2008 at 4:41 pm
I'm thinking you're looking at the wrong standard report. If you look at the INDEX PHYSICAL STATS reports, it will tell you how many pages each index is taking...
May 20, 2008 at 4:36 pm
I'm not sure I follow - you're outputting into a table variable, which survives that actual statement, allowing you to do pretty much anything you want with that data. ...
May 20, 2008 at 4:21 pm
marianodios (5/20/2008)
The DTS fails when wants to read data from temporal directory of the server (the same server where is install the sql server).
One step before, the same dts write...
May 20, 2008 at 2:01 pm
jcrawf02 (5/20/2008)
Matt Miller (2/27/2008)
Jack Corbett (2/27/2008)
Yeah and another version coming this fall.
Kick a man while he's down ,heh? (just kidding). It would be nice if those going over...
May 20, 2008 at 1:09 pm
GilaMonster (5/20/2008)
GSquared (5/20/2008)
May 20, 2008 at 1:02 pm
GSquared (5/20/2008)
GilaMonster (5/20/2008)
Personally, I'm thinking that an instead of trigger might be a better idea, as it allows the insert to not actually be run, removing...
May 20, 2008 at 12:44 pm
abinder (5/20/2008)
That's one of the problems. I don't have a Payments(Credits)Applied table. I have only what I stated in my original posting a series of Debits and Credits and their...
May 20, 2008 at 12:11 pm
karthikeyan (5/20/2008)
Earlier it took 2.5 hrs, now it is taking 50 minutes only, still i am not happy with...
May 20, 2008 at 11:02 am
karthikeyan (5/20/2008)
All 3 work just fine if all you want to do is to detect that there is one or more. #3 is the fastest for this purpose. ...
May 20, 2008 at 10:55 am
Johann - what does "it's not working" mean in the latest scenario. What are you hoping to get? I have a theory what it is - but instead...
May 20, 2008 at 10:37 am
Where are you getting your distinct list of geographic codes? That seems to be missing from the equation.
May 20, 2008 at 10:11 am
Have you tried to run the query? Just because it can't DISPLAY the characters correctly doesn't mean it won't FIND them. You may find that your PATINDEX runs...
May 20, 2008 at 10:06 am
Stephanie Giovannini (5/20/2008)
Yesterday, I had to assist another developer in writing queries for MS Access, interpreting its...
May 20, 2008 at 10:02 am
Lynn Pettis (5/20/2008)
John Rowan (5/20/2008)
I just based it on the OP's post.
What a novel concept.....:)
lol... Of course, how many times has that turned out to be NOT what they want....
May 20, 2008 at 9:56 am
Viewing 15 posts - 3,241 through 3,255 (of 6,486 total)