Jeff Moden (5/31/2010)

---

Well I'll be dipped. I guess I'm glad I didn't think of the "Difference between two row numbers" trick here. Without changing the number of rows...

This post is just to include an alternate method. I haven't tested the various methods, but I believe that the "Quirky Update" solution that Jeff presented will probably be the...

To anyone that has ever served in any branch of the military, I say:

Thank you for your sacrifice and service!

I also thank your family for their sacrifice.

ColdCoffee (5/28/2010)

---

A slight modification on WayneS' code is producing exact simliar test timings as mine

...

@Wayne Shef, mate, am not as experienced or as agile or as smart as u are...

Thanks Wayne,

Your solution fits the bill till ZZZZ. I think...

In your script task, did you set the variable to be read/write?

David_W1234 (5/28/2010)

---

Thanks a lot hester84!! It works!!

However, if I would like it to show the number of max concurrent users per day for a month of April, how can...

A cursor is bad. A while loop...

itlk (5/28/2010)

---

Hi,

In a situation when I want the record to be Inserted if it is new and to be Updated if it is existing is it better to:

1/ try the...

GilaMonster (5/28/2010)

---

It was. I did the exchange rate calc in my head and...

And then...

Not really.

Something to note: log shipping leaves the backup server in a read-only state. And if not set...

Do you have a link to that other thread? I couldn't find it... 🙁

Lynn Pettis (5/28/2010)

---

Here is a good blog post (if I do say so myself) regarding performance between inline code, inline TVF's, and scalar functions:

Comparing Hardcoded functions, In-Line TVF's, and Scalar...

GilaMonster (5/28/2010)

---

Lynn Pettis (5/27/2010)

---

GilaMonster (5/27/2010)

---

More free consulting? http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx

Anyone keen and free?

I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look...