mercredi 25 février 2015

SQL Query Help -- Trimming


I'm using the following query to get SSRS report execution related information:



select username, parameters, Itempath, timestart, timeend, TimeProcessing, status from ExecutionLog3
where ItemPath like '%reportname'


In here, the output of ItemPath comes like this:



/{a42a9aba-ced8-4949-9721-8478f925287a}/BIV/AEX/AEX_Reports/Batch_Details.rdl


My requirement to trim this column and just output the report name:



Batch_Details.rdl


Is it somehow possible to do this by modifying the above mentioned query? Currently I'm using excel for this purpose.


Please look into this.





Aucun commentaire:

Enregistrer un commentaire