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


declare @oldReportFileName varchar(150) = '/SQL/Reports/InventoryItemsByVendorOrders'
	, @newReportFileName varchar(150) = '/SQL/Reports/SuggestedOrdersItemsDetail'
	, @oldReportName varchar(150) = 'Inventory Items by Vendor Orders'
	, @newReportName varchar(150) = 'Suggested Orders - Items Detail'

select ReportFileName
	, Title
from tbReport with(nolock)
where ReportFileName = @oldReportFileName


update tbReport
set UseReportQueue = 0
where ReportID = 1395

update tbReport
set UseReportQueue = 1
where ReportID = 1395


-- SuggestedOrdersItemsDetail

