But then he will have to come back and fix it when it becomes the Y10K problem! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />
Roji,<br /><br />The only problem with that is that the original request is for <br />-MAXINT to 100 as A,<br />101 to 200 as B,<br />201 to 300 as...
quote:Originally posted by Reddy thanks for the quick reply. SOrry, this didnt help to resolve my problem Thanks! "He laughs best who laughs last"...
quote:Originally posted by Bredsox Roji, It's not giving me the right order. This what your script is generating: ID 10 6 7 8 5 Thanks Dan How...
quote:Originally posted by eramgarden Silly me, I can "SELECT Definition = [text] + ' GO' " but "GO" needs to be on the next line..i need a...
quote:Originally posted by mita Really sorry for my above post aefager. I thought all these things which u said were meant for me.. in fact it was...
quote:Originally posted by kjmraohyd PK on period_id,credit_unit_id,facilityid select * from bkpt where period_id=200504 and credit_unit_id = 38422...
quote:Originally posted by karthikm when can i get a solution for this? Probably never if you choose not to follow the advice given. 1. Post this...
I am not sure in what way you mean that they are different. Is there more than one Atlanta line in the results, or is the fact that 16 becomes 20...
And Frank showed his in a courier font (using code braces), and used a select and comma rather than a set and newline.<br /><br />There were a ton of...
Sounds like you want to do a UNION, (Row 1 to Row 1, Row 2 to Row 2, etc) instead of a Join. Is that what you need?
Sounds to me like you no longer need to have the table items tied together, but instead become four separate lists that are then merged back together...
quote:Originally posted by Adriaan Tools > Options > Results > Maximum Characters per Column My best guess is that the maximum is 8192 - at least...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Since you have in there an assumption that the doctor full time on one practice cannot be in more than one part time practice as well, I would...
quote:Originally posted by abradley81 This is the max URL what would be pass via querystring:...
quote:Originally posted by joechang the int bit field is a very solution for C/C++ code, it is not good for SQL because sql does not generate true...
If the parameters are too many for YOU, then they are too many. Consider putting those 72 individual parameters (90% of 80) into an int bitfield,...
Hi Rajesh,<br /><br />If you are drilling to the City level, then it is going to be tough to find for free.<br /><br />You might want to try the...
Okay! I finally solved it, after much zigging and zagging to try to get to where I wanted. I knew that I could Left Join, but all attempts of...
Separate names with a comma.