Как это правильно сделать?Руководство.
SELECT a.ID,
DATEADD( s, RAND( CONVERT( INT, CAST( NEWID() AS BINARY(16) ), 1)) * 252460800, '20080101' ) AS dt
FROM
(VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)) AS A (ID)
CROSS JOIN
(VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(11), (12), (13), (14), (15), (16), (17), (18), (19), (20),
(21), (22), (23), (24), (25), (26), (27), (28), (29), (30)) AS B(C)
ORDER BY NEWID()
не могу отсоединить БД,Остановите службу сервера и файлы освободятся.
SELECT main_id AS [Код], 0 AS [Код.Код], 0 AS [Код.Код.Код], name_site AS [Текст]
FROM MainTabMatrix
WHERE name_site = 'Начальник РЭС'
UNION
SELECT MainTabMatrix.main_id, id_taks, 0, NameTask AS [Текст]
FROM MainTabMatrix
JOIN TasksM ON MainTabMatrix.main_id = TasksM.main_id
WHERE name_site = 'Начальник РЭС'
UNION
SELECT MainTabMatrix.main_id, TasksM.id_taks, duties_id, NameDuties AS [Текст]
FROM MainTabMatrix
JOIN TasksM ON MainTabMatrix.main_id = TasksM.main_id
JOIN Duties ON TasksM.id_task = Duties.id_task
WHERE name_site = 'Начальник РЭС'
ORDER BY 1, 2, 3