Skip to content

Instantly share code, notes, and snippets.

@nickmartini
Created October 27, 2009 17:05
Show Gist options
  • Select an option

  • Save nickmartini/219732 to your computer and use it in GitHub Desktop.

Select an option

Save nickmartini/219732 to your computer and use it in GitHub Desktop.
update product set prsdesc = 'HY-60BBR' where prrfnbr = 1647883 or prprfnbr = 1647883
go
update product set prnbr = 'HY-16271713050021NAJ60042', prldesc2 = 'YA-60BBR060', prldesc3 = 'YA-60BBR/06.00' where prrfnbr = 1647900
go
update product set prnbr = 'HY-16341713050021NAJ60076', prldesc2 = 'YA-60BBR065', prldesc3 = 'YA-60BBR/06.50' where prrfnbr = 1647901
go
update product set prnbr = 'HY-16411713050021NAJ600C1', prldesc2 = 'YA-60BBR070', prldesc3 = 'YA-60BBR/07.00' where prrfnbr = 1647902
go
update product set prnbr = 'HY-16581713060021NAJ600F7', prldesc2 = 'YA-60BBR075', prldesc3 = 'YA-60BBR/07.50' where prrfnbr = 1647903
go
update product set prnbr = 'HY-16651713060021NAJ600K5', prldesc2 = 'YA-60BBR080', prldesc3 = 'YA-60BBR/08.00' where prrfnbr = 1647904
go
update product set prnbr = 'HY-16721713050021NAJ600L2', prldesc2 = 'YA-60BBR085', prldesc3 = 'YA-60BBR/08.50' where prrfnbr = 1647905
go
update product set prnbr = 'HY-16891713050021NAJ600Q5', prldesc2 = 'YA-60BBR090', prldesc3 = 'YA-60BBR/09.00' where prrfnbr = 1647906
go
update product set prnbr = 'HY-16961713050021NAJ600V3', prldesc2 = 'YA-60BBR095', prldesc3 = 'YA-60BBR/09.50' where prrfnbr = 1647907
go
update product set prnbr = 'HY-17021713050021NAJ600Z5', prldesc2 = 'YA-60BBR100', prldesc3 = 'YA-60BBR/10.00' where prrfnbr = 1647908
go
update product set prnbr = 'HY-17191713050021NAJ60131', prldesc2 = 'YA-60BBR105', prldesc3 = 'YA-60BBR/10.50' where prrfnbr = 1647909
go
update product set prnbr = 'HY-17261713050021NAJ602D4', prldesc2 = 'YA-60BBR110', prldesc3 = 'YA-60BBR/11.00' where prrfnbr = 1647910
go
update product set prnbr = 'HY-17331713050021NAJ602H2', prldesc2 = 'YA-60BBR115', prldesc3 = 'YA-60BBR/11.50' where prrfnbr = 1647911
go
update product set prnbr = 'HY-17401713050021NAJ602L1', prldesc2 = 'YA-60BBR120', prldesc3 = 'YA-60BBR/12.00' where prrfnbr = 1647912
go
update product set prnbr = 'HY-17571713050021NAJ602T2', prldesc2 = 'YA-60BBR125', prldesc3 = 'YA-60BBR/12.50' where prrfnbr = 1647913
go
update product set prnbr = 'HY-17641713050021NAJ602X7', prldesc2 = 'YA-60BBR130', prldesc3 = 'YA-60BBR/13.00' where prrfnbr = 1647914
go
update product set prnbr = 'HY-17711713050021NAJ60316', prldesc2 = 'YA-60BBR135', prldesc3 = 'YA-60BBR/13.50' where prrfnbr = 1647915
go
update product set prnbr = 'HY-17881712110021NAIZ0045', prldesc2 = 'YA-60BBR140', prldesc3 = 'YA-60BBR/14.00' where prrfnbr = 1647916
go
update product set prnbr = 'HY-17951712110021NAIZ00C2', prldesc2 = 'YA-60BBR145', prldesc3 = 'YA-60BBR/14.50' where prrfnbr = 1647917
go
update product set prnbr = 'HY-18011712110021NAIZ00F6', prldesc2 = 'YA-60BBR150', prldesc3 = 'YA-60BBR/15.00' where prrfnbr = 1647918
go
update product set prnbr = 'HY-18181712110021NAIZ00U5', prldesc2 = 'YA-60BBR155', prldesc3 = 'YA-60BBR/15.50' where prrfnbr = 1647919
go
update product set prnbr = 'HY-18251712110021NAIZ0127', prldesc2 = 'YA-60BBR160', prldesc3 = 'YA-60BBR/16.00' where prrfnbr = 1647920
go
update product set prnbr = 'HY-18321712110021NAIZ0195', prldesc2 = 'YA-60BBR165', prldesc3 = 'YA-60BBR/16.50' where prrfnbr = 1647921
go
update product set prnbr = 'HY-18491712110021NAIZ01D6', prldesc2 = 'YA-60BBR170', prldesc3 = 'YA-60BBR/17.00' where prrfnbr = 1647922
go
update product set prnbr = 'HY-18561712110021NAIZ01U2', prldesc2 = 'YA-60BBR175', prldesc3 = 'YA-60BBR/17.50' where prrfnbr = 1647923
go
update product set prnbr = 'HY-18631712110021NAIZ0212', prldesc2 = 'YA-60BBR180', prldesc3 = 'YA-60BBR/18.00' where prrfnbr = 1647924
go
update product set prnbr = 'HY-18701712110021NAIZ02A4', prldesc2 = 'YA-60BBR185', prldesc3 = 'YA-60BBR/18.50' where prrfnbr = 1647925
go
update product set prnbr = 'HY-18871712110021NAIZ02I4', prldesc2 = 'YA-60BBR190', prldesc3 = 'YA-60BBR/19.00' where prrfnbr = 1647926
go
update product set prnbr = 'HY-18941712110021NAIZ0313', prldesc2 = 'YA-60BBR195', prldesc3 = 'YA-60BBR/19.50' where prrfnbr = 1647927
go
update product set prnbr = 'HY-19001712110021NAIZ0378', prldesc2 = 'YA-60BBR200', prldesc3 = 'YA-60BBR/20.00' where prrfnbr = 1647928
go
update product set prnbr = 'HY-19171712110021NAIZ03P6', prldesc2 = 'YA-60BBR205', prldesc3 = 'YA-60BBR/20.50' where prrfnbr = 1647929
go
update product set prnbr = 'HY-19241712110021NAIZ04B8', prldesc2 = 'YA-60BBR210', prldesc3 = 'YA-60BBR/21.00' where prrfnbr = 1647930
go
update product set prnbr = 'HY-19311712110021NAIZ04K2', prldesc2 = 'YA-60BBR215', prldesc3 = 'YA-60BBR/21.50' where prrfnbr = 1647931
go
update product set prnbr = 'HY-19481712110021NAIZ04X4', prldesc2 = 'YA-60BBR220', prldesc3 = 'YA-60BBR/22.00' where prrfnbr = 1647932
go
update product set prnbr = 'HY-19551712110021NAIZ0596', prldesc2 = 'YA-60BBR225', prldesc3 = 'YA-60BBR/22.50' where prrfnbr = 1647933
go
update product set prnbr = 'HY-19621712110021NAIZ05U1', prldesc2 = 'YA-60BBR230', prldesc3 = 'YA-60BBR/23.00' where prrfnbr = 1647934
go
update product set prnbr = 'HY-19791712110021NAIZ0672', prldesc2 = 'YA-60BBR235', prldesc3 = 'YA-60BBR/23.50' where prrfnbr = 1647935
go
update product set prnbr = 'HY-19861712110021NAIZ06D1', prldesc2 = 'YA-60BBR240', prldesc3 = 'YA-60BBR/24.00' where prrfnbr = 1647936
go
update product set prnbr = 'HY-19931712110021NAIZ0718', prldesc2 = 'YA-60BBR245', prldesc3 = 'YA-60BBR/24.50' where prrfnbr = 1647937
go
update product set prnbr = 'HY-20061712110021NAIZ0796', prldesc2 = 'YA-60BBR250', prldesc3 = 'YA-60BBR/25.00' where prrfnbr = 1647938
go
update product set prnbr = 'HY-20131712110021NAIZ07C6', prldesc2 = 'YA-60BBR255', prldesc3 = 'YA-60BBR/25.50' where prrfnbr = 1647939
go
update product set prnbr = 'HY-20201712110021NAIZ07N1', prldesc2 = 'YA-60BBR260', prldesc3 = 'YA-60BBR/26.00' where prrfnbr = 1647940
go
update product set prnbr = 'HY-20371712110021NAIZ07T7', prldesc2 = 'YA-60BBR265', prldesc3 = 'YA-60BBR/26.50' where prrfnbr = 1647941
go
update product set prnbr = 'HY-20441712110021NAIZ0853', prldesc2 = 'YA-60BBR270', prldesc3 = 'YA-60BBR/27.00' where prrfnbr = 1647942
go
update product set prnbr = 'HY-20511712110021NAIZ08E1', prldesc2 = 'YA-60BBR275', prldesc3 = 'YA-60BBR/27.50' where prrfnbr = 1647943
go
update product set prnbr = 'HY-20681713050021NAJ605N2', prldesc2 = 'YA-60BBR280', prldesc3 = 'YA-60BBR/28.00' where prrfnbr = 1647944
go
update product set prnbr = 'HY-20751713050021NAJ605S7', prldesc2 = 'YA-60BBR285', prldesc3 = 'YA-60BBR/28.50' where prrfnbr = 1647945
go
update product set prnbr = 'HY-20821713050021NAJ605Z4', prldesc2 = 'YA-60BBR290', prldesc3 = 'YA-60BBR/29.00' where prrfnbr = 1647946
go
update product set prnbr = 'HY-20991713050021NAJ60631', prldesc2 = 'YA-60BBR295', prldesc3 = 'YA-60BBR/29.50' where prrfnbr = 1647947
go
update product set prnbr = 'HY-21051713050021NAJ60661', prldesc2 = 'YA-60BBR300', prldesc3 = 'YA-60BBR/30.00' where prrfnbr = 1647948
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment