edited tags
Link
Paul White
  • 65.1k
  • 25
  • 364
  • 566
changed title to proper case
Link
Dan Guzman
  • 23.4k
  • 2
  • 36
  • 63

HOW TO CREATE PARTITION FUNCTION ON TWO COLUMNS LIKE INTEGER AND DATETIME How to create partition function on two columns like integer and datetime

edited body
Source Link

Can a table be partitioned in two ways? For example, both with date and with the unit

if unit=1 and date > 2021-1009-0601 save rows in file1.ndf
if unit=1 and date > 2021-10-0701 save rows in file2.ndf
if unit=2 and date > 2021-1009-0601 save rows in file3.ndf
if unit=2 and date > 2021-10-0701 save rows in file4.ndf

Can a table be partitioned in two ways? For example, both with date and with the unit

if unit=1 and date > 2021-10-06 save rows in file1.ndf
if unit=1 and date > 2021-10-07 save rows in file2.ndf
if unit=2 and date > 2021-10-06 save rows in file3.ndf
if unit=2 and date > 2021-10-07 save rows in file4.ndf

Can a table be partitioned in two ways? For example, both with date and with the unit

if unit=1 and date > 2021-09-01 save rows in file1.ndf
if unit=1 and date > 2021-10-01 save rows in file2.ndf
if unit=2 and date > 2021-09-01 save rows in file3.ndf
if unit=2 and date > 2021-10-01 save rows in file4.ndf
Source Link
Loading