| RESULTSET |
| query |
| |
BESTANDOR |
BESTCASH |
BESTCOST |
BESTRATE |
BESTTIME |
CASHTOTAL |
DTISTOPDATE |
LNGMODELYEAR |
LNGSPECIALCASH |
LNGTOTALCASH |
LNGTYPE |
PK_AUTSFINCENTIVEID |
PK_AUTSFINCENTIVESPECIALID |
TOTALREBATEOPPORTUNITY |
TXTMAKE |
TXTMODEL |
TXTSPECIALBODY |
TXTSPECIALQUALIFY |
TXTSPECIALRESTRICTIONS |
TXTSPECIALTITLE |
TXTVEHICLEHINTS |
TXTVEHICLEHINTSFOREXCLUSION |
| 1 |
and
|
0
|
28.60
|
1.90
|
36
|
3000
|
2026-11-22 00:00:00.0
|
2027
|
500
|
3000.00
|
2
|
10451
|
86061385
|
5000.00
|
Nissan
|
Rogue DARK ARMOR AWD
|
Proof of current enrollment in an accredited U.S. college, university, or graduate school with proof of graduation within the past 24 months, or written confirmation of upcoming graduation within the next 6 months, required. Cash offer is available towards the purchase or lease of an eligible vehicle from new dealer stock. Subject to residency restrictions. Cannot be combined with the Nissan Military Program offer or other VPP offers. Limit one vehicle purchase per qualified participant. Other restrictions apply. Contact dealer for details. Offer is subject to change or termination at any time without notice.
|
[empty string]
|
[empty string]
|
Nissan Conditional Offer - College Graduate Discount
|
{MODEL:Rogue,TRIM:DARK ARMOR,MODEL_CODE:22617}
|
[empty string]
|
| 2 |
and
|
0
|
28.60
|
1.90
|
36
|
3000
|
2026-11-22 00:00:00.0
|
2027
|
500
|
3000.00
|
2
|
10451
|
86061386
|
5000.00
|
Nissan
|
Rogue DARK ARMOR AWD
|
Available to the following individuals with proof of eligibility: U.S. residents with a valid U.S. driver's license who are: (i) current U.S. Active and Reserve Military personnel, (ii) Honorably discharged U.S. Military Veterans, (iii) U.S. military Gold Star Familiies who provides dealer with a photocopy of DD-214, DD-1300, Summary of Benefits letter, or death certificate. Cash offer is available towards the purchase or lease of an eligible vehicle from new dealer stock. View Military Cash Program Offers link for list of current eligible vehicles. Subject to residency restrictions. Cannot be combined with the Nissan College Grad Program or the Nissan Business Associate Program. Limit up to 2 vehicle leases or purchases per calendar year per qualified participant for personal use only. Offer not valid for fleet or business use. Other restrictions may apply. Contact dealer for details. Offer is subject to change or termination at any time without notice.
|
[empty string]
|
[empty string]
|
Nissan Conditional Offer - Military Appreciation
|
{MODEL:Rogue,TRIM:DARK ARMOR,MODEL_CODE:22617}
|
[empty string]
|
| 3 |
and
|
0
|
28.60
|
1.90
|
36
|
3000
|
2026-11-22 00:00:00.0
|
2027
|
1000
|
3000.00
|
2
|
10451
|
86061387
|
5000.00
|
Nissan
|
Rogue DARK ARMOR AWD
|
Any current Nissan LEAF or Nissan ARIYA owner or lessee will be given Customer Loyalty offer towards the Purchase or Lease of an eligible model.Offer is transferable within the same household, and the person must provide proof of residency within the same household. It is non-transferable to other family members or friends outside the household. Offer requires NMAC new vehicle financing or leasing, credit approval is required. Limit one offer per vehicle.
|
[empty string]
|
[empty string]
|
Nissan Returning EV NMAC Loyalty
|
{MODEL:Rogue,TRIM:DARK ARMOR,MODEL_CODE:22617}
|
[empty string]
|
|
| SQL |
SELECT tblSFIncentives.PK_autSFIncentiveID,
tblSFIncentives.txtMake,
tblSFIncentives.txtModel,
tblSFIncentives.lngModelYear,
tblSFIncentives.lngTotalCash,
tblSFIncentives.txtVehicleHints,
tblSFIncentives.txtVehicleHintsForExclusion,
tblSFIncentives.dtiStopDate,
tblSFIncentiveSpecials.PK_autSFIncentiveSpecialID,
tblSFIncentiveSpecials.txtSpecialTitle,
tblSFIncentiveSpecials.lngSpecialCash,
tblSFIncentiveSpecials.txtSpecialBody,
tblSFIncentiveSpecials.txtSpecialQualify,
tblSFIncentiveSpecials.txtSpecialRestrictions,
tblSFIncentiveSpecials.lngType,
tblSFIncentives.lngTotalCash +
(SELECT SUM(S2.lngSpecialCash)
FROM tblSFIncentiveSpecials S2
WHERE S2.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND S2.ysnActive = 1
AND S2.lngType = 2) AS TotalRebateOpportunity,
(SELECT SUM(Cash.lngCash)
FROM tblSFIncentiveCash Cash
WHERE Cash.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND Cash.ysnActive = 1) AS CashTotal,
BestAPR.lngTime AS BestTime,
BestAPR.txtValue AS BestRate,
BestAPR.lngCash AS BestCash,
BestAPR.txtAndOR AS BestAndOr,
BestAPR.lngCostPer1000 AS BestCost
FROM tblSFIncentives
LEFT JOIN tblSFIncentiveSpecials
ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveSpecials.FK_lngSFIncentiveID
AND tblSFIncentiveSpecials.ysnActive = 1
AND tblSFIncentiveSpecials.lngType = 2
LEFT JOIN tblSFIncentiveCodeLink
ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveCodeLink.FK_lngSFIncentiveID
AND tblSFIncentiveCodeLink.txtStyleID = '0'
OUTER APPLY (
SELECT TOP 1 tblSFIncentiveAPRs.lngTime,
tblSFIncentiveAPRs.txtValue,
tblSFIncentiveAPRs.lngCash,
tblSFIncentiveAPRs.txtAndOr,
tblSFIncentiveAPRs.lngCostPer1000
FROM tblSFIncentiveAPRs
WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND tblSFIncentiveAPRs.ysnActive = 1
ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC
) AS BestAPR
WHERE tblSFIncentives.lngModelYear = '2027'
AND tblSFIncentives.txtMake = 'Nissan'
-- AND tblSFIncentives.FK_lngDealerID = '4'
AND (
tblSFIncentiveCodeLink.txtStyleID IS NOT NULL
OR
tblSFIncentives.txtModel = 'Rogue'
OR (
(tblSFIncentives.txtVehicleHints LIKE '%MODEL:Rogue[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL:%')
AND (
tblSFIncentives.txtVehicleHints LIKE '%MODEL_CODE:22617[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL_CODE:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%MODEL_CODE:22617[,}]%'
)
)
AND (
tblSFIncentives.txtVehicleHints LIKE '%TRIM:Dark Armor[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:Dark Armor[,}]%'
)
)
)
)
AND tblSFIncentives.ysnActive = 1
AND tblSFIncentives.dtiStopDate >= Convert(DateTime, Floor(Convert(Float, getdate())))
ORDER BY tblSFIncentives.txtMake, tblSFIncentives.lngModelYear DESC, tblSFIncentives.txtModel |