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

Sep
7
comment How can I use a parameter in an interface that is defined by the interface
just use void g(Something s) in SomethingElse_class.
Sep
5
revised How to compare two Persian date via Linq-to-Entities?
deleted 1421 characters in body
Sep
5
comment order by queries in postgres extremely slow
You need an index on the column you are ordering by or THE ONLY WAY the top 6 can be found is to look at ALL the records in the table.
Sep
5
comment How to compare two Persian date via Linq-to-Entities?
@Amir - right, it is easy to switch from entities to objects to solve the problem, if you want it to run faster at the db tier I suggest create a view or SP.
Sep
5
revised How to compare two Persian date via Linq-to-Entities?
added 1445 characters in body
Sep
5
revised How to compare two Persian date via Linq-to-Entities?
added 1 character in body
Sep
5
comment How to compare two Persian date via Linq-to-Entities?
@SteveRuble This is not EF -- just linq.
Sep
5
answered Joining two queries or a union /union all
Sep
5
answered How to compare two Persian date via Linq-to-Entities?
Sep
5
awarded Notable Question
Sep
2
comment An update with multiple conditions. SQL 2008
@DougMocniak - The PriorityForLead = 1 does not only update userid = 1 it updates based on the first sequential number in an incrementing number which is ordered by userid. Run it without the update and view the results
Sep
2
answered How to do case when string not belong to a group then make another column blank?
Sep
2
comment How to do case when string not belong to a group then make another column blank?
which platform?
Sep
2
comment How do I get next item in array with each button click?
this is really unclear. what exactly are you asking? how to bind code to a button click? if so that has nothing to do with sql-server. How to write an update query -- if so what does that have to do with a button click. Please make the question simpler so I (and people who can answer) know what you are asking.
Aug
30
awarded sql-server-2008
Aug
29
answered C# MVC4 Linq - Filter table by either date or date + time
Aug
29
comment The custom date function works funky sometime
This is the problem with living in the future .... live only in the past man!
Aug
29
comment How to add sequential numbering to SQL tables from C#
You have the SQL you can just send it to the server with an ExecuteNonQuery. (Probably a bad design idea however)
Aug
28
comment SQL Server : error converting data type varchar to numeric unless I use REPLACE
@GordonLinoff - This issue can be really ugly on a JOIN when you think you are not joining to invalid data but it gets evaluated anyway because order of eval is not guaranteed and it is optimized to another thread.
Aug
28
revised Making this query build faster
added 10 characters in body
1 2 3 4 5