RIAS
asked on
Sql query to Stored Procedure
Hello,
I have a query need to convert it to SP:
Any suggestions:
I have a query need to convert it to SP:
Any suggestions:
SELECT TOP 1 CASE WHEN cnt = cnt1 THEN 1 ELSE 0 END IsCheckedAll
FROM (
SELECT * , COUNT(*) OVER () cnt , COUNT(Checked) OVER () cnt1 FROM PRXTRACT
WHERE InvoiceNumber =@InvoiceNumber
)k
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Got it. It is Varchar only. Its the same query I wrote yesterday. :)
ASKER
Experts,Both the solution are same except datatype.
Will split points equally.
Will split points equally.
This should be faster:
IF EXISTS ( SELECT *
FROM PRXTRACT
WHERE InvoiceNumber = @InvoiceNumber
AND Checked IS NULL )
SELECT 0 AS IsCheckedAll;
ELSE
SELECT 1 AS IsCheckedAll;
ASKER
Thanks Stefan!