Static List with Dynamic Query

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)

Static List with Dynamic Query

Author

Topic

JamesT
Yak Posting Veteran

97 Posts

Posted - 2004-03-05 : 15:41:25

I have a table with the following:
Rank
UnitFamily
PointFamily

where the total rows = 50. It's a static list for a report that can change for all reports so I don't want to hard-code it. Goes against my religion.

I have another table where I can pull the following:

PersonName
Product

With a possible 10 - 20 values

I need to list out on a report the list of 50 items and then the 10 to 20 values. There is no relation between the two sets of data. I am getting products of both tables because there is no relation.

Any suggestions?

Thanks in advance.

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-05 : 16:03:38

What is the presentation layer technology for the report??