Interesting - I always thought that when creating a procedure with parameters, that all of the parameters were to be in a set of parenthesis. I...

CONVERT(nchar(23), <FieldToConvert>)

I would also suggest not having spaces in table/column names. Personally, I prefer where each word starts with a capital letter, ie. SoldItems.

Jack,

It sounds like the doctor's are really on top of this, and that in time Evan will be 100%. I'm very sorry that he had this accident, and that you...

Isn't this the truth. Parents tend to be OMG and all stressed out - kids...

See the edit I made in the query.

I would have to agree with Pam... what's the purpose of this? It would be simpler to just run the one query.

1. Tables are usually plural, ie. Sales, Products, Customers, Employees, etc. (they're not holding just one record, are they?)

2. In your deliveries, you have a SalesRecieptNum field. Is this the...

Jack Corbett (11/5/2010)

---

Diagnosis is in. Displaced fracture about 2 inches below the elbow which requires surgery to be set properly. Local ortho doesn't do kids (which makes me...

Janie.Carlisle (11/5/2010)

---

Hi. I wrote a query to select the Top25 records from my dataset. I now want to write another query to select the records that are NOT in that...

Keep in mind that you won't be able to update this view. Since it seems like your issue is with the number of rows being printed on a report, then...

Roy Ernest (11/5/2010)

---

Ah Crap and double crap. Hurricane Tomas is threatening again. It is turning to the east and the tail is once again coming over the island. Why cant...

gbd77rc (11/5/2010)

---

Hi All,

After some more digging around I have isolated it to the fact when the database was originally created they had mix collations in the table creation scripts (these...

If you need help in understanding the APPLY operator, check out that link in my signature. (That article links to another - both are excellent for understanding APPLY.)

CirquedeSQLeil (11/5/2010)

---

jcrawf02 (11/5/2010)

---

By the way, thanks Jason for the link and Steve for the presentation last night, I had to drop off about 7:40 your time but enjoyed what I...

Thanks a bunch guys! Grant, I'm real interested in looking at that book when it's out.