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

6h
answered C# MVC4 Linq - Filter table by either date or date + time
6h
comment The custom date function works funky sometime
This is the problem with living in the future .... live only in the past man!
8h
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)
1d
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.
1d
revised Making this query build faster
added 10 characters in body
1d
answered Making this query build faster
Aug
26
revised Display list in Tree like fashion
added 2 characters in body
Aug
26
comment Display list in Tree like fashion
his indents are 100% consistant
Aug
26
comment Display list in Tree like fashion
This does not answer the question, he didn't ask how to turn it into a tree.
Aug
26
comment Display list in Tree like fashion
also you are assuming the data is already a tree. It isn't... it is just a list, like he shows in the example.
Aug
26
comment Display list in Tree like fashion
you do see in the example that there is a logical difference between where the "----" is and where the spaces are?
Aug
26
comment Display list in Tree like fashion
Because it does not work... where do you indent?
Aug
26
answered Display list in Tree like fashion
Aug
26
comment Display list in Tree like fashion
That is strange... so the items in a parent don't have that node as a parent.
Aug
26
comment The parameter 'd' was not bound in the specified LINQ to Entities query expression
Wouldn't it be simpler to say you took out the line ParameterExpression peSubModel = Expression.Parameter(modelClass, "d"); from function GetConditionsWithSubModel?
Aug
25
comment SQL Server - combine results of two SELECT statements using LEFT OUTER JOIN
@MichaelSobczak this returns items that are NOT linked... as you asked for. I guess that is a lot of item.s
Aug
25
comment SQL Server - combine results of two SELECT statements using LEFT OUTER JOIN
@MichaelSobczak - Can't say, unless every item is the correct result. Do you have any items linked to CATALOG1
Aug
25
comment SQL Server - combine results of two SELECT statements using LEFT OUTER JOIN
@MichaelSobczak - Sounds like a typo, did you dbo.saitemcls.cde_id = 109?
Aug
25
comment Removing total days from Hhh:mm:ss
What is the format of your varchar exactly?
Aug
25
comment SQL Server - combine results of two SELECT statements using LEFT OUTER JOIN
@Laurence Don't see how -- I'm only returning things that are null, I guess if sacatalogitem has multiple entries for items, but I would not expect a DB to be designed this way.
1 2 3 4 5