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.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2007-02-13 : 08:00:18
|
| Hello.Though this is not directly a SQL related question but I could not think of some other forum to post this request. <y apologies if I should have posted elsewhere...I need some sample data for a departmental store (like WalMart of KMart) which sell a wide variety of things and probably everything under the sun :)I need data in such a manner that we have 4-5 levels of data hierarchy. For example we can have a data hierarchy like follows:Classification Category Sub Category Product Group ItemThe above is just an example but I hope that most of you already know what I neeed. An example of data based on the following hierarchy can be as follows (shown in a tabular manner)Classification | Category | Sub Category | Product Group | Item---------------------------------------------------------------Household Items| Electronics| Entertainment| Audio| SONY Room entertainment box, 2 speakers 300 W each, ....Household Items| Electronics| Entertainment| Audio| Phillips Boom Box, ...specifications....Household Items| Electronics| Entertainment| Video| SAMSUNG DVD Player model SG-17X5 ...Household Items| Electronics| Entertainment| T.V | SONG TRINTORN 51" ...........Groceries | Drinks | Colas| Coke | COke 12-Pack Cans ....Groceries | Drinks | Colas| Coke | COke 2.25 Litre Jumbo Pack..Groceries | Drinks | Colas| PEPSI| PEPSI 2.25 Litre Jumbo Pack..........Toys | Girls | Dolls| Barbie | Barbie princees model A21 .......I hope the above provides you with a clear understanding of my requirement.I'll be extremely grateful for your help.Thanks & Regards. Thanks & Regards.-J |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-13 : 08:59:58
|
choose your basic words and cross join them a couple of times to get squared number of words of sample data.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-13 : 10:32:58
|
Ask your customer for the data or generate it yourself. I believe some of us do have similar data but the data does not belong to us but the company that we work for or our customer. It will not be right to provide the data to anybody. It is best to generate it yourself. Others has suggested various way to do this. Try it. It is not that difficult to do it.
KH |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2007-02-14 : 07:02:18
|
| Hi all.Thank you for the replies.Thanks & Regards.-J |
|
|
|
|
|
|
Sample data required