The Maxiumum number is 4.

Any help would be appreciated.

Thanks

noeld (11/5/2008)

---

meichner (11/5/2008)

---

Unfortunately my boss rejected the idea of using a pivot table (I can't really explain why). Is there another way to do this?

Thanks. I really...

Unfortunately my boss rejected the idea of using a pivot table (I can't really explain why). Is there another way to do this?

Thanks. I really appreciate the...

That is just what I was thinking. I do however have two questions.

1. I was considering a suggestion similar to yours except that I would have had two tables. ...

I am writing a bunch of ASP.NET web pages to select/display the data. When a user selects one item from a drop down listbox another drop down list box...

We have a bunch of static data that needs to be drilled into. For instance

I have a list of Categories:

Paper

Board

Ink

When the user selects Paper from a drop down I...

I want to thank everyone for the advice. In the past when faced with the same situation I handled things in a more relational way. The idea...

Sorry if I was confusing. I was not sure how to phrase the question. So I came up with a fictious example. Based on the responses I...

Thanks so much for clarifying this.

That did the trick.

Thanks

I am fairly new at this DB stuff, so maybe what I am about to state makes no sense. So please bear with me.

My concern with breaking SalesItem up into...

Thanks. That's was very good advice.

Thanks. I appreciate the advice. Is there any reason to ever use dynamic sql? If so, what would that be? Since I am a novice at T-SQL,...

Here is a copy of my stored procedure. Hopefully it will make sense (I am kind of new at this).

Sorry about the formatting. I am not sure how to clean...

Thanks. I got in a habit (good or bad) of raising errors when a problem occurs in a stored procedure as opposed to using return values. I am...