this looks good only for SQL 2008

To Bad it doesn't work with SQL 2005

--With simple calculation we don't care about data-type (float or decimal)

--====================================

--When we start calculation like the following one, we should use decimal

-- Let's see example

--====================================

DECLARE @APR ??????? (18,3)

--------------------------------------

SET @APR=.074;

DECLARE @Months...

For any math calculation avoid FLOAT use Decimal you will get Write result.:D

from original post

---------------------------------------------------------------------------------

"I have a table that details site information (for the service call industry). It contains bog standard fields like Address, phone number, email, etc.

I need to add...

to make PIVOT table in SQL 2005 it's needs got against one column that is why it's there.

If you don't need pivot View on the end then

the structure of Client_Missolenius...

Well this is classic situation, how you normalize relationship between tables that have many to many relationship. You need to have 3rd table "fork" one.

Another option in design use meta data style this is how it works

------------------------------------------------------------------

-- script created by Scott Tolstoy to show sample of Meta-data design table

-- with Pivot table view in...