Viewing 15 posts - 48,121 through 48,135 (of 59,064 total)
The only thing different in any of the original code is the IF and the WHERE... why on Earth would anyone break this into 20 separate stored procedures?
Anjali, if you...
September 22, 2008 at 6:26 pm
Question of the day...
You have severely limited the amount of help you can get by...
1. Posting as a spreadsheet
2. Posting as a spreadsheet that many can't read
3. ...
September 22, 2008 at 6:19 pm
Manie Verster (9/22/2008)
Oh, Jeff please tell me where I can download that "Run SQL Fast" button. I definitely needt it!:P;)
😛 Actually, there kind-of is one... use with care! 😉
September 22, 2008 at 6:12 pm
Lynn Pettis (9/22/2008)
September 22, 2008 at 5:53 pm
psangeetha (9/22/2008)
September 22, 2008 at 5:52 pm
Rem (9/22/2008)
Thanks for all your hints.What about USPS CASS CERTIFICATION, any experiences with it?
None here... but there's nothing like going to the "source". I'm thinking that it should be...
September 22, 2008 at 5:46 pm
Heh... looks pretty familiar, but I gotta ask... is the following a type-o?
GROUP BY lo.MMID
It's not in the Select list and I'm sure this will cause an error.
September 22, 2008 at 5:45 pm
Sure thing, Terry... I'd recommend solving the entire hierarchical problem and storing it in a separate table using Nested Sets. Here's a link...
http://www.codeproject.com/KB/database/nestedsets.aspx
... some folks end up converting the...
September 22, 2008 at 5:42 pm
anand (9/21/2008)
himy present database size is around 1-2 GB
So, take a look at the link Jason posted. 🙂
September 22, 2008 at 5:30 pm
mbookout (9/22/2008)
September 22, 2008 at 5:24 pm
Soorya (9/22/2008)
Problem solved. The posts were really helpful. Thanks to all those who replied
Heh... good for you, but two way street here... please tell us how you solved the problem.
September 22, 2008 at 5:22 pm
Madhivanan (9/22/2008)
My reply "Yes it is" is to your reply "Heh... not exactly true..."Actually I agreed with your reply 🙂
Heh... pretty bad misunderstanding on my part. Thanks, Madhivanan.
September 22, 2008 at 5:15 pm
You bet. Thanks for the feedback, Kelly. 🙂
September 21, 2008 at 8:29 pm
That will certainly give you the number of bytes the datatype can or does occupy. But it will not give you the min or max values without prior knowledge...
September 21, 2008 at 7:28 pm
Ummm... ok... now I understand the latest question...
The answer is that isolation of the "cell" and using it as a criteria is done as a combination of a JOIN between...
September 21, 2008 at 7:24 pm
Viewing 15 posts - 48,121 through 48,135 (of 59,064 total)