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

1m
answered When and how does git use deltas for storage?
4m
comment Query performance is not what I would expect
What indexes does the table have? Probably can used a different index in the 2nd plan.
7m
comment SQL: change value in field to equivalent
@HirenDhaduk - Right standard collation. Been using DB2 to much recently :)
20m
comment SQL: change value in field to equivalent
you might want ON upper(A.StateProvince) = upper(B.NAME) to be safe.
22m
revised SQL: change value in field to equivalent
added 10 characters in body
25m
comment Group by ALL days in a range
very nice answer Jodrell! (the days query was exactly what I was thinking of when I said "linq code that would make this easy")
1h
revised js bug in the average function
edited tags
1h
comment Set up single event handler for multiple buttons
@JoeBrunscheon - Why? If there is no difference why would it matter?
1h
answered Set up single event handler for multiple buttons
2h
comment Group by ALL days in a range
if you post what you have so far there may be some linq code that will make this easy.
2h
comment Group by ALL days in a range
sounds like you have to merge. There are tricks you can do on the SQL side but you don't have access to the sql if you are using entity-framework.
1d
comment How do I fix my DateTime to show correct answer?
You can subtract datetime objects to get a time span msdn.microsoft.com/en-us/library/8ysw4sby%28v=vs.110%29.aspx
1d
comment VB SQL Server Ignoring Default Values
RE "Atomic Data" : On SQL Server the datetime type is "atomic". Date and Time types are much newer. The timestamp data type has always been called datetime on MS SQL.
1d
comment VB SQL Server Ignoring Default Values
Good to know, thanks
1d
revised VB SQL Server Ignoring Default Values
added 79 characters in body
2d
comment VB SQL Server Ignoring Default Values
hmmm... I thought they were optional if you are adding all needed fields in order
2d
comment VB SQL Server Ignoring Default Values
Steve this is exactly the same as my answer.
2d
comment VB SQL Server Ignoring Default Values
can I ask why you have a time field and a date field and not a datetime field. datetime would work better and it is what GETDATE() returns. To be honest I don't think I've ever set a default value for a date and a time, just for a datetime.
2d
comment VB SQL Server Ignoring Default Values
You have only two columns listed in your INSERT statement and it still defaults?
2d
answered VB SQL Server Ignoring Default Values
1 2 3 4 5