Databases Reference
In-Depth Information
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 = 10)sb10
on sb1.orderNo = sb10.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 = 11)sb11
on sb1.orderNo = sb11.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 = 12)sb12
on sb1.orderNo = sb12.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 = 13)sb13
on sb1.orderNo = sb13.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
