Jeff,

As requested, I am adding the sql for creating the data.

Apologies for not doing it.

declare @student table
(
StudentId int
,SubmissionDate date
)

insert into @student(StudentId,SubmissionDate) values(1,'10/01/2018')
insert into @student(StudentId,SubmissionDate) values(2,'10/01/2018')
insert into @student(StudentId,SubmissionDate)...

Thank you everyone for taking the time to answer my question.

All your answers were very insightful.

SSRS is not blocking,but is it a good practice to create 6 different Datasets and tying it up with 6 different stored procedures.

Awesome pietlinden.....

Thank you so much.....

It worked....

Thanks Chuck Hottle and ColdCoffee for your quick response

I am debugging a Stored Procedure and came across this SQL Statement.

The actual sql statement is some what like:

DECLARE @itemId INT

SET @itemId...

Thanks guys for all the responses!!!

Thanks guys for all the responses!!!

dwain.c

Thanks for all the help!!!

Gail,

My mistake,I was running the query on SQL Server 2000.

Thanks and Regards

Thanks Craig

As the correct output is Null,'Is Zero', 'Is One', 'Is Two'.

I want to know why NULL is also the part of the output.

The explanation says that:

The statement CASE COL1 WHEN...