Invent, Invent Fastighet och Anpassade sökningar

Geografiskt urval:

Select vsv.id, vsv.fastbet, bes.godkand, datediff(day,getdate(),inv.date) as DagarKvar, vsv.x,vsv.y from (select f_uuid, max(atgarddatum) as date from invent_utskick
where (typ = 'påminnelse' or typ = 'resultat') group by f_uuid) as inv
left join vsv on vsv.f_uuid = inv.f_uuid
left join invent_besiktning as bes on vsv.f_uuid = bes.f_uuid
where bes.godkand = 'Nej'

------------------------------------------------------------------------
Anpassad Sökning:

Select distinct vsv.id, vsv.fastbet as Fastighetsbeteckning, iif(bes.godkand = 'Nej', 'Underkänd','Saknas') as "Status", datediff(day,getdate(),inv.date) as "Dagar kvar", anv.DESCRIPTION as Handläggare
, vsv.x, vsv.y

from (select f_uuid, updsign, max(atgarddatum) as date from invent_utskick
where (typ = 'påminnelse' or typ = 'resultat') group by f_uuid, updsign) as inv

left join vsv on vsv.f_uuid = inv.f_uuid
left join invent_besiktning as bes on vsv.f_uuid = bes.f_uuid

left join anvandare as anv on anv.user_name = inv.updsign

where bes.godkand = 'Nej' or bes.godkand is null
order by "Dagar kvar" as

------------------------------------------------------------------------
Använda royalty free videos och bilder:
Strand med snäckskall - Engin Akyurt

------------------------------------------------------------------------

0:00 Intro
1:53 Invent
25:11 Invent Fastighet
40:42 Geografiskt urval
52:30 Anpassad sökning