Executing Queries showing only partial queries (everything going to one line) with Example

Bjohnst12's profile image Bjohnst12 posted 5 years ago in Running SQL scripts Permalink

I have run into a problem where when I try to run all queries it only shows the first 78 queries (it still runs the rest of the queries but runs them on the same line as if it was just one big query) but when I get the results it just gives me the amount of time that it took for the first 78. If I run the rest of the queries after the problem it shows the following 180+ queries without a problem. I have tried multiple things to try and resolve the problem but not sure what I am missing.

PROBLEM QUERY : CREATE TABLE if NOT EXISTS 080SumCPT SELECT P.HNPI, P.NPI, SUM( Case when P.CPT="G0438" then P.CPTCount END ) AS 'G0402Total', SUM( Case when P.CPT="G0439" then P.CPTCount END ) AS 'G0438Total', SUM( Case when P.CPT="G0402" then P.CPTCount END) AS 'G0439Total' FROM awvcount P GROUP BY P.NPI ;

PS. running a few procedures before this query. and updates to said query after.

ansgar's profile image ansgar posted 5 years ago Permalink

You should watch out for the drop-down menu on the blue "play" button in HeidiSQL. There you can specify whether to run multiple queries in one go or one-by-one.

Please login to leave a reply, or register at first.