Viewing 15 posts - 14,596 through 14,610 (of 14,953 total)
The usual solution to that problem is to put "is not null" statements in the Where clause of the query, if I'm understanding your question correctly.
March 12, 2008 at 10:45 am
Grant Fritchey (3/12/2008)
Evidently, geeks with weapons!:w00t:
I built a crossbow when I was in high school. Darn thing can shoot a bolt through a 4 inch thick pine tree.
March 12, 2008 at 9:20 am
Resume
Goals: Have enough money to pay for my various RPG habits and new ones I plan to pick up (Age of Conan!), with some left over for vital necessities like...
March 12, 2008 at 9:18 am
I think you'll have to build something on your own for this. Your rules of "what is similar sounding" might be different than someone else's.
For example, would "rsmith@hotmail.com" be...
March 12, 2008 at 9:06 am
rajendran.e (3/11/2008)
Please give me idea about basic knowledge for DBA
Get a good book on the subject at your local bookstore, Amazon, the library, whatever.
THE basic datum about being a DBA...
March 12, 2008 at 8:53 am
Another consideration on using Output clauses is that they work on update and delete as well.
With delete, you can't scan the table for the rows you just deleted, for relatively...
March 12, 2008 at 8:40 am
Run "select @@version" on both servers. See if they are running different versions. That's where I'd start my check on this.
March 12, 2008 at 7:39 am
Roberta (or is it Robert A?):
One thing I've found very useful over the years is to create a testing grounds database. I call mine ProofOfConcept.
He's something you can do...
March 12, 2008 at 7:33 am
kevriley (3/12/2008)
Derek Dongray (3/12/2008)
PS: I assume everyone agrees that multiply and divide are the same precedence so haven't included division.
Strictly speaking multiplication and division don't have the same precedence, it...
March 12, 2008 at 7:09 am
ScottPletcher (3/11/2008)
why does it make more sense for the birthday to be after their birthday than it does to have it be before?
Because then the exact same check that...
March 11, 2008 at 3:24 pm
robertafricker (3/11/2008)
Thank you for your input. I am currently working with a tutor on the finer points before I go fo certification.
She and I were discussing this very...
March 11, 2008 at 3:12 pm
The reason for the nulls is probably that you don't have any matching rows for your Where clause.
March 11, 2008 at 11:11 am
zubamark (3/7/2008)
USE NorthwindSELECT ProductName FROM Products WHERE CategoryID IN
(SELECT distinct CategoryID
FROM Categories Where CategoryName = 'Beverages')
1. Products table doesnot have CategoryName
2. Always put distinct in subquery.
NO!! Distinct in...
March 11, 2008 at 11:06 am
Add a "Where is not null" to the where clause.
Example: "and c.address1 is not null"
Your best bet, since it looks like the nulls are coming from the table with the...
March 11, 2008 at 8:43 am
Just to add to Lynn's answer: The maximum number of rows is purely a limitation of disk space available.
March 11, 2008 at 8:36 am
Viewing 15 posts - 14,596 through 14,610 (of 14,953 total)