Holly Molly!

I see i have some studing to do. Thank you very much for taking the time to get this to me.

Let me get to...

Not all the companys sell blinds; therefore, I have a product table that has pricing for products EXCEPT for the blinds, shutter, Verticals, ect. they have a seperate table name the...

At this time i do not see a percent markup and a dollar markup.

And all of this will be enterd by an employee.

Thanks..

I am going to have to study this a bi; however, i will be in touch in a day or so.

I am extreamly grealful for your help!

Thanks,

Erik

Now that i am over looking your question; (

Does the markup type (per unit or percentage) apply to all products for all companies?  Could Company A have a 5% markup...

Thank you for your responce!

Since what i am going to be using this solution for 1000's of different blinds, shutters, verticals, and how knows what else, i belive that a...

On the Second Command The alter Procedure is GetBlindCompanyInformationCT16      For those Nameing convention freaks out their.

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

ALTER PROCEDURE

GetBlindCompanyInformationCT16 <-----------

@IDCompany

I wanted to update this fourm on what i did to solve this one day (5 minute problem)

No need to worry about seperating the information (inside the query string) the...

Thanks.

Let me dig into this.

When trying to run the query in query analyzer receive the following error.

(Is it the fieldlist)

Server: Msg 170, Level 15, State 1, Procedure GetBlindCompanyInformation, Line 7

Line 7: Incorrect syntax near '.'.

and...

I am sorry about that, i started this fourm question with an example in mind and when i showed the real deal it was different.

I do appoligze.

I have uploaded a snap shot of the database for you to take a peak at it.

I looks like i have a many to many with the department table., with...

Right now i have DepartmentID set up as a regular field in the company table. It is not an identity column.

Normaly i only receive the 5 companys the are connected...

I would like to add a percentage to OR  subtract a percentage from THE RESULT based on the CompayID AND the ProdcutID.

Thanks!

I have not set the Correlation on the table and the query yet.