In sql server how to compare two columns values are equal or not equal?Friends,
I have one table in my sql server. the table name is Inward_Material. The table have two columns namely ID, REF_ID. The columns have some value like
I want to calculate sum if ID and REF_ID are equal otherwise not calculate sum. So my doubt is how to compare two columns values are equal or not equal?