Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: New in Stored Proc

    Can you please help me creates a stored procedure for this?

    I have two tables

    First table tMasItem and second table is the tMasItembundles

    tMasItem columns
    RefId
    Item Code
    uom
    Description

    tMasItemBundles Columns
    RefId_Item
    RefId_MemberItem
    Qty

    how can I Select the Description for RefId_Item and RefIdMemberItem both description will be from tMasItem

    like this

    Milk Tea Green Tea Lychee
    Jasmin Green Tea 150 ml
    Fructose 30 ml
    Ice 50 g
    Lychee Syrup 200 ml
    cup 1 each
    straw 1 each


    this will be used for reports thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Double posting your question will get you the same answer twice. Check here.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •