Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, youâ€™ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
SELECT T2.CardCode, T2.CardName, T2.U_IIS_INADR, T0.[DocEntry], T0.[ItemCode], T0.[Dscription]
, T0.U_iis_ddate, T0.[Quantity], T0.LineTotal, T1.[SlpName], T0.[u_iis_INS2], T0.[u_IIS_INS3], T3.[U_IIS_TIME]
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
untitled.JPG
SELECT T2.CardCode, T2.CardName, T2.U_IIS_INADR
, CONVERT(varchar(10), T0.U_iis_ddate, 120) u_iis_date
, sum(T0.[Quantity]) sum_quantity
, sum(T0.LineTotal) sum_linetotal
, T1.[SlpName]
, sum(T3.[U_IIS_TIME]) sum_uiis_time
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
group by T2.CardCode, T2.CardName, T2.U_IIS_INADR, T1.[SlpName], CONVERT(varchar(10), T0.U_iis_ddate, 120)
SELECT T2.CardCode, T2.CardName
, CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)) AS U_IIS_INADDR
, CONVERT(varchar(10), T0.U_iis_ddate, 120) u_iis_date
, sum(T0.[Quantity]) sum_quantity
, sum(T0.LineTotal) sum_linetotal
, T1.[SlpName]
, sum(T3.[U_IIS_TIME]) sum_uiis_time
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
group by T2.CardCode, T2.CardName, CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)), T1.[SlpName], CONVERT(varchar(10), T0.U_iis_ddate, 120)
SELECT T2.CardCode, T2.CardName
--, CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)) AS U_IIS_INADDR
, CONVERT(varchar(10), T0.U_iis_ddate, 120) u_iis_date
, sum(T0.[Quantity]) sum_quantity
, sum(T0.LineTotal) sum_linetotal
, T1.[SlpName]
, sum(T3.[U_IIS_TIME]) sum_uiis_time
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
group by T2.CardCode, T2.CardName, /* CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)), T1.[SlpName], */ CONVERT(varchar(10), T0.U_iis_ddate, 120)
SELECT T2.CardCode, T2.CardName
--, CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)) AS U_IIS_INADDR
, CONVERT(varchar(10), T0.U_iis_ddate, 120) u_iis_date
, sum(T0.[Quantity]) sum_quantity
, sum(T0.LineTotal) sum_linetotal
, T1.[SlpName]
, sum(T3.[U_IIS_TIME]) sum_uiis_time
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
group by T2.CardCode, T2.CardName, /* CAST(T2.U_IIS_INADR AS NVARCHAR(MAX)), */ T1.[SlpName], CONVERT(varchar(10), T0.U_iis_ddate, 120)
SELECT CONVERT(varchar(10), T0.U_iis_ddate, 120) u_iis_date
, sum(T0.[Quantity]) sum_quantity
, sum(T0.LineTotal) sum_linetotal
, T1.[SlpName]
, sum(T3.[U_IIS_TIME]) sum_uiis_time
FROM DLN1 T0
INNER JOIN OSLP T1
ON T0.SlpCode = T1.SlpCode
INNER JOIN ODLN T2
ON T0.DocEntry = T2.DocEntry
left outer join OSCN T3
on t3.ItemCode = t0.ItemCode
and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8)
WHERE T2.[U_IIS_JTYPE] = '6'
and T0.[U_iis_ddate] >= '[%0]'
and T0.[U_iis_ddate] <= '[%1]'
group by T1.[SlpName], CONVERT(varchar(10), T0.U_iis_ddate, 120)
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.