FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder. FileTables is a new feature introduced in SQL Server 2012. It's a ...
Obviously, not in the Falklands. Amir Netz, newly promoted to Technical Fellow at Microsoft was next up, showed us the latest on Project Crescent, for ad hoc reporting using SSRS. The tool is now ...
SELECT DISTINCT ContractNumber, AccountID WHERE ContractNumber IN ( (CASE WHEN @PorC = 'P' THEN (PNumber) ELSE (@TNumber) END) ) This works when @TNumber is a single value, but the parameter is ...