--Select * from sCommon.tReport Where ReportPath like '%Certificate_Bonafide.rdlc%'
--Select * from sCommon.tReport Where id = 10155 

--Report Path update
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\Assessment\General\ResultSheet\ResultListConsolidateWithMarks.rdlc' Where id = 20481
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\Assessment\General\ResultSheet\ResultSheetNineMarkGrade.rdlc' Where id = 30767
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\Assessment\General\ResultSheet\ResultSheetEightAllMark.rdlc' Where id = 20487
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\ReportCustom\Certificate_FirstTrial.rdlc' Where id = 10156
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\ReportCustom\Certificate_Transfer.rdlc' Where id = 30223
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\ReportCustom\Certificate_Leaving.rdlc' Where id = 10155
Update  sCommon.tReport Set ReportPath = '~\RDLCReports\ReportCustom\Certificate_Bonafied.rdlc' Where id = 20877


--Common Orggroupbatch order update
DELETE FROM [sSetup].[tCommonOrgGroupBatchMaster]
INSERT INTO [sSetup].[tCommonOrgGroupBatchMaster]([Id],[Code],[Title],[IsObsolete]) VALUES
            (1,	'2020-2021',	'2020-2021',	0),
			(2,	'2019-2020',	'2019-2020',	0),
			(3,	'2018-2019',	'2018-2019',	0);
GO
SELECT * FROM sSetup.tCommonOrgGroupBatchMaster
----SELECT Id, Code, Title, OrgGroupId, CommonOrgGroupBatchId FROM sSetup.tOrgGroupBatchMaster Where Code like '2020%'
Update sSetup.tOrgGroupBatchMaster Set CommonOrgGroupBatchId  = Null
Update sSetup.tOrgGroupBatchMaster Set CommonOrgGroupBatchId  = 3 Where Code like '2018%'
Update sSetup.tOrgGroupBatchMaster Set CommonOrgGroupBatchId  = 2 Where Code like '2019%'
Update sSetup.tOrgGroupBatchMaster Set CommonOrgGroupBatchId  = 1 Where Code like '2020%'

SELECT Id, Code, Title, OrgGroupId, CommonOrgGroupBatchId FROM sSetup.tOrgGroupBatchMaster 


