hello,
i need to write this query in ax, not whit query object but simple query by select etc etc....
Normal 0 14 false false false IT X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Normal 0 14 false false false IT X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}
SELECT CASE WHEN IsNull(TableBL.FieldBL, 0) + IsNull(TableFT.FieldFT, 0) = 0
THEN 'NON TABLEO' WHEN IsNull(TableBL.FieldBL, 0) + IsNull(TableFT.FieldFT, 0)> 0 AND
(IsNull(TableBL.FieldBL, 0) + IsNull(TableFT.FieldFT, 0)) < IsNull(ArtPk.FieldPK, 0) THEN 'PARZ. TABLEO'
WHEN IsNull(TableBL.FieldBL, 0) + IsNull(TableFT.FieldFT, 0) > 0 AND (IsNull(TableBL.FieldBL, 0) + IsNull(TableFT.FieldFT, 0)) >= IsNull(ArtPk.FieldPK, 0) THEN 'TABLEO' ELSE 'NON TABLEO' END AS 'StatoTable'
FROM PK_Table WITH (nolock) INNER JOIN
PK_Tipo WITH (nolock) ON PK_Table.PKAN_PKTI_Id = PK_Tipo.PKTI_Id LEFT OUTER JOIN
(SELECT FIELD(BL_Artic.BLAR_DQTA) AS FieldBL, PK_Table2.PKAR_PKAN_Id AS PKANId
FROM BL_Table WITH (nolock) INNER JOIN BL_Artic WITH (nolock) ON BL_Artic.BLAR_BLAN_Id = BL_Table.BLAN_Id INNER JOIN PK_Table2 WITH (nolock) ON BL_Artic.BLAR_PKAR_Id = PK_Table2.PKAR_Id
WHERE (PK_Table2.PKAR_PKAN_Id = 124995) AND (BL_Table.BLAN_NumBol > 0)
GROUP BY PK_Table2.PKAR_PKAN_Id) AS TableBL ON PK_Table.PKAN_Id = TableBL.PKANId
LEFT OUTER JOIN
(SELECT FIELD(FT_Artic.FTAR_DQTA) AS FieldFT, PK_Table2.PKAR_PKAN_Id AS PKANId
FROM FT_Table WITH (nolock) INNER JOIN FT_Artic WITH (nolock) ON FT_Artic.FTAR_FTAN_Id = FT_Table.FTAN_Id INNER JOIN PK_Table2 WITH (nolock) ON FT_Artic.FTAR_PKAR_Id = PK_Table2.PKAR_Id
WHERE (FT_Artic.FTAR_BLAR_ID IS NULL) AND (PK_Table2.PKAR_PKAN_Id = 124995) AND (FT_Table.FTAN_NumFatt > 0)
GROUP BY PK_Table2.PKAR_PKAN_Id) AS TableFT ON PK_Table.PKAN_Id = TableFT.PKANId
(SELECT FIELD(PKAR_QtaPick) AS FieldPK, FIELD(PKAR_DQTA) AS FieldDQtaPK, PKAR_PKAN_Id AS PKANId
FROM PK_Table2 WITH (nolock)
WHERE (PKAR_PKAN_Id = 124995)
GROUP BY PKAR_PKAN_Id) AS ArtPK ON ArtPK.PKANId = PK_Table.PKAN_Id
WHERE (PK_Table.PKAN_Id = 124995)
i need to help , please.
thank you.
Gio