Created
October 3, 2014 17:49
-
-
Save swaters86/92652272804886465472 to your computer and use it in GitHub Desktop.
This script will update the last modified and created date-time values in the artikkler_status table for stories so PBS tags using a created or last modified sorting parameter will sort the articles correctly.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| update aa | |
| set aa.Sist_endret = cast(aa.dato as datetime), | |
| aa.Opprettet = cast(aa.dato as datetime) | |
| */ | |
| select count (*) | |
| from web.dbo.Artikkler_hode aa | |
| left join web.dbo.Artikkler_status (nolock) bb | |
| on (bb.Avis =aa.Avis and bb.Dato=aa.Dato and bb.Kategori=aa.Kategori and bb.Lopenr=aa.Lopenr) | |
| where bb.Avis='WC' and bb.CreatedBy='mfxfeeder' and convert(varchar(8), aa.Opprettet, 112) > aa.dato | |
| and aa.Dato <> '99999999' | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment