Syntax error Help - SQL Server Forums

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

Transact-SQL (2005)

Syntax error Help

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-05-06 : 11:16:09

Dear All,

I am using below query to select the data to temp table but i am getting an error.
Can u pls help me to identify the error.

select * into Ganga_201006 from

(SELECT
B.PROVIDER_SK
,A.ORIGINAL_FSC
,201002 'ss'
,SUM(ISNULL(A.TOTAL_CHARGES,0)) AS TRIMONTHLY_CHARGES
,A.ID_100 --added by Gangadhar on 16 march 2010
FROM INVOICE_HEADER A
INNER JOIN PROVIDER_DIMENSION B
ON A.GROUP_NUMBER = B.GROUP_NUMBER
AND A.ID_102 = B.ID102
AND A.ID_202 = B.ID202
AND A.ID_3 = B.ID3
AND A.INVOICE_CREATION_PERIOD >= 201002
AND A.INVOICE_CREATION_PERIOD <= 201004
WHERE EXISTS (SELECT 1 FROM #QUALIFYING_GROUPS C WHERE C.GROUP_NUMBER = A.GROUP_NUMBER)
GROUP BY
B.PROVIDER_SK
,A.ORIGINAL_FSC
,A.ID_100)

Thanks

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-05-06 : 11:19:21

Maybe a missing alias?

select * into Ganga_201006 from 

(SELECT 
B.PROVIDER_SK 
,A.ORIGINAL_FSC 
,201002 'ss' 
,SUM(ISNULL(A.TOTAL_CHARGES,0)) AS TRIMONTHLY_CHARGES 
,A.ID_100 --added by Gangadhar on 16 march 2010 
FROM INVOICE_HEADER A 
INNER JOIN PROVIDER_DIMENSION B 
ON A.GROUP_NUMBER = B.GROUP_NUMBER 
AND A.ID_102 = B.ID102 
AND A.ID_202 = B.ID202 
AND A.ID_3 = B.ID3 
AND A.INVOICE_CREATION_PERIOD >= 201002 
AND A.INVOICE_CREATION_PERIOD <= 201004 
WHERE EXISTS (SELECT 1 FROM #QUALIFYING_GROUPS C WHERE C.GROUP_NUMBER = A.GROUP_NUMBER) 
GROUP BY 
B.PROVIDER_SK 
,A.ORIGINAL_FSC 
,A.ID_100) T

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources