|
Hey guys,
I've made this simple, as you can see in the picture I have some categories and subcategories, in this case
Electronics > Television (check out this to understand better http://i56.tinypic.com/rmvifs.jpg)
Television is a type of product which has some fields like (size, color, brand) that has to be saved in the database. there are many different types of products which have their own fields and their number is unknown therefore this cannot be done statically, it has to be done dynamically.
in addition to all this, each field has values, there are three types of values
true/false
multiple choice
single text
the values for each field also needs to be stored in the database so when for instants TV is selected the fields are loaded + their values.
I hope I were clear enough, would appreciate it if you could help out with the best design
K1
|
|
|
|
|
Could you please look into link you provided ? It's not redirecting properly.
|
|
|
|
|
If you cut and paste the link, it seems to work. Anyway this might help.[^]
Unfortunately, it looks remarkably like a lecturer's whiteboard with a homework problem, snapped on a mobile 'phone, but I could be wrong. 
|
|
|
|
|
it actually is my whiteboard and that's the problem I wanna find a solution for ! 
so have you got any idea guys ?
|
|
|
|
|
Well, I wouldn't tackle the problem that way at all. Assuming you are using a 'grown up' database, and you don't have millions of records under 'Electronics', then I would just have two tables.
The first would hold the records of all the 'Electronics' items, with a 'Category' column containing a unique code for TV, DVD player and so on. Other than the essential columns, like Name etc, I would have Descr1, Descr2, Value1, Value2, etcetera, enough to accommodate the most complex item. Some columns would have normal names, for instance, 'Price', or 'Cost'.
The second table would reference the first through the Category Code, have the same columns and column headers as the first table, but the rows would each contain descriptive values for the equivalent column headers in the first table.
|
|
|
|
|
I am still out of luck, I am not getting to see image.
Thanks for all your work.
|
|
|
|
|
So sometimes I use bcp from my c# and call it in a separate process while passing it command line arguments. I have been doing this for months, but today it started throwing an ambiguous error. I have changed nothing, so the sudden failure is proving difficult to resolve. I am still able to create the bcp format file, but when I try to insert a file I get:
An error occurred while processing the command line.
bcp PriceRecords.dbo.SVR5 in "C:\Code\b
in\debug\SVR5\1220201093611.csv" -t',' -f "C:\Code\bin\Debug\SVR5.xml" -U xxxxxx -P xxxxxxn -S localhost\SqlExpress
where xxxxxx = user and password
Using MSSQL 2008, not seeing any error in the SQL logs.
|
|
|
|
|
It appears wrapping the table name in brackets fixed this issue. I have no idea why this error seemed to have spontaneously started.
|
|
|
|
|
Often wrapping the table in brackets fixes problems with naming conflicts, especially if the name conflicts with a reserved word. Of course I have no idea if that applies in your case.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Hey guys, I was wondering if you can guide me to any source to find out more about ebay's database structure ?
Regards,
K1
|
|
|
|
|
Have you seen this? eBay's Database Structure[^]
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
yes I have but isn't exactly what I need ! thanx
|
|
|
|
|
Dear All, I have bellow table which I want to transpose, the pivot in SQL 2k5 works but I want it like in a dynamic way.
as lets say i have table
EmpID Name
1 A
2 B
I want to transpose by EmpID, that works fine but what if one more record is added to the table as
EmpID Name
1 A
2 B
3 C
then my transpose only picks up 1 and 2, how can i dynamically transpose that?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I do that in a DataTable once I've read the data, you could also do it while reading the data. I've never had a need for doing that in the database.
|
|
|
|
|
thanks for your reply, doing in DataTable is the simplest solution.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I hope you are asking about dynamic column generation with PIVOT.
You can first generate all the column dynamically using SQL Query and then you can give as a column input to PIVOT that will work beyond the static column bounary.
You could find THIS[^] to be useful.
Regards,
Hiren.
modified on Monday, December 27, 2010 2:51 AM
|
|
|
|
|
appreciated, that is what i need!
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
|
please help....
this query is not working.. please tell me ERROR
INSERT INTO test Values(TO_DATE('12/23/2010','dd/mm/yyyy'))
Thnaks In Advance
|
|
|
|
|
|
Where is it supposed to put it?
|
|
|
|
|
in advance, where ever that is.
|
|
|
|
|
You might want to check the SQL INSERT query syntax.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
What error are you getting? What's the underlying data type in this field? What's the table definition (your query only stands a chance of working if there's only a date field in the table test)?
|
|
|
|
|
i am Using SQL
Msg 195, Level 15, State 10, Line 1
'TO_DATE' is not a recognized built-in function name.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
