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...

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. ...

😛 Actually, there kind-of is one... use with care! 😉

Lynn Pettis (9/22/2008)

---

No, the file connection will not create the directory if it does not exist. You do that in a File System Task using the create directory operation....

psangeetha (9/22/2008)

---

Thanks for all your comments. I've changed the code to use between and the execution time has reduced. THe application team is currently happy with it now. If they...

None here... but there's nothing like going to the "source". I'm thinking that it should be...

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.

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...

So, take a look at the link Jason posted. 🙂

mbookout (9/22/2008)

---

I was pulling information from a table that has claims that were sent to the insurance company and in this one field it lists all the procedure codes that...

Heh... good for you, but two way street here... please tell us how you solved the problem.

Heh... pretty bad misunderstanding on my part. Thanks, Madhivanan.

You bet. Thanks for the feedback, Kelly. 🙂

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...

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...