Thank you very much! It worked 😀

Jason: The code works, and it returns the same result as the coalesce.

I think my boss is more concerned with the output. Therefore I can probably set those "unassigned"...

Stefan Krzywicki: Thank you for your suggestions. I have 2 IDs because I need them both to connect to other tables. Also they are both important in our business.

Also, I...

ChrisM@home: Good question! Would you have any suggestions? That's actually one that I don't know what to do...

Also,

SELECT *

FROM table1 t1

LEFT JOIN table2 t2

ON t2.ID1 = t1.ID1

OR t2.ID1 = t1.ID2

OR t2.ID2 = t1.ID1...

"Unassigned" is just a name (nvarchar) that I gave to those cells that don't have values because I didn't want to leave them as NULL. Would it create any problem?

Thank...

Thank you very much experts.

Yes I will not have both ID1 and ID2 to be null. Also, ISNULL might not be a good idea for me because ID1 is...

Hi Lowell,

It is possible to have ID1=ID2. Would I be sure to know I am joining by ID1 fist, and if not ID2 with your code?

Thank you so much for...

Hi experts,

Thank you very much for the reply!

My code looks like this:

create proc Exit_Rate_by_SBU_month_seg_reg2

@month nvarchar(200),

@Region nvarchar(255)

as

select [Exit Rate (USD)] as [Sum of Exit Rate],Region

from Exit_Rate_RR$

where Period =ISNULL(@month,Period )

and Region=isnull(@Region,Region)

group by...

Thank you very much for your suggestion. I was able to use Merge to get the result that I wanted, but I am having issues making my code into a...

Hi, on a similar note, I want to make a stored procedure where I can delete customers from a December customer table, but only those who will show up again...