if exit table then drop query

Question

i am creating a procudure for temp table. IF EXISTS (SELECT TEMP1.*TEMP1.Total + (SELECT COALESCE(SUM(Total)0) FROM TEMP1 t1 WHERE t1.ROWNO ORDER BY OrderID ) DROP TABLE TEMP1 in this i am getting error The ORDER BY clause is invalid in views inline functions derived tables subqueries and common table expressions unless TOP OFFSET or FOR XML is also specified. please help me how to resolve this???

Manas Mohapatra · Answer

Here is some resolution: 1. It is not required to use TEMP1.* TEMP1.Total. Only one column is sufficient. 2. There is syntax error in ISEXITS(). SUM() you need to use when you will have groupby query. Try like below: IF EXISTS (SELECT * FROM TEMP1) BEGIN END