yes you are 100% right., but here one of my friend got this question in his MNC interview.like: write the logic to get Armstrong numbers?

hi please provide me the Training kit on shivasssv@gmail.com

--Hi, your doubt is absolutely right, because the CTE doesn't need when --it is the 1st batch i the overall query,

--e.g.

create proc usp_Test

as

begin

; whith cte as ...

Hi Try this:

Print('select case when '''+@action+'''='''+@dbname+''' then '+cast(@a as varchar)+' else '+cast(@b as varchar)+' end')

SELECT DISTINCT a.itemcode

,b.itemname

,SUM(qty) AS Total_Qty

,SUM(Price) AS Total_Price

FROM oppharsales2 AS a

LEFT JOIN masteritem AS b ON a.itemcode = b.itemcode

INNER JOIN oppharsales1 c ON a.billno = c.billno

WHERE c.BillDate >= '2013-05-01'

AND c.BillDate <=...