Using multiple Columns in Partition By clause in SQL Server

irshad.n...

SOLVED CLOSED ACTIVE ANSWERED
User: irshad.niet
Posted: on Jan 22, 2024 10:02 PM
Forum: SQL Server
Replies: 6
Views: 1977

Dear All,

I want to Partition based on 2 columns such as Branchid and Year like

if Branchid =1 and date = 2021-09-01 save rows in file2021.ndf
if Branchid =1 and date = 2022-10-01 save rows in file2022.ndf
if Branchid =2 and date = 2021-09-01 save rows in file2021.ndf 
if Branchid =2 and date = 2022-10-01 save rows in file2022.ndf

Thank You.

Download FREE API for Word, Excel and PDF in ASP.Net

irshad.n...

0 5

Reply
User: irshad.niet
Replied: on Jan 24, 2024 01:06 AM
Report

this is my partition function below

CREATE PARTITION FUNCTION [DatePartitionFunction](datetime) AS RANGE RIGHT FOR VALUES (N'2019-01-01T00:00:00.000', N'2020-01-01T00:00:00.000', N'2021-01-01T00:00:00.000', N'2022-01-01T00:00:00.000', N'2023-01-01T00:00:00.000')
GO

I want to make sub partition with branches or update the partition function with varchar(banchid|datetime).

thank u

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Using multiple Columns in Partition By clause in SQL Server

Company

Explore

Follow us

Contact Us