How about the following?

BEGIN TO COMMIT

WHEN RECEIVE DUMP

THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...

especially when I considered how RELATIONAL it is :w00t::D:P:hehe:

Steve

(aka smunson)

:D:D:D

I hear you Lynn... I just think we're clashing on a difference of either specific values or perspective. My values say that if I were going to...

While I understand your point, why diminish the value of SSC by allowing something like QOTD to go so far off kilter? Perhaps it's time to consider making...

majorbloodnock (6/25/2008)

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've...

A.) No judgement was made, was just posing a question.

B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why...

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...