Hi Journeyman,

Thanks for the reply. I am not using grid control. I am using Report Viewer Control for displaying reporting service's report on a .aspx page and client wants result...

Hi Veteran and Newbie,

Thank you for the post. I have already informed my client what is possible and what is not achievable under given specifiactions. They have come around to...

Hi Grasshopper,

Thank you for the reply.

Yes I have input variables in stor proc that need to be passed during run time and in case of T-Sql I declare and set...

Hi Jack,

Thank you for the reply. I will surely go through you suggestions till now I never looked at it.

Bharat.

Thanks for ideas. I use asp.net application which has pages with ReportViewer Controls on it, these pages display reports of reporting service's reports and I have to follow client's wishes(Client...

Well you are right. In my case I have to confirm to the way they used to see the reprots and which was written by ealier developers using Web Grid control and...

Thank you for the hint. I will try out.

Bharat.

Those results are to be displayed unsorted on reporting service's reports..client wants that way.

Thank you.

Thank you for the reply.

I have index on the table. But when I run the sotr proc as query it does not order in any particular way but when...

Hi Frank,

Thank you for the suggestion. I am toying with the same idea. Although my stored procedures use Temp Tables and are complicated so I was thinkng if there were...

Hi Jeff,

Thank you.

Finally I got everything working.

Bharat.

Hi Jeff,

Thank you for your reply. As I was having problems with temp table I created real tables in database and solved the query. But I would like to work...

Hi Jeff,

Thank you so much. However when I do like

create table #temp (mem_id nvarchar, hcc1519 nvarchar)

insert #temp exec t_1519

select * FROM #temp

I get empty table back!!

Any reason?

Thank you in advance.

Bharat.

Hi Jeff,

Thank you for your kind reply. I did what you suggested and wrote the query as follows:

======

CREATE PROCEDURE T_1519

AS

SELECT DISTINCT member_id,

MIN(CASE WHEN hcc IN (15,16,17,18,19)THEN hcc ELSE NULL

END)

FROM mem_hist_dist_hcc...