TSQL

Stored Procedure and SSRS Parameters to Handle Filter Selection

Database Create GUID

UNION vs UNION ALL

UNION The UNION command combines the result set of two or more SELECT statements (only distinct values). UNION ALL The UNION ALL command combines the result set of two or more SELECT statements (allows duplicate values).

Insert via Select Values

Remove Duplicate Record

Look for duplicate records. Remove duplicate records

Update Time Zone DateTime Value

TSQL Parse String

Convert Date and Time to DateTime

Add Foreign Key

Drop Table