Comparing attribute levels for each products

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Comparing attribute levels for each products

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-29 : 07:22:09

Jitu Davda writes "Hi
I'm not so good in making sql queries.
At present I'm not able to find a correct way for making a sql query for my requirement.

The case with me is :

There is a products attributes table which has nearly 40 attributes and the fields stores integer values as the level in that attribute for the product.

Now I've to show the list of all the matching products with ranking there with, for a perticular product in search.

I'm not getting how to do...

Table ProductAttrib
---------------------
ProductID       Numberic
Attribute1      smallint
Attribute2      smallint
Attribute3      smallint
Attribute4      smallint 
Attribute5      smallint
Attribute6      smallint
Attribute7      smallint
....

Subscribe to SQLTeam.com

Resources