seems like to a be a practiced way.

Thank you very much 🙂

Dear Ali

thanks for participating to this discussion but the challenge is about to first identify the troubles that may arise and second to log any bad things happens to it....

I guess I found what I need.

Thank you.

Indexes are never triggered.

You might provide more information to get results.

This might work better

This is an easy table to show how to solve the issue :

Create TableCustomer

(

IdintNot NullIdentity,

TitlenVarChar(80)Not Null,

ConstraintIX_Customer_TitleUniqueNonClustered(Title),

ConstraintPK_CustomerPrimary Key(Id)

)

And here is the my solution :

SelectCustomer2.[Name],

Customer2.Family,

Result.Kount

From(

SelectCustomer.[Name]As [Name],

Customer.FamilyAs Family,

Count(*)As Kount

FromCustomer...