question

cruizersofthemillenium avatar image
cruizersofthemillenium asked

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][1] Thank you, Syed. [1]: /storage/temp/4262-output.png
sqlt-sqlsql-server
output.png (7.0 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.