> ClearParameters(); > AddParms("@selectdate", reportdate, "SQL"); > AddParms("@bankfedid", bankfedid, "SQL"); > >string commandtext = @" > select COALESCE( m.storename, ' ') as storename, COALESCE(m.serialnumber, ' ') AS serialnumber, dbo.GetNextPickupdate(@selectdate,store) AS nextpickupdate, t.*, t.hundreds + t.fiftys + t.twentys + t.tens + t.fives + t.twos + t.ones + t.mixedcoin AS totaldeposit from smartsafetrans t > LEFT JOIN view_ExpandedSafemast m ON t.safeid = m.idcol > where t.bankfedid = @bankfedid AND t.eventcode = 'DECL' AND t.postingdate <= @selectdate and (t.verifyid = 0 OR > (verifyid <> 0 AND verifyid IN (SELECT idcol FROM smartsafetrans WHERE bankfedid = @bankfedid AND eventcode = 'VER' AND postingdate > @selectdate )))"; >>When I run the above in a C# program as command type Text, it runs over a minute