SSRS : Multivalued Parameters
I am creating a simple SSRS report to demonstrate the workarounds available to pass multivalue parameter to Stored Procedures. Stored procedures are capable of receiving scalar values as input for ...
12 Years Ago
SSAS : Cube Metadata - Documentation
We all are seeing a continuous importance for documentation in any project work that we do. I can see a common factor in developers that they all hate to do documentations, we are comfortable to de...
12 Years Ago
T-SQL : Gaps and Islands Problem - 2
There are lot of ways to find the gaps in a sequential numbers, and some of them are listed below. I have posted some 3 methods to achieve the expected. The goal is to find the gaps between the seq…...
12 Years Ago
T-SQL : Delete duplicates in a table using Query
Following are the queries that will delete all available duplicates in a table, please refer the query below Before deletion: Output: Alternatively, the same operation can be done using a CTE as sh…...
12 Years Ago
T-SQL : Query to fetch report subscription details from SSRS
In SSRS, to find who has created/modified the report subscription without using the management site, the following query can be used, This is will help in finding who has created the subscriptions …...
12 Years Ago
T-SQL : Get all folder names from SSRS Reports Manager/Server
We all know, we can query the report server database and get very useful information, such as reports details, directory and schedules etc. This particular thread belongs to one such category, this…...
12 Years Ago
