Databases Reference
In-Depth Information
sb14.productGroup product14, sb14.seasonCode season14,
sb14.quantity quantity_14, sb14.unitPrice price_14
from
(Select rn.[orderNo],rn.article_No,rn.[description],rn.colorDescription,
rn.size, rn.productGroup, rn.seasonCode, rn.[quantity],rn.unitPrice from
(SELECT row_number() over (partition by s.[orderNo]
order by a.article_No) as lfdNr,
s.[orderNo],a.article_No,a.[description],a.colorDescription,
a.size, a.productGroup, a.seasonCode, s.[quantity],a.unitPrice
FROM [dbo].[iw_sales]s,[dbo].[iw_article]a
where s.[type] = 2
and s.orderDate between '01.05.2011'and '31.05.2011'
and s.IWAN = a.IWAN)rn
where lfdNR = 1)sb1
left outer join
(Select rn.[orderNo],rn.article_No,rn.[description],rn.colorDescription,
rn.size, rn.productGroup, rn.seasonCode, rn.[quantity],rn.unitPrice from
(SELECT row_number() over (partition by s.[orderNo]
order by a.article_No) as lfdNr,
s.[orderNo],a.article_No,a.[description],a.colorDescription,
a.size, a.productGroup, a.seasonCode, s.[quantity],a.unitPrice
FROM [dbo].[iw_sales]s,[dbo].[iw_article]a
where s.[type] = 2
and s.orderDate between '01.05.2011'and '31.05.2011'
and s.IWAN = a.IWAN)rn
where lfdNR = 2)sb2
on sb1.orderNo = sb2.orderNo
left outer join
(Select rn.[orderNo],rn.article_No,rn.[description],rn.colorDescription,
rn.size, rn.productGroup, rn.seasonCode, rn.[quantity],rn.unitPrice from
(SELECT row_number() over (partition by s.[orderNo]
order by a.article_No) as lfdNr,
s.[orderNo],a.article_No,a.[description],a.colorDescription,
a.size, a.productGroup, a.seasonCode, s.[quantity],a.unitPrice
FROM [dbo].[iw_sales]s,[dbo].[iw_article]a
where s.[type] = 2
and s.orderDate between '01.05.2011'and '31.05.2011'
and s.IWAN = a.IWAN)rn
where lfdNR = 3)sb3
on sb1.orderNo = sb3.orderNo
left outer join
(Select rn.[orderNo],rn.article_No,rn.[description],rn.colorDescription,
rn.size, rn.productGroup, rn.seasonCode, rn.[quantity],rn.unitPrice from
(SELECT row_number() over (partition by s.[orderNo]
order by a.article_No) as lfdNr,
s.[orderNo],a.article_No,a.[description],a.colorDescription,
a.size, a.productGroup, a.seasonCode, s.[quantity], a.unitPrice
FROM [dbo].[iw_sales]s,[dbo].[iw_article]a
where s.[type] = 2
and s.orderDate between '01.05.2011'and '31.05.2011'
and s.IWAN = a.IWAN)rn
where lfdNR = 4)sb4
on sb1.orderNo = sb4.orderNo
left outer join
(Select rn.[orderNo],rn.article_No,rn.[description],rn.colorDescription,
rn.size, rn.productGroup, rn.seasonCode, rn.[quantity],rn.unitPrice from
(SELECT row_number() over (partition by s.[orderNo]
order by a.article_No) as lfdNr,
s.[orderNo],a.article_No,a.[description],a.colorDescription,
