What did the script look like? I am not familiar with that one but it must have something to do with context because I get a syntax error every way...

You should keep...

Notice how g.britton posted ddl and sample data in a consumable format. That is what you should do in the future. Well done g.britton and thanks.

Here is another approach to...

Here is one way to do this.

--Declare needed variables

--Declare @NoOfApprovals Int --don't need this

declare @Subject varchar(100) --adjust to meet your actual datatype of the parameter

--Get count of approvals

Select @Subject =...

robmcbarron (4/8/2014)

---

Noted for next time Sean!:w00t:

The output from the sample data gives you the number of months between date x and date y and runs perfectly fine on it's own....

meltingchain (4/8/2014)

---

Thank you Luis, the articles were new to me and I'm always looking for something to learn.

Also thank you Sean, this example was exactly what I was looking...

MyDoggieJessie (4/7/2014)

---

Thanks for the code Sean. I let it run for about 20 mins and killed it...

These tables are rather large :crazy:

Going to do some creative "googling" and see...

I figured the author was looking for NOEXEC but I disagree with the opinion that it is the best way.

Not so sure the xml approach is going to be very fast with 200 million rows. What about using MAX(SomeColumn)? That would likely be faster than where Column IS NULL....

robmcbarron (4/7/2014)

---

Thanks for your responses and apologies for not getting back sooner.

@Sean Lange - Thanks for introducing those aliases as it is far easier to read! The results from your...

balasach82 (4/7/2014)

---

I have a set of 5 queries as 5 rows in a table. I am looping 1 by 1 and execute the queries, 5 in all, using sp_exectuesql

what is...

Big Kudos!!! You are new around here and you posted everything so nicely. This makes it simple and easy to work on the issue. As Luis said, the articles are...

Sounds to me like the OP is going inserting data that was missed in the original programming. Therefore you need...

john.deprato (4/7/2014)

---

From my experience, it's how you write the LINQ query that makes the biggest difference. Whether you are using lambda expressions or writing from selects, etc... I have been...

Oblivion (4/7/2014)

---

Using the ISNULL() method you will also have to account for the user deleting description1 or effectively setting it to ''. You will need to pick up that change...