Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2015
    Posts
    4
    Provided Answers: 1

    Unanswered: combination of data between two tables

    I have database link follow
    http://www.4shared.com/file/UXrVFpVvba/Example.html
    in database have 3 table (cap2,TB_CongVan,TB_Result)
    i want use procedure or function combination of data between two tables cap2 and TB_CongVan is return result in TB_Result
    Help me?
    Thanks

  2. #2
    Join Date
    Nov 2004
    Posts
    1,425
    Provided Answers: 4
    I have followed the link to 4share. Is that the backup of a database? I 'm not allowed to restore that on my company's computers.

    Can you describe what each table stores and how they relate to each other (CREATE TABLE scripts would be great), add some sample data (INSERT scripts) and give the data you expect as a result. That makes it easy for us to reproduce your situation.

    Do you have any specific reason why you want to use a procedure of function to enter data into TB_Result?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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