Skip to content

Instantly share code, notes, and snippets.

@npero

npero/NOVAASP-129

Created July 20, 2012 14:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save npero/3151156 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save npero/3151156 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
NOVAASP-129
update tguseat set isprimary = '0', lastupdate = 77 where (iddosdossier, iddicseat) in (
select iddosdossier, min(iddicseat) from tguseat where isprimary = 1 and validto is null
and iddosdossier in (416208,416435,429129,429328,431882,431946,435762,436370,438104,439762,440051,440224,441330,442601,447591) group by iddosdossier
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment