How to execute a multi statement query on PHP via MSSQL

Question

I've been scratching my head for the past days or so and can't get this idea to work.

So basically, I have a query my boss gave me that involves 4 statements.

3 of them create temp tables.

The 4th one is a join query for the 3 tables.

How do I go about this?

I saw some examples like this: PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)

But I can't get it to work since I'm expecting a result set.

Just in case, I'm using Idiorm as my ORM, any possible solution outside that is also welcome.

Answer 1

Found out the issue, turns out if you need to use multiline statements using temp tables you can do it but you need to add this line on top of your query block:

SET NOCOUNT ON // THIS ONE;
SELECT * FROM <tbl_name> as #temp
...