thanks Cadavre,

note taken on guidelines for posting 🙂

Very new to SQL and never used the APPLY operator. So learning hard and fast, or least trying to. Only one other thing is the user input will be by parameter used in reporting services, will your solution change with this added detail?

thanks for quick response