[PHP-WIN] Problem with procedures in MSSQL

[Hugo Alexandre Almeida Soares Dias]

I created a stored procedure in MSSQL like this:
CREATE PROCEDURE destaques_relacionados @codigo_doc int, @relacao
varchar(20) AS
SELECT     TOP 5 DN.cod, DN.titulo
FROM         dbo.Keywords_associacoes KA INNER JOIN
                      dbo.Destaques_noticias DN ON KA.documento = DN.cod
INNER JOIN
                      dbo.Associacoes A ON KA.associacao = A.cod
WHERE     (KA.keyword IN
                          (SELECT     keyword
                            FROM          keywords_associacoes ka2,
associacoes a2
                            WHERE      ka2.documento = @codigo_doc AND
ka2.associacao = a2.cod AND a2.tabela = @relacao)) AND (KA.documento !=
@codigo_doc) AND (A.tabela = 'Destaques')
GROUP BY KA.documento, DN.data, DN.cod, DN.titulo
ORDER BY COUNT(KA.keyword) DESC, DN.data DESC
GO

This procedure when i execute it in the SQL Analyzer runs instantaniously,
but in PHP hangs till timeout.
can anyone tell me what i must do to solve my problem?




Hugo Alexandre Dias
Eng. Sistemas Informática
[EMAIL PROTECTED]

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]