SQL Server Performance

Search Results

Search Again
  1. Lin100

    Access ADP and Stored Procedure error

    Post by: Lin100, Jan 9, 2007 in forum: T-SQL Performance Tuning for Developers
    Hi ranjitjain. There is only two places where the subroutine get_subfrm_recs gets called. 1) It is called when a user click on the combo box named...
  2. Lin100

    Access ADP and Stored Procedure error

    Thread by: Lin100, Jan 8, 2007, 3 replies, in forum: T-SQL Performance Tuning for Developers
    Access 2003 and SQL 2000 Server. I have a form that have two combo boxes (Dept, and SO) and a subform (Q_FilteringQuery subform). When I first...
  3. Lin100

    How to convert Access VBA code with string queries

    Thread by: Lin100, Dec 4, 2006, 1 replies, in forum: Non-Transact SQL Developer Performance Tuning
    How to convert Access VBA code with string queries into Stored Procedure Access 2003 and SQL 2000 Server I have a code below that work with SQL...
  4. Lin100

    Run a query that uses "IIF" & "Between" in Access

    Post by: Lin100, Oct 5, 2006 in forum: General Developer Questions
    Hi merrillaldrich. Given the query below, I have two questions:<br /><br />SELECT [1_Job - Parent].*, Ref_DepartmentID.DepartmentName<br />FROM...
  5. Lin100

    Run a query that uses "IIF" & "Between" in Access

    Thread by: Lin100, Oct 5, 2006, 3 replies, in forum: General Developer Questions
    Access 2002 and SQL 2000 Server. How to run a query that uses "IIF" and "Between" in an Access project file (ADP) ? I have an Access project file...
Showing results 1 to 5 of 5
Search Again