Sihan's Code Repo

DAX counting using Rankx, allexcept

Mar 22, 20241 min read

Rank = RANKX( All('First Inspections'), -- Use ALL on the Provider ID column to remove any filters applied to it CALCULATE( ...

Bulk Copy in SQL Server

Mar 3, 20241 min read

DECLARE @sqlQuery NVARCHAR(MAX) DECLARE @outputFilePath NVARCHAR(MAX) SET @sqlQuery = 'SELECT * FROM [AdventureWorks2016].[dbo].[AWBuildVersion]' SET...

TSQL Stored Procedure Template

Feb 21, 20241 min read

create proc Get_full_details (@customer_id INT) as Select * from [AdventureWorks2016].[Sales].[Customer] where [CustomerID] = @customer_id; GO

C# Array, inserting at the end

Feb 21, 20241 min read

/Code // insert at the end of an aray using System; namespace MyApplication { class Program { static void Main() { // Inserting at the end of an...

Searching Columns in a Database

Feb 20, 20241 min read

-- How many columns are there in this table? select * from sys.syscolumns where id = OBJECT_ID('Production.Location') SELECT * FROM...

Nested IF in TSQL

Feb 20, 20241 min read

--nesting example DECLARE @Var1 INT = 15 IF @Var1 % 5 = 0 BEGIN IF @Var1 % 3 = 0 BEGIN print 'the number is divisible by 3 and 5' ...