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
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
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