Viewing 5 posts - 1 through 5 (of 5 total)
Sergiy (6/19/2008)
Easy.You need what?
List of customers which have existing orders?
Just ask SQL Server for it!
select * from customer
WHERE EXISTS (select 1 from orders where orders.cust-number = customer.cust-number)
That's the ticket! ...
June 19, 2008 at 2:16 pm
I think you may be right... creating a temp table with the disctinct matches may be the best way. I was trying to get it in one statement and...
June 19, 2008 at 1:58 pm
See that's the thing. There's nothing in the orders file that I can limit to. I just want to know that there is at least one record in...
June 19, 2008 at 1:55 pm
Essentially, yes. However picture the customer table you refer to having 40 million records in it and thousands of potential matches on customer name. But perhaps this is...
June 19, 2008 at 1:45 pm
I'd kiss the two of you if I could. It would be awkward, but I'd do it none-the-less.
I'm never surprised to find out how little I know.
Thanks for your...
June 10, 2008 at 1:24 pm
Viewing 5 posts - 1 through 5 (of 5 total)