
October 15th, 2004, 03:33 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Resolved
Quote: | Originally Posted by slowhand73
I'm using ASP and SQL Serv 2000. What I need to get from 2 tables (company & customers) is random 10 customers from random 20 comp.
Anyone got an idea how to do this??? I've spent 2 days trying to get stored proc. or T-SQL to work, but nothing good came out of it. I can get 1 comp and 10 cust, but not a grouped list of 20 comp. w/ 10 cust. each.
Help is greatly appreciated. |
Stupid me...
CREATE PROCEDURE ...
...
AS
set nocount on
CREATE TABLE #tempComp
...
...
...
SET NOCOUNT OFF
GO
|