Thank you Lynn and Conficker, your solutions both worked.

BTW, is there a button to mark as a answer? I didn't find it.

Sure, sorry I didn't clarify clearly. This is only one parameter, which has 20 drop-downs of 20 date range. And we can choose any of it to render report. First...

Hi Conficker,

Appreciate for your inputs. The dataset you provided is the same as my ssrs expression, from which get the first drop-down. But I had some problems for the...

Hello Jeff, thanks for reply. I am still working on this.

CELKO (10/24/2011)

---

>> I'm not really familiar with T-SQL, please any help appreciate. My platform is using MS SQL 2008 r2.<<

Yo also do not know much about data modeling, either :))...

Hello Arjun,

Thanks for reply. Let me explain in another way, hope it works:)

The original table only records when the data is changing, now the problem is to insert everyday's record.

Take...

Evil Kraig F (10/18/2011)

---

Another option is to use ROW_NUMBER() to assign positional indicators to the records via a CTE, then link them up on id = id - 1. ...

Hi CELKO,

Sorry for the confusion, please see DDL following and I am new to SQL, so I don't really understand how to stored procedure will correct the NULL mistake which...

Thank you so much Toddasd, it works great

I am trying to create a calendar table with all datetime for the year 2011. And join calendar table and mytable.

But I...

The lastest status for 2323 on 6/30/2011, the status is on after that...