SELECT * FROM ReportingGroups ORDER BY TabOrder DESC

SET IDENTITY_INSERT ReportingGroups ON
INSERT INTO ReportingGroups 
	(ReportingGroupsId,[Name],TabOrder,Term) 
VALUES
	('<group id>','<group name>','<order>','Inventory')
SET IDENTITY_INSERT ReportingGroups OFF


SELECT * FROM ReportingLinks ORDER BY ReportingLinksId DESC
SELECT * FROM ReportingLinks ORDER BY LinkOrder DESC

SET IDENTITY_INSERT ReportingLinks ON
INSERT INTO ReportingLinks
	(ReportingLinksId,[Name],ParentId,LinkOrder,Term,LinkContent,Color,[Type],CustomColor)
VALUES
	('<link id>','<report name>','<parent>','<order>','Inventory','/RMSReporting/<folder name>/<report name>','3','1','<hex colour code>')
SET IDENTITY_INSERT ReportingLinks OFF