How to achieve that? And it's not a one-time thing. Every time there's new data in the DB, the clients need to click download and file will be saved

Looks like you need to use recursive CTE. But I don't understand your question and your output requirement

It depends how your real data looks like but if there's only one comma and one dot you can do something like this:

update yourTable

Set YourColumn=substring(YourColumn, 1, CharIndex(',', YourColumn)-1)+' '+'INC' from...

I just use a simple example to illustrate what I want to achieve. In reality I have a dynamic sql to openquery a MDX query and the parameterized MDX query...

Thank you for all the responses! Guys

I just figured out that I need to move the select* from #temp into the try block. I think I am just unclear...

To be more accurate I want two different reports with header and footer to be displayed at the same time.

Is there any way to do it?

Thanks

MaggieW (1/30/2015)

---

Hi, All

I created a...

Thank you! Jeebee

I learned something new. It's indeed a smart way!

Thank you so much again!

Thank you all for your help.

I decided to use a case when statement in my TSql as follows

insert into Employee (ID, Name, Age, Salary) values (@ID, @Name, (case when @Age...

Here's a link you can refer to:

http://www.mssqltips.com/sqlservertip/2556/net-application-for-sql-server-data-management/

Thank you! Lowel

It worked!

MaggieW (7/14/2014)

---

Dear all:

1. We had this requirement to remove the null checkbox next to the parameter. Anyone has any idea how to do that.

Please refer to Capture.JPG for the parameter...

That's correct!

You are welcome! Steve

Just found out that I...

sgmunson (7/10/2014)

---

I'm at a loss to understand, as his...

Thank you all your gurus for all the beautifully written solns and I adopted Sachin's one in the end!

Thank you again!