Skip to content

Instantly share code, notes, and snippets.

@swaters86
Created October 1, 2014 15:51
Show Gist options
  • Save swaters86/0332dd4edfa1e9b64a19 to your computer and use it in GitHub Desktop.
Save swaters86/0332dd4edfa1e9b64a19 to your computer and use it in GitHub Desktop.
/*
============ Start 3 ===================
truncate table shared.dbo.cachestorage_mn1_LA
update shared.dbo.CacheStorage_MN1_LA_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_mn1_LB
update shared.dbo.CacheStorage_MN1_LB_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_mn1_LC
update shared.dbo.CacheStorage_MN1_LC_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
============ End 3 ===================
============ Start 3 ===================
truncate table shared.dbo.cachestorage_mn1_LD
update shared.dbo.CacheStorage_MN1_LD_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LD has been recached'
truncate table shared.dbo.cachestorage_mn1_LE
update shared.dbo.CacheStorage_MN1_LE_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LE has been recached'
truncate table shared.dbo.cachestorage_mn1_LF
update shared.dbo.CacheStorage_MN1_LF_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LF has been recached'
============ End 3 ===================
============ Start 3 ===================
truncate table shared.dbo.cachestorage_mn1_LG
update shared.dbo.CacheStorage_MN1_LG_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LG has been recached'
truncate table shared.dbo.cachestorage_mn1_LH
update shared.dbo.CacheStorage_MN1_LH_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LH has been recached'
truncate table shared.dbo.cachestorage_mn1_LI
update shared.dbo.CacheStorage_MN1_LI_permanent
set [Timestamp] = DATEADD(d, -30, getdate())
print 'LI has been reached'
============ End 3 ===================
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment