Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joelseverich
Starting Member
34 Posts |
 Posted - 2008-03-13 : 16:16:28
|
| HI.I HAVE 3 TABLES THE 1ST HAS COLUMNS: ID , NAME, TYPETHE 2ND : ID , IMPORT, DATE...AND 3RD : ID,NAME , IMPORTWELL THIS IS THE PROBLEM.IF TABLE1.TYPE IS "G" THEN THE ITEM IT IS NOT USABLE FOR TABLE2, BUT ALL ITEMS OF TABLE1 WICH TYPE IS "D" ARE LISTED TO BE USED IN TABLE2FOR EXAMPLEFOR TABLE1 1 ITEM1 G 1-01 ITEM2 G 1-01-01 ITEM3 D 1-02 ITEM4 G 1-02-01 ITEM5 D FOR TABLE 1-01-01 2000.25 12/25/2007 1-02-01 5247.12 12/28/2007NOW I NEED TO INSERT INTO TABLE3 TABLE1.ID,TABLE1.NAME,*TABLE2.IMPORT*BUT HERE I NEED TO SUM TABLE2.IMPORT WHERE TABLE1.ID LIKE 'TABLE2.ID' , SO THE RESULT WOULD BE 1 ITEM1 7247.37 1-01 ITEM2 2000.25 1-01-01 ITEM3 2000.25 1-02 ITEM4 5247.12 1-02-01 ITEM5 5247.12ANY HELP WOULD BE GREAT |
|
|
|
|
|
HELP ON SUM FUNCTION