CASE statement with WHEN EXISTS 1

[kermitforney]

What is wrong with my statement ? ? ? Keep getting an

"Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'AS'."

error.

SELECT	*
		,CASE 
			WHEN EXISTS(
							SELECT *
							FROM tblStores
							WHERE lngDivisionID IN (	
														SELECT lngDivisionID 
														FROM tblDivisions 
														WHERE lngOperatingCompanyID = 9
													)
								AND tntRecordStatus = 0
						)
			THEN YTDSSS * .02 AS monSuppliesMax
		
INTO #tmp2
		
FROM #tmp

Any suggestions?

 

[gmmastros]

Every case must have an END.

[tt][blue]
THEN YTDSSS * .02 [!]End[/!] AS monSuppliesMax
[/blue][/tt]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[kermitforney]

I feel like such an idiot right now.

Definitely as case of the Mondays.

Thanks again, gm!