How to Apply filter or call parameters on Dynamic pivot?
I have this test data which I created it into a dynamic pivot. Now I need to filter the data on each column or call parameters from the grid1 table. Below is the fiddle that contains initial table script and the dynamic pivot query to generate the results.
http://sqlfiddle.com/#!6/bb421/2 Desired Output: If I search for UID# 123246 it should return the below and should not have duplicates ![alt text] Thank you, Syed. : /storage/temp/4262-output.png