История страницы

select TOP 1 
    fp.Code as FoodPaymentStatus,
    mk.FoodPaymentDate,
    mk.DateOpen,
    mk.FirstGestationalAge,
    DATEADD(DAY, 279 - (FirstGestationalAge*7), mk.DateOpen) as [PlannedBirthDate]
from hlt_mkp_Card mk WITH(NOLOCK)
JOIN hlt_atc_MilkFoodPayment fp WITH(NOLOCK) on mk.rf_atc_MilkFoodPaymentID = fp.atc_MilkFoodPaymentID
WHERE 1 = 1 
AND mk.rf_MKABGUIDDateClose in> GETDATE(@0)
AND fpmk.Coderf_MKABGUID = '1'in (@0)

SELECT TOP 1
  mkab.DATE_BD as [Birthday],
  mft.Code as [FoodTypeCode],
  mft.Name as [FoodTypeName],
  mfp.Code as [FoodPaymentCode],
  mkab.FoodPaymentDate as [FoodPaymentDate]
FROM hlt_MKAB mkab WITH(NOLOCK)
JOIN hlt_atc_MilkFoodPayment mfp WITH(NOLOCK) on mkab.rf_atc_MilkFoodPaymentID = mfp.atc_MilkFoodPaymentID
JOIN hlt_atc_MilkFoodType mft WITH(NOLOCK) on mkab.rf_atc_MilkFoodTypeID = mft.atc_MilkFoodTypeID
WHERE 1=1
AND mkab.FoodPaymentDate != '1900-01-01T00:00:00.000'
AND mkab.UGUID in (@0)