Please can you help me with the following query in MSSQL?

I will try and explain as best I can.

First keep in mind that all the columns in MyTable needs to be reported in the output report even though only three columns will be used to compare the data.

I have a table with MbrNo, DepCode and PracticeNo, now the Practice could have consulted with more than one MbrNo and with more than one DepCode from the same MbrNo. I require the Member/Dependent Count to be populated in an additional column whereby it reflects the amount of Members the doctor consulted. However the DepCode should also be considered. If the doctor consulted with 1 MbrNo but 3 different Dependent the count should then be 3, as the MbrNo is applicable to all 3 dependent and thus the practice consulted with three people. 

---

MY TABLE
--------

```
    MbrNo | DepCode | PracticeNo | Adress | Email | TelNo
    123        01         A          XY      XY       XY
    1234       00         B          XY      XY       XY
    1234       00         B          XY      XY       XY
    1245       00         C          XY      XY       XY
    123        02         A          XY      XY       XY
    1234       02         B          XY      XY       XY
    1233       01         A          XY      XY       XY
    1233       00         B          XY      XY       XY

```

OUTPUT REPORT
-------------

```
    MbrNo | DepCode | PracticeNo | Adress | Email | TelNo | MemberCount
    123        01         A          XY      XY      XY          3
    1234       00         B          XY      XY      XY          3 
    1234       00         B          XY      XY      XY          3
    1245       00         C          XY      XY      XY          1
    123        02         A          XY      XY      XY          3 
    1234       02         B          XY      XY      XY          3
    1233       01         A          XY      XY      XY          3
    1233       00         B          XY      XY      XY          3

```

Provider B = 3 MemberCount because the Provider Consulted the same member X 2 and the calculation it to confirm the People count. Also note that it should not be placed in order as my previous query that forms part of this query already orders the details accordingly. 

I honestly have no idea how to spec this to get the desired results.

Hope the above makes sense and that someone can help me with it.

Thank you kindly.