Who’s got some pretty BAQ art?
#Diamond
This is a real gem of a BAQ, am I right??
This is @josecgomez’s favorite BAQ now. He loves it. True story.
Who’s got some pretty BAQ art?
#Diamond
This is a real gem of a BAQ, am I right??
This is @josecgomez’s favorite BAQ now. He loves it. True story.
You mean
Subquery name takes the cake
Oh, that’s a whooooooooooooole 'nother story. Rofl.
I forgot about that.
That’s not art! That’s just terrifying!
It’s art to me.
I kinda want an explanation but I’m a little terrified of the answer.
I’m deeply intrigued by this.
What’s its purpose?
Can I get a more hi-res picture?
It reminds me of these things from the Avengers for some reason, lol.
This thread is getting craaaaazy!
Isn’t that what all good art is about?
What kind of art are you viewing Ernie???
Obviously, I’m viewing GOOD art…
It’s now outdated but:
It was a time phase report converted from a Progress DB to SQL. Since progress let you easily to a left outer join and find the first record when it converted they all went to CTE subqueries to return 1 row. (Yech) In addition to timephase it looks up the sales order PO, name & Shipping address and on job rows drills down and gets the part routing, quantity ran or start date if not started.
All nicely replaced by the String_Agg function in SQL.
So who has the record for most subqueries? I’ve made it to the 50’s.