Thank you...But is there any simple way of writing this. I have lot of ID`s and it has to be implemented for those too.

Th logic is between the dates ADT and RDT.

ADT date range should have the most recent of the RDT.

I have grouped on that parameter values and then had the tablix into a rectangle as I need the each value`s data to fit into a single page.

Also..the software need to identify the objects while typing.

I tried your logic but the result should be

Your result is:

But can I get the results without using XML and pass them as variables as below.

DECLARE @Result1 NVARCHAR(100),

@ResultValue1 NVARCHAR(100),

@Result2 NVARCHAR(100),

@ResultValue2 NVARCHAR(100),

@Result3 NVARCHAR(100),

@ResultValue3...

The below values need to be passed as parameters from SSRS report and these values may change everytime the report is ran. So they cannot be put into a #pTable.

('Cat',...

I need to pass the values in SSRS report for the parameters. And here you are hardcoding the required values into #pTable but need to pass them. Please help.

The main criteria can be AND/OR i:e

Cat > 200 AND/OR

Horse < 40 AND/OR

Lion > 100 AND/OR

Tiger > 150

Thanks All.

Yes..

I only want the ids that are in common between the result sets.

Since #3 didn't return any results, that one is not counted?

Also, If the logic is changed to have...

I need to pass parameter values as per below declare statements.

For @param1 is for #temp1, @param2 is for #temp2, @param3 is for #temp3 and @param4 is for #temp4.

DECLARE @param1 VARCHAR(25)...

I want compare A vs B and create a graph out of it on Counts...thank you!!

its from 2005 to 2008...I have gone through the steps in msdn lib but need a video tutorial link if possible which shows all the steps for migration..

Thank You! This helps....