Hi,
Here's a very simplified version of a view (named History):
SELECT Id, Date,
FROM dbo.SCHeaders
UNION
Select Id, Date
FROM dbo.Allocations
UNION
SELECT Id, Date
FROM dbo.Detail
The view will always be used with a specific ID e.g :
SELECT * FROM History WHERE ID='Fred'
In this scenario there will always be only one record retrieved from the SCHeaders table.
I need to exclude any records with a date that is earlier than that of the SCHeaders record from the result.
FWIW this only need apply to the Detail table - there will be no such records in the Allocations table.
A Sproc could be used if it is preferable....
TIA