If their reaction is that childish, then where's the professionalism associated with publishing a website of this caliber? You can't be a pro and then react to every user...

Actually, that "old adage" has a rather seriously gaping hole in it - such that it renders ALL judgements invalid simply because everyone is imperfect. A total lack...

This is despicable - a QOTD where the supposedly correct answer is quite clearly incorrect, unless you happen to take an extraordinarily ODD interpretation of the question and assume that...

Yup, that's what I figured. I've done that myself any number of times, despite significant experience in a forum environment. You go to post and either...

How about using PIVOT?:

DECLARE @cust_product TABLE (cust varchar(10), prod varchar(10))

insert into @cust_product VALUES ('A','P')

insert into @cust_product VALUES ('A','Q')

insert into @cust_product VALUES ('A','P')

insert into @cust_product VALUES ('B','Q')

insert into @cust_product VALUES ('C','Q')

insert...

Like RoseAnn Rosanna-Danna says - NEVER MIND !!!!

I'm such a dope today. Take a good close look at the zeros just before the word AND. ...

I get the syntax error just from checking the query without even attempting to run it. I tried using ISNULL for each query, but that didn't change...

Okay, but are you really looking for RANDOM numbers, or are you seeking to generate the entire possible sequence of 5 digit numbers, in order, as your example suggests? ...

Well, I WAS going to suggest having a table of the first names to deal with that issue, but any example beyond the original sample data would break the idea,...

If by heirarchal you mean being able to use recursion, I'm pretty sure the answer is no. On the other hand, let me provide an example of what...

I suspect if you replace the word JOIN with a comma, that problem may go away.

On the LIKE operator, the expression 'abcde' LIKE '%b%' is TRUE, while the expression 'abcde'...

There's going to be a problem here. If there's no place to reference a date associated with the goods being received, you're in trouble, as TOP n queries...

Well... I just realized that your last example data breaks my query's sort mechanism, and also doesn't have the 2nd occurrence of 4 in the list show up in the...

Looks like an auxiliary table of numbers might do the trick, and I'm assuming that every possible value in the list for the Emp_cat field is numeric. Try...

INSERT statements that have a SELECT can't transform rows into columns, so the error you're getting is exactly what's wrong. Your SELECT statement that follows the INSERT statement...