It looks as though all your cursor is doing is adding 1 to a date each iteration. You can use a tally for this type of thing which is easier...

You should start by reading this article. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Then keeping that article in mind, read this article and follow the advice found within. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D

I think you are missing the point. The reason the performance of this is awful is...

kraaitje (7/8/2015)

---

Situation:

I got a table with organisation codes with postcal code ranges, from-to.

Example:

Organisationcode, startpostalcode, endpostalcode

001 52005249

I would like to generate rows for this range like this:

001 5200

001...

I was remiss in mentioning as Michael did that if the entire name is "ID" or "Id" then neither is appropriate. That kind of thing means you have to change...

Rod at work (7/8/2015)

---

Where I work we have several SQL Server databases. Well over a hundred. Most are SQL Server 2008 R2, but some are still in SQL Server 2005....

John Corkett (7/8/2015)

---

Hi,

Please can anyone point me to any conventions for using ID or Id as column names in T-SQL?

There is a debate in programming circles about this and microsoft...

Back from Webelos camp. We had a pretty intense evening Monday night. There were tornado warnings around the camp so we went on EP (Emergency Procedures) which meant that everybody...

aron.vandermeyden (7/6/2015)

---

Is it not true that there are no non-deterministic functions. Simply those that fully specify their inputs and those that don't?

Or put another way, the definition of non-determinism is...

Brandie Tarvin (7/2/2015)

---

BL0B_EATER (7/2/2015)

---

Lynn Pettis (7/2/2015)

---

I'm taking the youngest down to ERAU for a Spy Camp next week followed by a Soccer Camp the following week. I will be...

BL0B_EATER (7/2/2015)

---

Lynn Pettis (7/2/2015)

---

I'm taking the youngest down to ERAU for a Spy Camp next week followed by a Soccer Camp the following week. I will be travelling home...

I agree with Alvin. The question is why do you care what order the columns are stored in? Your queries should be explicitly naming the columns anyway. Just put the...

Yes indeed. Pretty sure I checked out right...

Thanks Gail and Luis. Don't know how I missed that. 😛

Can somebody with 2012 help out here? http://www.sqlservercentral.com/Forums/Topic1699780-2799-1.aspx

We don't have 2012 at work yet and I don't see anything glaring at me that is incorrect with the query.