¡@
c# Programming Glossary: trustaccountlogSQL Query slow in .NET application but instantaneous in SQL Server Management Studio http://stackoverflow.com/questions/2736638/sql-query-slow-in-net-application-but-instantaneous-in-sql-server-management-st Studio Here is the SQL SELECT tal.TrustAccountValue FROM TrustAccountLog AS tal INNER JOIN TrustAccount ta ON ta.TrustAccountID tal.TrustAccountID.. SELECT MAX tal.trustaccountlogid FROM TrustAccountLog AS tal INNER JOIN TrustAccount ta ON ta.TrustAccountID tal.TrustAccountID.. usr.UserID 70402 AND ta.TrustAccountID 117249 AND tal.TrustAccountLogDate '3 1 2010 12 00 00 AM' Basicaly there is a Users table a..
|