Really, sermon on the mount? Have you read that lately? When Jesus was...

simonc 39536 (5/9/2014)

---

WayneS is still absolutely correct about the usage of ROWS though.

In this instance you should use ROWS because it is the more correct solution for what you...

simonc 39536 (5/9/2014)

---

Thanks WayneS, read your article, I was looking for a good description of the difference between ROW and RANGE. Yes, most definitely ROW should be used here.

Interesting, so...

Stefan Krzywicki (5/8/2014)

---

Good article.

I'm not sure what you meant by this though

I found something new in SQL Server 2012. You can now add an order by to the over( partition...

Not sure if you completely read my article, but the solution you posted is what I replaced to speed up the update.

Thanks for your post.

Ben

I will have to take a closer look at your code. Thanks for posting it.

Ben

Thanks Chris for your post.

Ben

No I didn't try with sqlcmd. Honestly , I didn't think of that.

If you run all the lines in the question in a query window you will see you don't get an invalid object error. The table doesn't get dropped before...

I started off writing Cobol, then moved into Delphi (visual Pascal). I ended up with .net and sql server databases. Pretty sure I will be doing this until...

As long as we are dreaming here. It would be nice to have one of those new all electric Nissan Leaf cars. Then as long as I am...

Actually, Kevin was right. The existing spec only needed to solve one math operation. That is the column would contain either + or - or X or /

So...

Kevin,

I appreciate your post.

I hope the other posters will understand, I don't have issue with people commenting on how to improve code. As long as they understand...

You know, I find your comment offensive. I put time and effort into this article and this code. I had a problem to solve that required a function...

I would stay away from cursors if you decide to do it in t-sql. It might be better to use vb.net or c# and then use the clr. ...