nolock hint

Instead of setting the transaction level in SQL for seeing uncommitted transactions you can now use the nolock hint as in the sql statement below:select * from PROJTABLE (nolock) order by RECID descif you have many tables in the query:-- Get the funding limit tracking records by project IDselect T8.AccountingDistribution, T1.ProjectAccountingDistribution, T1.RecId as ProjFundingLimitTrackingRecId,...

How to debug an SSRS report

Sometimes when you place a breakpoint in a data provider class to debug an SSRS report and exercise the report to hit the breakpoint it works and sometimes it doesn't. So the trick to always make the hit is to inherit from the SrsReportDataProviderPreProcess class instead of the SRSReportDataProviderBase class...

Back to Blog

© 2020 Dynaxti, inc. All rights reserved.


Social Media