Wednesday, June 03, 2015

the nesting instinct

This morning I have mostly been writing:
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 desc
Prodnose: 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.
Post a Comment