Joe Stefanelli

Joe Stefanelli has asked 0 questions and find answers to 529 problems.

Stats

About

I am a SQL Server developer/DBA. I've been working with SQL Server since 1999, starting with version 7.0 and every version since. Prior to that, I worked with Informix in an HP-UX environment.

Joe Stefanelli questions

Joe Stefanelli answers

What does this do?
Is it possible to match NULL values with the IN operator? (x IN (NULL, a, b))
select rows that all exist in other table - how to improve performance?
Quick help using RANK over multiple variables
Access to SQL: IFF function
SQL Server insert multiple records with same datetime
Number of times a record shows up : SQL Server
How to export SQL Server 2005 rows to excel? Everytime I do it I get errors
Return two Count(*) results in one select
SQLSTATE[HY093] : pdo statement during insert into mysql db