You have a couple of things going on here. The first is you have some data in period_name that can't be converted to a datetime. This is what is causing...

And using set rowcount is not a good habit to learn now. It will no longer affect insert, update or delete in the NEXT version of sql. It is better...

Welsh Corgi (7/17/2012)

---

I was sent Scripts to execute multiple Merge Statements.

There are no Go Stement between each Merge which may be a good thing.

Will the scripts execute in parallel and...

pistolpete (7/17/2012)

---

Thanks guys. I attached my execution plan. The table I am trying to query is very large (150 Million rows). There is a clustered index on...

You...

capn.hector (7/17/2012)

---

i should not try to solve problems real quick before lunch. empty stomach leads to face palm moments. no need to add N to 65 since thats...

You have been around here long enough to know that you should post ddl, sample data and desired output. Read the article at the first link in my signature. Post...

Nice job posting ddl and sample data. I am however complete confused with what you want this query to do. Can you try explaining this again more clearly?

capn.hector (7/17/2012)

---

Sean Lange (7/17/2012)

---

capn.hector (7/17/2012)

---

Here is mine, slightly different way to calculate the bits

DECLARE @STR VARCHAR(8000)

SET @STR = 'Rang the client and agreed they would begin to pay off...

capn.hector (7/17/2012)

---

Here is mine, slightly different way to calculate the bits

DECLARE @STR VARCHAR(8000)

SET @STR = 'Rang the client and agreed they would begin to pay off £x off their...

Check out Gail's article on how to post performance problems.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

edstewart (7/17/2012)

---

Please forgive if this has been asked and answered... I have to move content from one system to another. In the first system, FirstName and LastName are separate columns,...

This can be done using a Tally Table.

Thanks to Wayne Sheffield for the concept on doing this.

declare @LongText varchar(255) = 'Rang the client and agreed they would begin to pay...

dndaughtery (7/17/2012)

---

I was told someone interviewing me would ask this. In my 7 years of DB Development Ive never had a need like this but thought I could vaguely remember...

Lowell also has one that he has posted several times. His does a few things different than mine. His is also resource intensive so DO NOT RUN THIS IN PRODUCTION!!!!

CREATE...