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