maycolalvarez si pones este código en el SQL-SERVER te va a trabajar a la perfeccion, de hecho te crea la tabla con los valores retornados del select:
Código PHP:
SELECT IdPlayer, Player, Name, LastName, Email, Password, IdBook
INTO #PlayerTemp
FROM PLAYER
WHERE Name LIKE '%luis%' AND LastName LIKE '%espinoza%'
Pero de esa forma simplemente no me quiso funcionar desde el PHP. Entonces opte por hacer lo siguiente y funciona al 100%, lo dejo por si alguien alguna vez se llega a encontrar en la misma situación que yo. Si le sirve a alguien recuerde dejar puntos
Código PHP:
$tlbTemp = " CREATE VIEW testing AS SELECT IdPlayer, Player, Name, LastName, Email, Password, IdBook
FROM PLAYER
WHERE Player LIKE '%P1%' AND Name LIKE '%TEST%' AND LastName LIKE '%TEST%' AND
Email LIKE '%[email protected]%' AND Password LIKE '%.BP888%' AND Phone LIKE '%%' AND
Zip LIKE '%%' AND Status = 'E' ";
$this->strData = $this->strConnect->query($tlbTemp);
$sql = " SELECT TOP 10000 P.[IdPlayer],
P.[Player],
L.[username],
L.[password],
L.[ip_address],
L.[login_date],
L.[success],
D.[Description],
B.[host_name],
P.[Name] + ' ' + P.[LastName] AS 'Name',
P.Email
FROM [BackOffice].[dbo].[login] L, testing P, BOOK D, [BackOffice].[dbo].[book] B
WHERE D.[IdBook] = P.[IdBook] AND L.[book_id] = B.[book_id] AND D.[IdBook] = L.[book_id] AND
P.[player] = L.[username] AND B.[id] = L.[website_id] AND
L.[login_date] >= convert(datetime,('2013-01-30 20:10:11')) AND L.[login_date] <= convert(datetime,('2013-11-01 20:10:11'))
AND L.[success] = 'N' ";
$this->strData = $this->strConnect->query($sql);
$deleteTlbTemp = "DROP VIEW ViewPlayerTemporary";
$this->strData = $this->strConnect->query($deleteTlbTemp);