SELECT DISTINCT
MAX(EdiStcID_Grp)EdiStcID_Grp,EdiStcID, DENSE_RANK() OVER(ORDER BY
MAX(EdiStcID_Grp)) [Grp#]
FROM
#tmpSRT tsrt
GROUP BY tsrt.EdiStcID
Styling An Angular Application With Bootstrap
11 hours ago
SELECT DISTINCT
MAX(EdiStcID_Grp)EdiStcID_Grp,EdiStcID, DENSE_RANK() OVER(ORDER BY
MAX(EdiStcID_Grp)) [Grp#]
FROM
#tmpSRT tsrt
GROUP BY tsrt.EdiStcID
© Copyright by Bob Mihada | Template by Blogspot tutorial(slightly modified)