Hogan

New York, NY

Age: 49

25+ years...
ASM, C, C++, C#, VB, ASP.NET, TSQL +many more


The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.


Programmer, Architect, Team Lead, Director, CTO
MS Comp. Sci @ NYU '95
hoganlong at us.ibm.com // hoganlong at gmail.com

2d
awarded Notable Question
Jul
1
answered SQL query not displaying the desired result
Jun
24
awarded Curious
May
27
comment Is there any way to simplify these two subqueries into one?
Ok how about a list of users and who invited then for awarding referral bonuses. I think this is a more common business case than one where you need to know who referee and are interested in cases where there is no inviter. But the OP knows for sure.
May
26
comment Is there any way to simplify these two subqueries into one?
@dnoeth - I can make it a left join, I still think a inner join is probably what the OP wants. But they can figure that out themselves.
May
26
revised Is there any way to simplify these two subqueries into one?
added 5 characters in body
May
26
revised Is there any way to simplify these two subqueries into one?
added 188 characters in body
May
26
answered Is there any way to simplify these two subqueries into one?
May
24
comment Select statement in a transaction SQL Server
What else is in the transaction?
May
22
comment compare datatables and save unmatched rows in third datatable
I don't think default works because he only wants to Check two of the fields
May
22
comment compare datatables and save unmatched rows in third datatable
Add an if statement I guess
May
22
answered compare datatables and save unmatched rows in third datatable
May
22
comment Why will SQL query work with one value and not another?
This question has been asked a million times on stackoverflow @Allenph but maybe... :)
May
22
comment Cast vs Convert SQL Server
TLDR; select dateadd(day,datediff(day,0,@datetime),0);
May
22
comment Cast vs Convert SQL Server
possible duplicate of Floor a date in SQL server
May
22
answered Why will SQL query work with one value and not another?
May
22
comment Why I got Not a single-group group function in sql
@GiorgosBetsos - you are 100% correct -- good catch. Answer edited.
May
22
comment Why I got Not a single-group group function in sql
people closing because of the typographical error should not... there is a more significant issue here than that.
May
22
revised Why I got Not a single-group group function in sql
added 255 characters in body
May
22
comment Why I got Not a single-group group function in sql
top 1 and rownum don't work in DB2 there you use FETCH FIRST 1 ROWS ONLY at the end of the query
1 2 3 4 5