Teach someone to fish... please see the following URL for how...

Ummm... why, Grant? They BOTH appear in the >= <= form after the optimizer evaluates them....

Aren't you forgetting something in that temp table?

Cool. Thanks for the feedback.

If you ever need to make one...

Although it has worked very well in the present and in the past, I wonder if folks understand that Updating an alias is actually an undocumented feature? 😉

sql-oholic (10/2/2008)

---

Hi,

I am trying to get # of rows for a table.

I used sp_spaceused, through which I get a number which is different compared to number I get when I...

Paul, is that correct? The date format is dd/mm/yyyy?

Rich96 (10/2/2008)

---

Fortunately the records will always be in sequential order based on the key column. I verified with the programmer that same question you had and it will never...

Sure... but let me ask a question... what does "Duration" contain? It can't be the number of months because there's actually only 3 months between the two dates given.

zypsy (10/4/2008)

---

each row is for an item, and not for an order. so if a customer purchases 3 items in a single order, there are 3 separate rows in the...

Heh... I often ask that question to find out what the...

Heh... define "performance". Are you talking speed of code, speed of developing code, speed of testing code, computational ROI, ease of maintenance, ease of use, ease of interface, cost...

Anirban Paul (10/4/2008)

---

Did you wrote smart code in Day 1? I believe practice, knowledge and experience makes one smart developer. It may be smart developer but not genius like you....

Heh... 2/30/... that's a good one.

Like Dugi said, it would be helpful if we had more information. If you want a really good answer, read and heed the article...

Want a better answer faster? Take a look at the link in my signature below and also post the query you already have. 😉