select aucid, aucCurrentBid, aucPaidAmount, aucDeliveryCost, PYD_Datetime as Month, PYD_Amount, TYP_Namefrom dbo.vtblAPAuctions, dbo.vPaymentAudit, dbo.Typeswhere aucGUID=PYD_ItemGUID and TYP_ID=PYD_Type and TYP_Context='PYD_Type' and PYD_Confirmed is not null and aucID in (select aucidfrom dbo.vtblAPAuctions, dbo.vPaymentAudit, dbo.Typeswhere aucGUID=PYD_ItemGUID and TYP_ID=PYD_Type and TYP_Context='PYD_Type' and PYD_Confirmed is not null and aucID in (select aucID from dbo.vtblAPAuctions join dbo.vPaymentAuditon aucGUID=PYD_ItemGUID where PYD_Confirmed is not nullgroup by aucID having COUNT(' ') > 1) Group by aucID, MONTH(PYD_Datetime)Having COUNT(' ')=1 ) order by aucID desc , Month descProdnose: That is of very little interest to me.
Myself: That may very will be so, but I think other people may be intrigued by this sort of shaving from the bench of a master craftsman. It is like reality TV for the mind.
No comments:
Post a Comment