Thanks for your reply it is just the kind of info im after.

Ive a few more questions about this design...

By catalogue do you mean working with the rdbms metadata...

Hi

Thats an interesting take.

My situation is that previously we used an Access databases with 1 table that had fields for 3 calls, the database was split in 2...

I think ive just found a snag to the previous code

Im on SQL Server 2000 and i read CTEs are not supported?

From what ive read also, my first example using...

Hello

Thanks for this alternative method also, i can think of 2 stored procedures that will benifit from it.

Theres so many ways to do the same thing once youve learnt...

Super. Grant do you know any books where i can learn about writing optimized code to help with these situations?

Hi Grant

I like your implementation, one question....

Can i have 2 fields as clustered indexes?

(Im using sql server 2000)

Regards

Gary