Showing posts with label MSSQL. Show all posts
Showing posts with label MSSQL. Show all posts

Thursday, March 7, 2024

AWS DMS Mapping Table (MSSQL) : Loading Table data using boundaries

 MSSQL query boundaries conditions  



SELECT Max(Id)  nt

FROM (SELECT Id,(Ntile(160) over( ORDER BY Id)) nt FROM demo)

test

GROUP BY nt

ORDER BY nt

option (maxDOP 1024)