Loading

if exit table then drop query

Apurva Singh

9y981

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???

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
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