Hogan

New York, NY

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

oh, and #SOreadytohelp, but you can see that just looking below.

top accounts reputation activity subscriptions

Change default action on connecting a USB device

windows usb asked Mar 15, 2012 at 15:11

superuser.com

23 votes

Garlic with the olives... what happened?

food-preservation garlic pickling asked Aug 31, 2022 at 2:13

cooking.stackexchange.com

17 votes

Emulate a TSQL sequence via a stored procedure

sql-server-2008 sequence asked Jun 14, 2011 at 15:10

dba.stackexchange.com

14 votes

stackstatus shows the same message twice

bug status-reproduced stackstatus asked Oct 7, 2013 at 20:37

meta.stackexchange.com

13 votes

My icon show 75% with just one question asked

support accept-rate information-display user-information asked Jan 10, 2010 at 19:42

meta.stackexchange.com

9 votes

SpecifiedPickupDirectory will not create files until viewed by a user on the server

asp.net iis smtp asked Dec 7, 2011 at 19:30

stackoverflow.com

9 votes

Front page message in wrong language

bug status-completed hot-questions frontpage localization asked Dec 16, 2013 at 19:11

meta.stackexchange.com

7 votes

How do I vote to delete an answer?

support asked Jan 10, 2012 at 22:18

meta.stackexchange.com

6 votes

Tag Wiki for a new tag

feature-request status-completed tags tag-wiki asked Nov 2, 2010 at 18:48

meta.stackexchange.com

6 votes

Benefits of droping a temporary table

sql-server asked Oct 28, 2013 at 19:16

dba.stackexchange.com

Top Answers

894

Pad a string with leading zeros so it's 3 characters long in SQL Server 2008

stackoverflow.com

233

How do I drop table variables in SQL-Server? Should I even do this?

stackoverflow.com

224

Open Source Advertising - Sidebar - 1H 2010

meta.stackexchange.com

148

Convert multiple rows into one with comma as separator

stackoverflow.com

Convert date to YYYYMM format

stackoverflow.com

How to do multiple conditions for single If statement

stackoverflow.com

SELECT using 'CASE' in SQL

stackoverflow.com

Type mismatch: cannot convert from integer to boolean

stackoverflow.com

strlen not checking for NULL

stackoverflow.com

How to stop the spin.js spinner with jQuery

stackoverflow.com

What is the equivalent of String.Join on TSQL?

stackoverflow.com

Simplest way to filter value from generic List in C# using LINQ

stackoverflow.com

Declaring arrays in c language without initial size

stackoverflow.com

How to create global object in a C# library

stackoverflow.com

do {...} while(false)

stackoverflow.com

Create a string of variable length, filled with a repeated character

stackoverflow.com

Counting the number of elements with the same class in jquery

stackoverflow.com

Checking to see if a column exists in a data reader

stackoverflow.com

Is C/C++ one language or two languages?

stackoverflow.com

Migrate SQL Server DateTime column to DateTimeOffset

stackoverflow.com

Writing FizzBuzz

stackoverflow.com

INSERT IF NOT EXISTS but return the identity either way

stackoverflow.com

SELECT DISTINCT on one column, return multiple other columns (SQL Server)

stackoverflow.com

insert multiple rows into DB2 database

stackoverflow.com

Creating ADODB Parameters on the fly

codereview.stackexchange.com

convert text string to hexadecimal representation or binary representation

stackoverflow.com

How can I check if current day is working day

stackoverflow.com

Send email with image embedded - image not visible

stackoverflow.com

Remove all the characters after $ sign using Javascript

stackoverflow.com

how many instances of SqlConnection should I use

stackoverflow.com