Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Multi Result Set

Author  Topic 

mfemenel
Professor Frink

1421 Posts

Posted - 2001-08-21 : 09:58:42
Soliciting opinions for an easier way to do this than the jumble of code that's in my head. Let's say we have 4 sales agents,
a,b,c,d
I'd want a result set of
a,a a,b a,c a,d
b,a b,b b,c b,d
c,a c,b c,c c,d
d,a d,b d,c d,d

Sleep deprivation has made me punchy and I could use a push.

Mike
"A program is a device used to convert data into error messages."

Edited by - mfemenel on 08/21/2001 10:00:08
   

- Advertisement -