SQL Date Comparison With Month and Year in Separate Columns

I have a table (let’s call it MyData) that has some information and also stores a month and a year in separate columns but no day, so it looks like this:

I need to get all data from March 2021 to today.

I am trying to convert the Month and Year column into a date while also adding 01 as the day portion of the date (the specific day does not matter since it is not even stored in the table). I then want to compare this converted date from the table to my required date of March 2021 (‘2021-03-01). I’m not even sure if it is necessary to add the day portion to either of these as well.

I am really stuck and not sure how to do this. Maybe there is a simpler solution than converting into dates and comparing?

I’ve tried:

SELECT DATEFROMPARTS([Year], [Month], 01) AS DATE
               FROM dbo.MyData)

So now I have all the month/year columns in a date format but really not sure where to go from here.

I want to do something like

SELECT * FROM MyData
WHERE (SELECT DATEFROMPARTS([Year], [Month], 01) AS DATE
           FROM dbo.MyData)) > '2021-03-01'

Thanks in advance.

>Solution :

In your case the best solution is to combine two where condition like following.

SELECT [Data]
      ,[Month]
      ,[Year]
FROM [Test].[dbo].[Table]
WHERE ([Month] >= 3 AND [Year] = 2021) OR [Year] > 2021