select #Variables.UserIDColumn# as UserID
from #Variables.TableName#
where #Variables.CookieIDColumn# =
and
#Variables.CookieIDColumn# not like 'CASAUTH-%' and
#Variables.TimestampColumn# >
select #Variables.TimestampColumn# from #Variables.TableName#
where #Variables.CookieIDColumn# =
update #Variables.TableName#
set #Variables.UserIDColumn# =
,
#Variables.TimestampColumn# =
where #Variables.CookieIDColumn# =
insert into #Variables.TableName# (
#Variables.CookieIDColumn#, #Variables.UserIDColumn#, #Variables.TimestampColumn#
)
values (
,
,
)
delete from #Variables.TableName#
where #Variables.CookieIDColumn# =
select #Variables.TimestampColumn# as LastCleaned
from #Variables.TableName#
where #Variables.CookieIDColumn# = 'CASAUTH-LASTCLEANED'
delete from #Variables.TableName#
where #Variables.TimestampColumn# <=
insert into #Variables.TableName# (#Variables.UserIDColumn#, #Variables.CookieIDColumn#,
#Variables.TimestampColumn#)
values ('00000000', 'CASAUTH-LASTCLEANED',
);