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
 General SQL Server Forums
 New to SQL Server Programming
 POS Problems

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 4

item1 mod1 mod2 mod4 mod3

item1 mod2 mod1 mod3 mod4

item2 mod1 mod3

item3 mod1

item2 mod3 mod1



this data get me this

items modifier1 modifier2 modifier3 modifier 4 count

item1 mod1 mod2 mod4 mod3 2

item2 mod1 mod3 2


item3 mod1 1

that 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

Posted - 2012-02-14 : 10:15:12
did you try the code I GAVE you?

http://www.dbforums.com/microsoft-sql-server/1675703-pos-problems.html#post6538364



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -