It's because of your JOIN.  Look at the data you're inserting in the CarCol tables:

ID   CarID    Colour

1      1      Red

1      1      Blue

1      1      Green

This means that the only thing...

Agreed with Marshall.

A good general guideline is the 80/20 rule for SP's; i.e., count on 20% of your code/queries to be used 80% of the time.  Converting that 20% of your...

OK that narrows it down a bit, since StockableItems and NonstockableItems are completely different things (i.e., Products and Services), I don't have a problem storing them in separate tables as...

What is a stockable item and what is a nonstockable item?  How about some concrete examples of what these items actually are?

My major concerns right up front would be:  1)  Potential SQL injection issues and 2) Performance.  Not to mention just potential problems in general.

Sounds like someone over there wants to...

Yeah, he didn't really spell it out, and I assumed that he's trying to make some sort of inventory tables...  but if he's modeling completely different types of items then...

As I said, the OP didn't make a lot of things really clear. 

-If "XYZ Cell Phone Battery" is a stockable item and "WXY Cell Phone Battery" is a nonstockable...

I disagree with this statement:

"The reason you wouldn't want to store stockableID and nonstockableID in the items table is that logically an item is only one or the other. To...

Database normalization basically involves removing repetitive data, eliminating some "data anomalies" and creating relationships between your tables.  Here's a short article with links to other articles:  http://databases.about.com/od/specificproducts/a/normalization.htm

Most of the time...

Hmmm...  Can you give more details about exactly what you're trying to do?  Like where do you want this function to exist?  Are you using SQL 2K or 2K5?  What...

Unfortunately the only use of EXEC allowed in UDF's is to call an extended stored procedure (XP).  This limitation is imposed because of determinism.  UDF's ideally should be deterministic; SP's...

Functions have a lot of limitations on them that will make this hard to do.  Without knowing more details about what you're doing, how about using a Stored Procedure instead. ...

Actually it's a fairly simple backup process, but unfortunately the backup process tends to assume that you have control of your own SQL Server...  which we all know is not...

tsSchema just defines the xml namespace.  It shouldn't have to be on your local computer.

Do you have the line <diacritics_sensitive>0</diacritics_sensitive> in your thesaurus?  Try <diacritics = false/> instead and let...

POS System for mobile ... phones?

I would think that stockable would be a column in your Inventory table (ItemTable?).  The stockable flag could be 'Y' for yes or 'N' for...