User Profile

Collapse

Profile Sidebar

Collapse
guna20
guna20
Last Activity: Sep 12 '14, 03:48 AM
Joined: Jul 4 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • guna20
    replied to SQL GROUP BY techniques
    in Visual Basic
    VB6 Source code Help

    Dear All,

    I Need a Vb6 Source code to solve the below problem. Please Find attachment of XL File,

    Sheet 1 : Product Details with Color, Condition Rank & Rate.

    Sheet 2 : Example Customer Enquiry,


    I Need Total Qty : 82


    Color Qty
    white 30
    L.white 40
    L.yellow12
    Total 82

    ...
    See more | Go to post

      Leave a comment:

    • guna20
      started a topic SQL GROUP BY techniques
      in Visual Basic

      SQL GROUP BY techniques

      Hello,

      I need a query to solve the below problem. The table rows are given below
      Code:
      [B]Stock Details		
-------------------------------------------------------
[/B]ID	Product	  Color	   Rate	 Stock
1	AD.GOLD	  White	   5250	 100
2	SM	  White	   5318	 100
3	LOGU - II White	   5357	 100
4	SS(03.5)  White	   5239	 100
5	PMV	  L.White  4810	 100
6	A.DELUX	  L.White  5082	 100
      ...
      See more | Go to post
      Last edited by Rabbit; Jul 7 '14, 04:57 PM. Reason: Email ID removed as per site guidelines. Please use [code] and [/code] tags when posting code or formatted data.
      No activity results to display
      Show More
      Working...