[thelist] Constructive Crit

[Michael Buffington]

Looking for some design crit on:
http://www.michaelbuffington.com/resume

Also:
http://www.stompzine.com/index.cfm

Any thoughts on color, design, readability, usability, etc, appreciated.

<tip type="SQL Server" Author="Michael Buffington">
Having trouble executing a highly dynamic stored procedure in SQL Server?

Build the SQL statement as a string, like so:

set @statement =
(
'SELECT cols
FROM table
WHERE col_id IN (' + @ids +  ' )'
)

Then execute it:
exec (@statement)

Or print it for debugging:
print (@statement)

Pros - allows you to execute stored procedures that would otherwise bonk, in
this case, let's you pass a comma delimited list of ID numbers

Cons - no execution plan is created for the executed string, which can
result in performance loss.
</tip>