item rate update query in MS sql server

-

 update ItemHeader set Rate=17 where ItemCode='33130';


 update ItemHeader set Rate="&D2&" where ItemCode='"&B2&"';




INSERT INTO [dbo].[ItemHeader] ([ItemCode] ,[ItemClassKey] ,[ItemName] ,[Rate] ,[ItemDiscount] ,[Barcode] ,[CrtnSize] ,[Ast]) VALUES ('"&&"' ,'CL08601' ,'"&&"' ,"&&" ,0 ,'"&&"' ,'S' ,1)


Insert into HRM.T_TEST1

   (COL1, COL2)

 Values

   ('50604', 'Dairy');

Comments

Post a Comment

Popular posts from this blog

Formula list

-
 SELECT ffm.formula_no, ffm.formula_desc1 formula_name, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') TYPE, msi.segment1 icode, ood.organization_code org, fmd.qty, fmd.detail_uom, DECODE (ffm.formula_status, 700, 'Active', 'New') status FROM apps.fm_matl_dtl fmd, apps.fm_form_mst ffm, apps.mtl_system_items_b msi, apps.org_organization_definitions ood WHERE fmd.formula_id = ffm.formula_id AND (fmd.inventory_item_id = msi.inventory_item_id(+) AND fmd.organization_id = msi.organization_id(+)) AND fmd.organization_id = ood.organization_id AND fmd.line_type=1 ORDER BY formula_no, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') DESC; SELECT ffm.formula_no, ffm.formula_desc1 formula_name, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') TYPE, msi.segment1 icode, ood.organization_code org, fmd.qty, fmd.detail_uom, DECODE (ffm.formula_status, 700, 'Active', 'New') status FROM apps.fm_matl_dtl fmd, apps.fm_
Read more

Formula Line change query

-
  SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='941306') AND RELEASE_TYPE='1' update FM_MATL_DTL set LINE_NO=3  WHERE FORMULALINE_ID='799366' and FORMULA_ID='66980' AND RELEASE_TYPE='1'; update FM_MATL_DTL set LINE_NO=1  WHERE FORMULALINE_ID='799367' and FORMULA_ID='66980' AND RELEASE_TYPE='1'; update FM_MATL_DTL set LINE_NO=2  WHERE FORMULALINE_ID='799366' and FORMULA_ID='66980' AND RELEASE_TYPE='1'; delete from FM_MATL_DTL where FORMULALINE_ID='785344' and FORMULA_ID='65865' AND RELEASE_TYPE='1'; update FM_MATL_DTL set LINE_NO=3  WHERE FORMULALINE_ID=(SELECT FORMULALINE_ID FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='866642') AND RELEASE_TYPE='1' AND LINE_NO='1') AND RELEASE_TYPE='1' AND LINE_NO='1'; update FM_MATL_DTL set LINE_NO=1  WHERE FO
Read more