Hi all,

I've been handed a query which I'm trying to get to work. I'm using PHP to talk to MSSQL 7.

My question is this: Can I create temp tables with mssql without executing the code in a stored procedure?

The simplified version of the query is as follows:
$query = "SELECT distinct convert(varchar(36),traineeID)";
$query.=" INTO #tempdata1";
$query.=" FROM    tblSignIn_trainee a";

Later on I could make a stored procedure, but at the moment I would like to just work with the query directly in the code if at all possible.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to