
select top 100 * from tbEndOfMonthSection with(nolock)

select top 100 * from tbEndOfMonthTemplate with(nolock)

select top 100 * from tbEndOfMonthTemplateSectionMap with(nolock)

select top 100 * from tbEndOfMonthStatusCheck with(nolock)
order by 3 desc

select top 100 * from tbReport with(nolock)



select * from tbReport with(nolock)
where ReportID in (1022, 1053, 1067, 1068, 1086, 1088, 1097)

select top 10 * from tbLocalisationData with(nolock)
order by 1 desc

select * from tbEntity with(nolock)
where EntityID = 875

select * from tbEndOfMonthStatusCheck with(nolock)
where EntityId = 875 and ApplicablePeriod = '20180901'

update tbEndOfMonthStatusCheck
set ReportsStatus = 0
where EndOfMonthStatusCheckId = 101


select top 100 * from tbCachedReport with(nolock)
--where UserId = 696727
order by 1 desc


select top 100 * from tbReport with(nolock)
order by 1 desc

select * from tbReport with(nolock)
where ReportFileName = '/Service/Reports/MxReportInventoryExtensionOverhead'

select top 100 * from tbReportCustom with(nolock)
where ReportName = '/Service/Reports/MxReportInventoryExtensionOverhead'


select * from tbReportParameter with(nolock)
where ReportID = 1022


select top 10 * from tbAutoNotification with(nolock)
order by 1 desc



