Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SQL Not returning the same as it does when embedded in a SSRS Report RE: SQL Not returning the same as it does when embedded in a SSRS Report
SoHelpMeCodd
SSCertifiable
Points: 5871
More actions
August 22, 2016 at 7:39 am
#1896646
Breaking up the query changed results. For example, the predicate
nt on a.ArtworkId = nt.ArtworkId
was not tested.
And to be sure that T-SQL is what SSRS is running, it would be best to trace or collect an extended event.