Viewing 15 posts - 76 through 90 (of 144 total)
resolved this on my own so please disregard post now.
March 1, 2006 at 8:37 am
I got some help on this here, therefore this question is resolved:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21755167.html
March 1, 2006 at 7:40 am
It's very complex, that's the best I can do to explain, I've taken the time to provide you all the details so what are you needing at this point that...
February 27, 2006 at 9:50 am
no more issues here, I've figured it out...thanks
February 24, 2006 at 6:53 am
ST is just an inconsistency, I forgot to put UU in my post. Thanks for the suggestion!
February 20, 2006 at 6:00 pm
what do you mean the method chosen isn't a bright idea. So you're saying using a stored proc initially to bring in one value is bad? The stored proc is...
February 18, 2006 at 6:33 pm
I ended up having to do a retarded workaround. I had to call my stored proc to move the result into a table then call another stored proc to retrieve...
February 17, 2006 at 8:51 pm
crap, it hs nothing to do with the date, I am still getting dups
February 16, 2006 at 9:00 am
Thanks so much! I put in '' for the onhold dates because I'm not using them in my where clause so they're not needed
February 16, 2006 at 8:29 am
hold on, you may have something..which date field?
February 16, 2006 at 8:27 am
The unique identifyer in payhistory is number. So the 2 $200 has 1186 for m.number...it should only be showing 1 result, not 2..it's duplicating it. Same for customer 000002 with...
February 16, 2006 at 8:24 am
yes, my inner query does produce muiltiple records which is not wrong...however I just added DISTINCT to it to solve that problem. Now back to why this isn't working!
February 15, 2006 at 6:59 am
Your query to test using UNIONs produces syntax errors:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'As'.
Msg 170, Level 15, State 1, Line 47
Line 47:...
February 14, 2006 at 9:58 pm
it's actually "DCR", not DR..I changed it to DR for privacy purposes so don't be alarmed, that's not the problem:
dcr table: http://www.photopizzaz.biz/drscript.txt
customer table: http://www.photopizzaz.biz/customerscript.txt
master table: http://www.photopizzaz.biz/masterscript.txt
February 14, 2006 at 9:41 pm
Viewing 15 posts - 76 through 90 (of 144 total)