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