Problematic Queries
(its showing time out error)

declare @id uniqueidentifier

declare @type varchar(50)

set @id = '048E29F9-29BF-4ABD-B24E-05ADE41FCFF9'

set @type = 'BM'

--CREATE PROCEDURE proInComingTransactionsCOC(@type varchar(50), @id varchar(50)) AS

--BEGIN

--if @type='MUTHOOT'

--BEGIN

            Select

                        td.Id,

                        td.PayinDateTime,

                        td.TransactionNumber,

                        td.Status,

                        td.RecommendedPayOutAgentId,

                        cd.BFName +' '+ cd.BLName as Name,

                        td.PayOutAmount as PayOutAmount,

                        ll.Name as City

            From

                        TransactionDetails td

            inner join PaymentModeList pml on td.Paymentmode=pml.Value

            inner join CustomerDetails cd on td.ID=cd.TransactionID

            inner join LocationList ll on ll.ID=td.PayoutLocationID

            Where td.RecommendedPayOutAgentId

                        In (Select Id From AgentLocationList Where AgentAccountId=@Id and Name like '%Muthoot%')

                        And td.Status = 'Processed' --And PaymentMode Not Like '%Draft%'

                        and pml.Prefix = 'COC' order by td.PayinDatetime;

Hi,

I can't see anything wrong with your query here.

I'm sure you probably tried this already but its worth a shot. If these two queries run fine in QA, just start adding to the first query to see when it fails. You probably already know this. Sorry I couldn't be of more help.

Richard