נפתר, תודה לארכיטקט :lol: :lol:
SELECT
LAG(year) OVER (partition by WorkingPlaceID,IsAWoman ORDER BY WorkingPlaceID, year) PreviousYear,
Year, ContactID ,WorkingPlaceID , IsAWoman,
LEAD(year) OVER (partition by WorkingPlaceID,IsAWoman ORDER BY WorkingPlaceID, year) NextYear
FROM ContactsWorkingPlaces
פורסם במקור בפורום CODE613 ב30/11/2014 15:01 (+02:00)