1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| -- 1
Create tabe #TMP_NewIdent
(NameBoard ....
MName .....
DateTimer ....
NewIdent)
-- 2
INSERT INTO #TMP_NewIdent
(NameBoard, MName, DateTimer, NewIdent )
SELECT NameBoard, MName, DateTimer, NEWID()
FROM ....
WHERE ...
GROUP BY NameBoard, MName, DateTimer
-- 3
SELECT
CONCAT(A.NameBoard, SUBSTRING(A.MName,0,9),'-', SUBSTRING(A.DateTimer,0,11),'-', A.DateOfTest,'-', T.NewIdent) as SerialNum
FROM ... AS A
INNER JOIN #TMP_NewIdent T
ON T.NameBoard = A.NameBoard
AND T.MName = A.MName
AND T.DateTimer = A.DateTimer |
Partager