Yeah... but they wouldn't like my title for it... "Ready, Aim, Fire all Pork Chops!" 😀

lindaotero (10/27/2008)

---

Hi I have Windows XP professional version 2002 SP2

and when tryig to install sql 2005 "Standard" edition, all the options are gray ...(disable)... the oly one I can install...

Oh, my bad... low levels of Caffeine. You're correct, not a triangular join. Read too quickly. Sorry, Lynn.

Heh... everybody say it with me... "Without Order By, the order of columns...

Lynn Pettis (10/27/2008)

---

True, but when you script the create statement or edit the table in the designer in SSMS, the columns are listed in the order you defined them in...

Garadin (10/27/2008)

---

Fair enough. It was a pretty bold statement that may not be 100% accurate. It was in response to this:

Yes, that's all right, but if you make...

Isn't there a canned report you can get for the "top 10" longest queries just by right clicking on the database or server?

You have to plan on the unexpected... what happens if, someday, there's more than one operator? And what happens if you have to do a "bulk" insert of more...

smunson (10/27/2008)

---

Jeff,

Thanks for acknowledging. The only reason I chose to use a loop is because I just didn't have time to go look up the technique that selects...

The problem with even allowing such code to exist is that people will take any shortcut they can without regard to future performance. If they run across such code,...

You don't need to include TransDate in that... just wasted IO and clock cycles. 🙂

I've agreed...

Lynn Pettis (10/27/2008)

---

Jeff Moden (10/27/2008)

---

Man, would I like to be able to comment here on external articles so I don't have to sign up for every forum that has a...

Chris (10/27/2008)

---

Jeff...thkz for the response could plz clarify this....

so how should i consider it .....

select isnumeric(order_number+'.do') from tbl1..

is this the syntax...

i dont understand this query

SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')...

Thanks for the "cover". 🙂