We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

I have always been inspired by a particular quote from Arthur C Clarke - “The only way of finding the limits of the possible is by going beyond them into the impossible”. The more you think of it, the more you make sense out of it. If you decide in your...

I have always been inspired by a particular quote from Arthur C Clarke - “The only way of finding the limits of the possible is by going beyond them into the impossible”. The more you think of it, the more you make sense out of it. If you decide in your...

In my previous post, Using Multi-value Parameters in SSRS Report, I blogged about how to write a table-valued function in SQL to take a multi-value report parameter. The function ListToTable can take a list such as this: 123,904,949,837,495,399 and co...

In my previous post, Using Multi-value Parameters in SSRS Report, I blogged about how to write a table-valued function in SQL to take a multi-value report parameter. The function ListToTable can take a list such as this: 123,904,949,837,495,399 and co...

In the previous blog post, SSRS #50 – Using Parameters in SSRS (1), I listed 7 different ways you can use report parameters. They are also the skills that report developers need to master in order to develop interactive reports. In this blog, I&r...

In the previous blog post, SSRS #50 – Using Parameters in SSRS (1), I listed 7 different ways you can use report parameters. They are also the skills that report developers need to master in order to develop interactive reports. In this blog, I&r...

A reader asked me how to add grand totals a matrix (A Sample of Matrix in SSRS). It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here. Challenge Suppose you have a very simple table...

A reader asked me how to add grand totals a matrix (A Sample of Matrix in SSRS). It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here. Challenge Suppose you have a very simple table...

Hi , Is there any way to know Tables, Views and Functions used by a stored procedure in Database... I tried using the below Query but It does not show all the tables. any help is appreciated. SELECT Table_Name, proc_name AS [Object_Name], 'P...