HELLO ALL EXPERTS,

Would you please help me with the issues that I have posted above?

I will take all experts'opinions.

Thank You in advances

Hello ALL,

Would you please tell me what I should do for the issues that I have posted? I will take all advices from all of the experts out there.

Thank...

Hello Square,

Thanks for the respond. I am confused about your answers, because I'm new to this, would you please explain to where should I use ISNULL()? I thought I did...

Hello Robert,

How are you doing? First, thank you so much for the tips (links). I got stuck in a small issue (I guess) and here is my script that I...

Hi John

The outlook is what I wish to display but somehow I mistyped the figure for the "TotalCleared" column, it should be added up and equal BOCleared and CTCLeared

TotalCleared...

Hi Robert,

Thanks for the comments, but each field name is different from the other.

BOCLEARED BOCLEAREDDATE CTCLEARED CTCLEAREDDATE TOTALCLEARED CLEAREDDATE

I wish to merge them like the outlook shown...

Hi ALL,

I have created each view for each office such BO and CT then I wrote a script for totalcleared and this totalcleared is combined of BO and CT.

Now,...

Hi There

the outlook(lay out of the column headers) is what I wish it to be. But sorry for the mistyping of the figure in the "TotalCleared" column

TotalCleared ClearedDate

...

Dear ALL Experts out there,

Would you please help me on the topic that I posted. I would like to have as many experts opionions as possible.

Thank you so much...

Hi Peso,

here are the scripts for BO, CT, and TotalCleared, respectively.

WITH CTE AS (SELECT ISNULL(a.DECleared, 0) + ISNULL(b.SomaticMCCleared, 0) + ISNULL(c.PsycMCCleared, 0) + ISNULL(d.DESecondCleared, 0)

...