I think paul last Query and my Query both are same.

Select U.* from dbo.Users U with (Nolock)

Join (Select username, MAX(GWP) MGWP from dbo.Users with (Nolock)

Group by username) as A

on...

what is this? they are askiing Q like Is Filestream Encrypted?

I said No.

They are saying Correct answer is Yes.

and explaination is saying that Filestream Data are not enctrypted.

That is...

you can create trigger like this for your purpose

create trigger TR_MyTable_I_U

on dbo.MyTable

for INSERT, UPDATE

as

begin

set nocount on;

update dbo.MyTable

set Col3 = M.Col4

FROM dbo.MyTable M

join inserted I on I.col1= M.Col1 and I.Col2= M.Col2...

I am not sure but it is comparing single character's ascii value from each variable one by one from lefttoright and when ever it will get greater result it will...

from your Table Name I think that your Name table is master table and rest of the others are depandant on them. is it the case than

you can write like...