Databases Reference
In-Depth Information
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 = 5)sb5
on sb1.orderNo = sb5.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 = 6)sb6
on sb1.orderNo = sb6.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 = 7)sb7
on sb1.orderNo = sb7.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 = 8)sb8
on sb1.orderNo = sb8.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 = 9)sb9
on sb1.orderNo = sb9.orderNo
