
Hice esta consulta en sql-server y me funciono a la perfeccion pero al hacerla en PHP y enviarla a la base de datos me da un error diciendo que la tabla #PlayerTemp no existe:
Código PHP:
$sql1 = "SELECT IdPlayer, Player, Name, LastName, Email, Password, IdBook
INTO #PlayerTemp
FROM PLAYER
WHERE Name LIKE '%luis%' AND LastName LIKE '%espinoza%'"
$this->strData = $this->strConnect->query($sql1 );
$sql2 "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 [CPW-SQLP105].[BackOffice].[dbo].[login] L, #PlayerTemp P, BOOK D, [CPW-SQLP105].[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($sql2);
$deleteTlbTemp = "DROP TABLE #PlayerTemp";
$this->strData = $this->strConnect->query($deleteTlbTemp);