Some half baked beans... Tao, Zen and the art of converting coffee into ideas...
Look at this piece of code...
Select * into #Constant from SCM3DConstant WHERE 0=1
Would you call this piece of code a hack...? Think about the intent of this piece of code and leave comments...
No it's not a hack. it's a perfectly valid fast table creation.
I use things like that to get info about tables without having to query sysobjects.
I would call it a hack. It's probably reasonable hack compared to the alternative, but you definately need to leave a comment explaining what it is doing.
Hmmm, I use these many a times in the normal code. So at least for me this is no hack