Hogan

New York, NY

Age: 48

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
comment Game Development html storage error
@GeorgeStocker - It was clear to me, I was even able to answer.
2d
comment Game Development html storage error
See my answer, I give a hint there.
2d
answered Game Development html storage error
2d
comment Game Development html storage error
@user13286 - he said he did not want to show it for "saftey". My guess is that he did not want to catch the flu before he finished the game.
2d
answered Update arbitrary member with only non null values
2d
comment SQL select from multiple tables based on datetime
Yes fixed, I like my answer better (I think it will be faster), but this will work.
2d
answered SQL select from multiple tables based on datetime
2d
comment SQL select from multiple tables based on datetime
here is your code failing sqlfiddle.com/#!3/d2fb40/1
2d
comment SQL select from multiple tables based on datetime
The timestamps have different values -- they won't join with a simple =
2d
comment Format Columns from SQL Count
FM -> msdn.microsoft.com/en-us/library/dwhawy9k%28v=vs.110%29.aspx
2d
comment Format Columns from SQL Count
{0.d} is invalid, {0:d} should work fine.
2d
comment Select percentage of rows from SQL table?
you could use row count mod 10 <= 4
2d
comment Select percentage of rows from SQL table?
If you had a timestamp you could take seconds less than 24 to get 40% (or other tricks with the number of seconds if you think the first half of a minute might introduce a bias)
2d
answered sql query to unify results length
2d
comment SQL Join Constraint Column on Another Joined Table
small hint on data design naming. typically tables are name singular not plural. so "product", "order" and "order_item" would be more standard names. they are named for the type of one row not the collection. tales are always a collection.
2d
comment SQL Join Constraint Column on Another Joined Table
just change your 2nd join to an inner join. JOIN orders ON order_items.order_id = orders.id AND orders.status = 'done' (Take out the LEFT)
2d
reviewed Approve suggested edit on SQL Join Constraint Column on Another Joined Table
2d
comment T-SQL concatenate rows with same Id
Here is an answer to this question that might be clearer...stackoverflow.com/questions/887628/…
2d
revised Can you dynamically cast during runtime inside a linq statement?
added 146 characters in body
2d
comment How to replace text within a string based on their indices
Isn't it as simple as just sorting the starting index of the replacements and making sure you replace the ones with the highest index first?
1 2 3 4 5