website log - INSERT INTO PL_Updated ( Model, QTYTL, SEP,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: INSERT INTO PL_Updated ( Model, QTYTL, SEP, OCT, NOV, [DEC], JAN, FEB, MAR, APR, MAY, JUN ) SELECT [PL_data Transform from Japan Website].[ITEM NAME], IIf(IsNull([PL_data Transform from Japan Website]!Sep),0,[PL_data Transform from Japan Website]!Sep)+IIf(IsNull([PL_data Transform from Japan Website]!Oct),0,[PL_data Transform from Japan Website]!Oct)+IIf(IsNull([PL_data Transform from Japan Website]!Nov),0,[PL_data Transform from Japan Website]!Nov)+IIf(IsNull([PL_data Transform from Japan Website]!Dec),0,[PL_data Transform from Japan Website]!Dec)+IIf(IsNull([PL_data Transform from Japan Website]!Jan),0,[PL_data Transform from Japan Website]!Jan)+IIf(IsNull([PL_data Transform from Japan Website]!Feb),0,[PL_data Transform from Japan Website]!Feb)+IIf(IsNull([PL_data Transform from Japan Website]!Mar),0,[PL_data Transform from Japan Website]!Mar)+IIf(IsNull([PL_data Transform from Japan Website]!Apr),0,[PL_data Transform from Japan Website]!Apr)+IIf(IsNull([PL_data Transform from Japan Website]!May),0,[PL_data Transform from Japan Website]!May)+IIf(IsNull([PL_data Transform from Japan Website]!Jun),0,[PL_data Transform from Japan Website]!Jun) AS Expr1, [PL_data Transform from Japan Website].Sep, [PL_data Transform from Japan Website].Oct, [PL_data Transform from Japan Website].Nov, [PL_data Transform from Japan Website].Dec, [PL_data Transform from Japan Website].Jan, [PL_data Transform from Japan Website].Feb, [PL_data Transform from Japan Website].Mar, [PL_data Transform from Japan Website].Apr, [PL_data Transform from Japan Website].May, [PL_data Transform from Japan Website].Jun FROM [PL_data Transform from Japan Website] WHERE ((([PL_data Transform from Japan Website].[ORDER Contents]) Is Not Null)); INSERT INTO PL_Updated ( Model, QTYTL, OCT, NOV, [DEC], JAN, FEB, MAR, APR, MAY, JUN, JUL ) SELECT [PL_data Transform from Japan Website].[ITEM NAME], IIf(IsNull([PL_data Transform from Japan Website]!Oct),0,[PL_data Transform from Japan Website]!Oct)+IIf(IsNull([PL_data Transform from Japan Website]!Nov),0,[PL_data Transform from Japan Website]!Nov)+IIf(IsNull([PL_data Transform from Japan Website]!Dec),0,[PL_data Transform from Japan Website]!Dec)+IIf(IsNull([PL_data Transform from Japan Website]!Jan),0,[PL_data Transform from Japan Website]!Jan)+IIf(IsNull([PL_data Transform from Japan Website]!Feb),0,[PL_data Transform from Japan Website]!Feb)+IIf(IsNull([PL_data Transform from Japan Website]!Mar),0,[PL_data Transform from Japan Website]!Mar)+IIf(IsNull([PL_data Transform from Japan Website]!Apr),0,[PL_data Transform from Japan Website]!Apr)+IIf(IsNull([PL_data Transform from Japan Website]!May),0,[PL_data Transform from Japan Website]!May)+IIf(IsNull([PL_data Transform from Japan Website]!Jun),0,[PL_data Transform from Japan Website]!Jun)+IIf(IsNull([PL_data Transform from Japan Website]!Jul),0,[PL_data Transform from Japan Website]!Jul) AS Expr1, [PL_data Transform from Japan Website].Oct, [PL_data Transform from Japan Website].Nov, [PL_data Transform from Japan Website].Dec, [PL_data Transform from Japan Website].Jan, [PL_data Transform from Japan Website].Feb, [PL_data Transform from Japan Website].Mar, [PL_data Transform from Japan Website].Apr, [PL_data Transform from Japan Website].May, [PL_data Transform from Japan Website].Jun, [PL_data Transform from Japan Website].Aug FROM [PL_data Transform from Japan Website] WHERE ((([PL_data Transform from Japan Website].[ORDER Contents]) Is Not Null)); ...
View Full Document

Ask a homework question - tutors are online