How to compare 2 columns values in Sql Server table [duplicate]

Question

I have below table with 3 columns in sql server.I want to compare [yearmonth] with a concatenation of [year] and [month] columns. like... select count(*) from table where [yearmonth]=concat([year],[month]).

Catch is here that whenever we have a [month] value of single-digit we have to add 0 as a prefix in it. like for the first record, it should become 05 instead of 5 while comparing.so final count of select count(*) from table where [yearmonth]=concat([year],[month]) should be 3

Data type of [yearmonth] is nvarchar

Data type of [year] is nvarchar

Data type of[month] is int

What is your actual question here? How to get '202105' from the int values 2021 and 5? — Thom A
– Thom A ♦, Commented Aug 25, 2021 at 14:11
Does this answer your question? Formatting Numbers by padding with leading zeros in SQL Server — Thom A
– Thom A ♦, Commented Aug 25, 2021 at 14:11
Hi @Larnu..Please check the below solution in the thread..this is i what i wanted..Thanks for looking into it. — Yogee yadav
– Yogee yadav, Commented Aug 25, 2021 at 14:34
What types are the columns? If they are int then you can do year * 100 + month — Charlieface
– Charlieface, Commented Aug 25, 2021 at 17:00

Mohammad Akbari · Accepted Answer · 2021-08-25 14:16:55Z

1

Use the following code:

SELECT COUNT(*) FROM table WHERE [yearmonth]= CONCAT([year], RIGHT('00' + CAST([month] AS VARCHAR(2)), 2))

answered Aug 25, 2021 at 14:16

Mohammad Akbari

4,8146 gold badges52 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compare 2 columns values in Sql Server table [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related