Thanks

Noel

Since I am using both Sql 7 and Sql 2k I will have to try out the Microsoft solution that you listed to see if there are any performance...

quote:

---

Because you cannot predict

---

One minor point of distinction. The QOD inferred that...

That is probably a good idea, but I still have to use chars as my datatype, because the codes are alpha numeric. Most of the time they are just...

Thanks Jonathan

I do so appreciate having a forum that seems to have the answers for every problem that I come up with.

As far as design goes, my intention is to...

Thanks for the feedback.

I wish it were as simple as that. The example I gave is an over simplified version of a more complex problem. The des field...

While I agree that the rush of doing something that "can't be done" is what a programmer/dba lives for, I agree with jwiner. Crystal Reports Release 9 has a great...

Thanks,

I believe that Jonathan and NPeeters suggested that very same thing.

Edited by - kepr00 on 10/28/2003 07:20:49 AM

I do like the alternate suggestion NPeeters made and I will look into a schema of this type.

Jonathan, could you repost that link. It does not seem to work.

...

So what I am understanding, at least so far as you have experienced, is that this is a stylistic matter that would probably need to go the rounds in a...

I do realize that there is an "upper bound" on the number of questions that I can handle with an int, but that can be easily addressed, as you suggested,...

I have had similar issues when using <> operators when comparing character fields. I have had some pretty good luck using the charindex or patindex functions in place of...