Is a Temporary Table Really Necessary?

Is a Temporary Table Really Necessary?

Shows how to do looping in SQL.

WHILE @lngLoopCount <> 0BEGIN
SET @strTabName = (SELECT strTableName FROM #tTables WHERE numID = @lngLoopCount)
EXEC sp_spaceused @strTabName
SET @lngLoopCount = @lngLoopCount - 1END

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own
Incompetence Lead to Inflated Self-Assessments

http://www.apa.org/journals/features/psp7761121.pdf