[datfi]

Цитата:

Сообщение от a33ik

Кажется понял в чём заключается Ваша проблема. Приведите, пожалуйста, запросы - помогу решить Вашу проблему.

dataset1

SELECT     FilteredQuoteDetail.productidname, FilteredQuoteDetail.quantity, FilteredQuoteDetail.priceperunit, FilteredQuoteDetail.extendedamount, 
                      FilteredQuoteDetail.quoteid, FilteredQuoteDetail.productid, FilteredProduct.productid AS Expr1, CRMAF_FilteredQuote.quoteid AS Expr2, 
                      FilteredProduct.new_producttypename, FilteredProduct.new_licenseprgname, CRMAF_FilteredQuote.createdon, CRMAF_FilteredQuote.quotenumber, 
                      CRMAF_FilteredQuote.totaltax, CRMAF_FilteredQuote.customeridname, CRMAF_FilteredQuote.owneridname
FROM         FilteredQuoteDetail INNER JOIN
                      FilteredProduct ON FilteredQuoteDetail.productid = FilteredProduct.productid INNER JOIN
                      FilteredQuote AS CRMAF_FilteredQuote ON FilteredQuoteDetail.quoteid = CRMAF_FilteredQuote.quoteid
WHERE     (FilteredProduct.new_licenseprgname = N'OLP')

dataset2

SELECT     FilteredQuoteDetail.productidname, FilteredQuoteDetail.quantity, FilteredQuoteDetail.priceperunit, FilteredQuoteDetail.extendedamount, 
                      FilteredQuoteDetail.quoteid, FilteredQuoteDetail.productid, FilteredProduct.productid AS Expr1, CRMAF_FilteredQuote.quoteid AS Expr2, 
                      FilteredProduct.new_producttypename, FilteredProduct.new_licenseprgname, CRMAF_FilteredQuote.createdon, CRMAF_FilteredQuote.quotenumber, 
                      CRMAF_FilteredQuote.totaltax, CRMAF_FilteredQuote.customeridname, CRMAF_FilteredQuote.owneridname
FROM         FilteredQuoteDetail INNER JOIN
                      FilteredProduct ON FilteredQuoteDetail.productid = FilteredProduct.productid INNER JOIN
                      FilteredQuote AS CRMAF_FilteredQuote ON FilteredQuoteDetail.quoteid = CRMAF_FilteredQuote.quoteid
WHERE     (FilteredProduct.new_licenseprgname = N'OV/OVS') AND (FilteredProduct.new_producttypename <> N'Software Assurance')

dataset3

SELECT     FilteredQuoteDetail.productidname, FilteredQuoteDetail.quantity, FilteredQuoteDetail.priceperunit, FilteredQuoteDetail.extendedamount, 
                      FilteredQuoteDetail.quoteid, FilteredQuoteDetail.productid, FilteredProduct.productid AS Expr1, CRMAF_FilteredQuote.quoteid AS Expr2, 
                      FilteredProduct.new_producttypename, FilteredProduct.new_licenseprgname, CRMAF_FilteredQuote.createdon, CRMAF_FilteredQuote.quotenumber, 
                      CRMAF_FilteredQuote.totaltax, CRMAF_FilteredQuote.customeridname, CRMAF_FilteredQuote.owneridname
FROM         FilteredQuoteDetail INNER JOIN
                      FilteredProduct ON FilteredQuoteDetail.productid = FilteredProduct.productid INNER JOIN
                      FilteredQuote AS CRMAF_FilteredQuote ON FilteredQuoteDetail.quoteid = CRMAF_FilteredQuote.quoteid
WHERE     (FilteredProduct.new_producttypename = 'Software Assurance') AND (FilteredProduct.new_licenseprgname = 'OV/OVS')