« first day (2057 days earlier)      last day (2813 days later) » 

billinkc
billinkc
2:20 PM
```````````````` — Jacob Alley 4 mins ago
 
wBob
wBob
@billinkc Is 'backtick crazy' like 'batsh*t crazy"?
2
 
billinkc
billinkc
2:50 PM
Seems like it
 
Andriy M
Andriy M
-1
A: SQL, list if has at least one value for each property

DZU MALJust pay somebody to do the SQL thing for you and then EEEEEEEEEEEEEEEEEEEEEEEEEEEEY ░░░░░░▄█████▄░░░░░░░░░░░░░░░░░░░░░ ░░░░▄█▀▀░░░░▀█▄░░░░░░░░░░░░░░░░░░░ ░░░▄█▄▄▄▄░▄▄▄▄█░░░░░░░░░░░░░░░░░░░ ░░░██████▀██████░░░░░░░░░░░░░░░░░░ ░░██░░▀░▄██▀▀░░█░EEEEEYYYYYYYYY SQL ░░░▀█░░░░░░░░░█▀░░░░Op, Op, Op ...

for posterity
 
 
4 hours later…
Lamak
Lamak
7:10 PM
man, this guy is just guessing
-1
A: Join is not showing the right amount of rows

MavilesThis is very resource consuming, but your database doesn't seen big. SELECT t.ItemKey ,t.PostDate ,t.ReturnAmt ,t.ReturnsQty ,t.SalesAmt ,t.SalesQty ,t.TranDate ,(SELECT s.CustID FROM [dbo].[slSalesOrderTable] s WHERE t.CustKey = s.CustKey LIMIT 1) as CUSTID FROM [dbo].[tsoSales...

 
Tom V
Tom V
@Lamak Answer only as good as question --blam
 
Lamak
Lamak
@TomV yup. But Matt ruined my fun with his comment
I wanted to see what that guy was gonna use next
 
Tom V
Tom V
The guessing game has ended indeed
 
Lamak
Lamak
yeah, maybe I should've ended it earlier by giving the guy the solution
but....SO
 
Tom V
Tom V
tempted to flag your comments as obsolete now :)
 
Lamak
Lamak
7:18 PM
should I remove the downvote now?...I mean, at least it will work now, but it's not the right way to do it....
@TomV the story of my life
 
Tom V
Tom V
@Lamak it's technically correct but did he actually come up with it?
 
Lamak
Lamak
@TomV meh, it still works.
 
Tom V
Tom V
and possibly better than the accepted one
 
Lamak
Lamak
it all depends on op's data
 
Andriy M
Andriy M
7:59 PM
What's with that guy's userpic? It's green when shown under their answer and pink when I open their user page.
 
Lamak
Lamak
@AndriyM hey, you are right
 
Paul Vargas
Paul Vargas
8:29 PM
@Lamak Hi! Where are you from?
 
Lamak
Lamak
chile
and hi
 
Paul Vargas
Paul Vargas
@Lamak Humm... so are you in Chine now?
 
Lamak
Lamak
yup, ChiLe
and you?
 
Paul Vargas
Paul Vargas
8:44 PM
@Lamak Mexico.
 
Lamak
Lamak
I've only been to mexico once. But had a good time
 

« first day (2057 days earlier)      last day (2813 days later) »