Tom H

Tom H has asked 13 questions and find answers to 224 problems.

Stats

About

Tom H questions

What are good Powershell verbs for checking in/out files?
Finding matches in arrays of objects in Powershell
Truncate the underlying table in a view
SQL Server won't use my index
SQL version control methodology
Watching variables in SSIS during debug

Tom H answers

determine if a restaurant is open now (like yelp does) using database, php, js
SQL - Only select row that is not duplicated
iSeries SQL Procedure - Check if already exists
Cross-database transactions from one SP
Dynamic sql statement to update a variable
Composite primary keys in N-M relation or not?
Dynamic Table Insert TSQL
Join multiple tables on one specific column
SQL: use computed string as table name, join all rows of select for counting
Sorting nested set by name while keep depth integrity