Can you post what you tried? Not sure what you mean by not the proper result.

The ROW_NUMBER example provided by Eugene is exactly what you need.

If you didn't have this update in a transaction it will be a little challenging. You can either restore to a point in time or restore to a point before...

You're welcome. 😀

Are these updates slow? Not sure if you are just unsure of your approach of if you are having performance problems. You have several where clauses that are not sargable.

Instead...

Thanks for the ddl and sample data. Very refreshing to see somebody post a question making it so easy to answer.

This works on your sample data.

select replace(REPLACE(F1, 'FOLDERS(', ''), ')',...

Lynn Pettis (4/16/2012)

---

With "the one", do you think it time to tell him the following?

1. Get out a blank piece of paper.

2. Put your name and today's date at the...

Well figure that out and get back to us. We can help you recreate a formula in sql. We will not be able to help you figure out what that...

See you were super close.

Try this:

declare @cmd1 varchar(5000)

set @cmd1 = 'select run_date = getdate(), @@servername as server_name,

database_name = ''?'',

a.name object_name, b.name as index_name, a.type_desc, a.create_date, a.modify_date,

b.type_desc...

hbtkp (4/16/2012)

---

i dont know what is cumulative formula.

but this is how i am getting my final data in report.

so based on how they calculate , i need to do implement...

Can you post what you have so far? My guess is you are closer than you think.

How about a simple explanation about what you want??? What is a cumulative? Do you have a column with that information in it? I hope your communication skills in real...

Dynamic sql will run in its own thread, your variable outside of the dynamic sql. You must declare it INSIDE the dynamic portion.

Brandie Tarvin (4/16/2012)

---

WayneS (4/16/2012)

---

Brandie Tarvin (4/16/2012)

---

If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

2) How many parameters...

Help us help by posting details.

Help us help by posting details.

Help us help by posting details.

Help us help by...