I'm thinking the same thing. When you shell out, are you giving it the full path and filename to the executable? If not, then you're probably executing the...

It looks like you want to get the number of rows in @num for each range defined in @range. To accomplish this, I'm going to change the structure of...

Distract

Luis Cazares (6/6/2014)

---

djj (6/6/2014)

---

Luis Cazares (6/6/2014)

That's why I consider zip codes, phone numbers, credit card numbers & others should be stored on string type columns. You could enforce to use...

David Burrows (6/6/2014)

---

Stefan Krzywicki (6/6/2014)

---

I don't know who to contact since Steve is on vacation, but I got the daily newsletter this morning and clicked on the link for "Is...

Koen Verbeeck (6/6/2014)

---

Ed Wagner (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

I think I have finally met the "exception on the rule" for SELECT *.

Select on an Oracle view with all the of the columns...

I learned something new today as well. Thanks and everyone have a great weekend.

Koen Verbeeck (6/6/2014)

---

I think I have finally met the "exception on the rule" for SELECT *.

Select on an Oracle view with all the of the columns in the SELECT clause:...

Yes, I've also learned that there are 7 continents. BTW, Luis, I appreciate that you didn't use AS as your alias in your query. That would have been...

Grant Fritchey (6/5/2014)

---

Sean Lange (6/5/2014)

---

I am just going to leave this here...

http://www.sqlusa.com/bestpractices/%5B/url%5D

Don't worry there is soap for your eyes. Then if you read some of the content you may want...

Walk (through the woods to the next station)

TomThomson (6/5/2014)

---

Having worked both in India with Indians and in American with Americans, I have to sort of agree with him - but his comparisons take it much too...

Sporting Clays

Sean Lange (6/5/2014)

---

OK all this nonsense about how painful NOLOCK can be has prompted me to write this again. I know I have posted this on this site a few...

SQLRNNR (6/5/2014)

---

TomThomson (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem,...