Click here to Skip to main content
14,770,678 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have get data in sql this table this format.......

SELECT TOP 1000 [PacketId]
      ,[PacketType]
      ,[QtyInParent]
      ,[Description]
      ,[PacketUnderID]
      ,[PacketMasterID]
      ,[AdminID]
  FROM [tbl_mst_PacketTypes]



let data is
PacketId  PacketType  QtyInParent    Description    PacketUnderID PacketMasterID       Admi
9         carton      1                             0             0                    1   
10        Box         20                            9             0                    1   
11        Strip       10                            10            9                    1   
12        Tablet      5                             11            10                   1   
5         Jar         1                             0             0                    1   
6         Packet (10) 10                            5             0                    1   
7         Packet(5)   5                             5             0                    1   
8         Tablet (500)500                           6             5                    1   


1 carton how many Tablet
ans is 1000


how to use Query.............

plz help me...........

[edit]Code block added - OriginalGriff[/edit]
Posted
Updated 26-Jul-13 22:39pm
v2
Comments
Behno0o0oD 27-Jul-13 5:47am
   
Please explain more, do you want to know how many tablets are in one cartoon?
Raju9959 27-Jul-13 6:11am
   
could you post parent table as well..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900