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