Home Forums Programming General Query to get first number RE: Query to get first number
NPeeters
SSChampion
Points: 12358
More actions
August 29, 2003 at 4:21 am
#471949
Try this...
SELECT ISNULL(min(BudgetId), ISNULL((SELECT max(BudgetId) + 2 FROM tblBudgetYear), 2) - 1 FROM tblBudgetYear t1 WHERE NOT EXISTS (SELECT 1 FROM tblBudgetYear t2 WHERE t2.BudgetId = t1.BudgetId - 1) AND t1.BudgetId > 1