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 |
|
hanysalah
Starting Member
1 Post |
Posted - 2012-02-13 : 14:54:40
|
| i have POS program and i need to get report from it i have items that it saled and each item may have one modifiers or more modifiers so i need to search in side the table of each item and get all modifiers that may entered rondomely and count each rows that repeated ex:items modifier1 modifier2 modifier3 modifier 4item1 mod1 mod2 mod4 mod3 item1 mod2 mod1 mod3 mod4item2 mod1 mod3item3 mod1item2 mod3 mod1this data get me thisitems modifier1 modifier2 modifier3 modifier 4 countitem1 mod1 mod2 mod4 mod3 2 item2 mod1 mod3 2item3 mod1 1that is the report i need that compare fields in tabl with each otehr and return count of repeated data >any one can help me reply to me about this |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|