Home Forums SQL Server 7,2000 T-SQL Any better Ideas that may speed this procedure up? RE: Any better Ideas that may speed this procedure up?

  • Try this

    
    
    SELECT
    T1.Param_ID,
    T1.Value,
    MAX(T1.[Date]) as DataDate,
    T2.DefaultOrder,
    T2.Order1,
    T2.Order2,
    T2.Order3,
    T3.DataType_ID AS Type
    FROM
    dbo.tblValues AS T1
    INNER JOIN
    dbo.tblParam AS T2
    ON
    T2.Param_ID = T1.Param_ID
    INNER JOIN
    dbo.tblSetupKey AS T3
    ON
    T3.Key_ID = T1.Key_ID
    INNER JOIN
    dbo.tblKey AS T4
    ON
    T4.ID2 = T1.KEY_ID AND
    ID1 = @ID1 AND
    ID2 = @ID2 AND
    DataType_ID IN (1,2,5,6)
    GROUP BY
    T3.DataType_ID,
    T1.Param_ID,
    T1.Value,
    T2.DefaultOrder,
    T2.Order1,
    T2.Order2,
    T2.Order3