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

21h
comment Access SQL Query Equal Row Values
@Ravinder - your answer is wrong. CASE does not work in MS-ACCESS, IFF() is needed.
22h
comment Best way to INSERT into SQL Server database
Why would keeping trades in memory "slow things down". This is an interesting assumption to me. Typically caching and buffering are techniques which speed up programs and they involve keeping things in memory.
2d
answered VB.NET Txtfile -> SQL server loop issue
2d
comment How can i turn a INT to VARCHAR in SQL
that was not clear to me barmar -- he tried both things, did you read past the first line?
2d
comment VB.NET Txtfile -> SQL server loop issue
now is your chance you are just starting out, DON'T USE i AS A VARIABLE NAME!
2d
revised How can i turn a INT to VARCHAR in SQL
added 44 characters in body
2d
answered How can i turn a INT to VARCHAR in SQL
Apr
21
comment While loop in T-SQL
"loop a join" means nothing to me -- can you explain with example code or expected output?
Apr
21
answered sql statement with an if inside of it?
Apr
21
comment While loop in T-SQL
great - now it seems your question does not have a question -- can you state a question with this code?
Apr
20
comment While loop in T-SQL
describing queries with English does not work. Please add the actual queries you are using to the question -- I can't possibly understand what you are saying.
Apr
20
comment SQL for amount of days since specified date each year (SQL Server)
this will return negative values if the date is before the 15th -- see Gordan's answer if you want to check the prior year.
Apr
20
comment SQL for amount of days since specified date each year (SQL Server)
I think you meant day(getdate()) > 15 not date ...
Apr
20
answered SQL for amount of days since specified date each year (SQL Server)
Apr
20
comment While loop in T-SQL
@SQLUser44 - sample data means the actual values for the rows and columns in the database and the expected results.
Apr
20
answered While loop in T-SQL
Apr
19
comment How query all results in a Relational Table?
Ok. But is it the correct data as you describe in your data model... I'm not sure.
Apr
19
comment How query all results in a Relational Table?
yes I know that is what you said. If you are getting the results you described then the data is not in the table... dump the table for the rows you expect to be there and see.
Apr
18
comment How query all results in a Relational Table?
@bibiana sounds like the book is not in the autorxprod table.
Apr
17
awarded Constituent
1 2 3 4 5