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
LEFT OUTER JOIN
(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