!!!!URGENT SELECT INTO PROBLEM URGENT!!!!

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

!!!!URGENT SELECT INTO PROBLEM URGENT!!!!

Author

Topic

alperozgur
Starting Member

16 Posts

Posted - 2004-10-14 : 09:02:21

I have a dummy question. I have a query as belows. I want to Merge these two tables into one table. Please Help Me.
DECLARE
@STARTPRD INT, @ENDPRD INT

select @STARTPRD = 2002001, @ENDPRD = 2002012

SET NOCOUNT ON

SELECT AD.ANAL_C2,AD.ADB_CODE,ISNULL(D.ORD_PRD, 0) AS PRD,
CASE WHEN SUBSTRING(TRANS_TYPE,1,4) = 'ST13' THEN 'DPZT'
WHEN SUBSTRING(TRANS_TYPE,1,4) = 'ST19' THEN 'IADE'
WHEN SUBSTRING(TRANS_TYPE,1,4) = 'ST14' THEN 'EMN'
END AS TIP,
CASE WHEN SUBSTRING(TRANS_TYPE,1,4) = 'ST14' THEN 0
ELSE
ABS(ISNULL(SUM( CASE WHEN RTRIM(D.ITEM_CODE) IN ('B00008') THEN VALUE_1 ELSE 0 END ), 0))
END AS ADET
INTO #TOTAL1
FROM SSRFADB AD(NOLOCK)
LEFT JOIN SOMFDETBPT D(NOLOCK)ON ( D.ANAL_M6 = AD.ADB_CODE
AND D.ORD_PRD BETWEEN @STARTPRD AND @ENDPRD AND SUBSTRING(TRANS_TYPE,1,4) IN ('ST13', 'ST19','ST14') AND D.ITEM_CODE = 'B00008')
WHERE AD.ADB_CODE LIKE 'MB%'AND AD.SUN_DB='BPT'AND AD.ANAL_C4 = '1'AND SUBSTRING(TRANS_TYPE,1,4) IS NOT NULL
GROUP BY AD.ANAL_C2, AD.ADB_CODE, D.ORD_PRD, SUBSTRING(TRANS_TYPE,1,4)

SELECT ANAL_C2,ADB_CODE,ISNULL(PRD, 0) AS PRD,TIP,ISNULL(ADET,0) AS ADET
INTO #TOTAL2
FROM BPG_BOTTLE_2002 (NOLOCK)
WHERE PRD BETWEEN @STARTPRD AND @ENDPRD

and the result is :
#TOTAL1
ANAL_C2 ADB_CODE PRD TIP ADET
46211 MB0130 2002001 DPZT 425.00000
46212 MB0150 2002001 DPZT 80.00000
46212 MB0150 2002002 DPZT 25.00000
46212 MB0150 2002003 DPZT 50.00000
46212 MB0150 2002010 DPZT 50.00000
46212 MB0150 2002011 DPZT 95.00000
46212 MB0150 2002012 DPZT 125.00000
46212 MB0151 2002001 DPZT 50.00000
#TOTAL2
ANAL_C2 ADB_CODE PRD TIP ADET
46211 MB0128 2002012 DPZT 50
46211 MB0130 2002001 DPZT 485
46211 MB0130 2002002 DPZT 162
46211 MB0130 2002003 DPZT 69
46211 MB0130 2002004 DPZT 124
46211 MB0130 2002005 DPZT 76
46211 MB0130 2002006 DPZT 88
46211 MB0130 2002007 DPZT 82
46211 MB0130 2002008 DPZT 214
46211 MB0130 2002010 DPZT 165
46211 MB0130 2002011 DPZT 123
46211 MB0130 2002012 DPZT 325
46211 MB0504 2002001 DPZT 25
46211 MB0504 2002004 DPZT 75

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-10-14 : 09:05:51

merge??
you could Union All

Query1
Union All
Query2

Corey

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-10-14 : 09:06:24

SELECT <columns> INTO <table> FROM ... creates a new table and adds rows to it.

INSERT INTO <table> SELECT <columns> FROM .. adds rows into an existing table.

Just change your second statement into an INSERT statement.

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources