Thank you all, I think I had resolved it

I want to use a variable (ex: @test-2) to replace value 'College' in LIKE

Sample:

Select * from Table_1 where Description like N'%@test%'

Naturally I will declare a variable, sample:

Declare @test-2 varchar(50)

select @test-2 = 'College'

(1) Select * from Table_1 where Description like N'%' + @test-2 + '%'

But...

Thank you very much,

I did successful

Thank you very much, I done finished

Thank you very much

Thanks for your reply, and I think user temp table is the best case.

Sample:

DECLARE @TmpIDAttachment TABLE(

IDActionPerformedAttachment INT,

IDAttachment INT)

INSERT INTO @TmpIDAttachment( IDActionPerformedAttachment ,IDAttachment)

SELECT ActionPerformedAttachment.IDActionPerformedAttachment, dbo.ActionPerformedAttachment.IDAttachment...

Thank you very much.

I have done it.

Hi every one, this is my solution.

update table_name

set theDate = dateadd(dd, datediff(dd, 0, theDate), 0)

Thank you very much, I have done it. 🙂

Very good, I have do it, thank you very much.

Thank you very much!

Thanks for support, but can you write sql select for me, please! Thank you.

Thank for your answer very much.

I have done it.

Thank you.

Thank for your answer, but result is not right, Your answer have result:

Employee Code, JobCode, FromDate

001,MRO,2011/10/10

001,MRE,2011/09/09

002,CEO,2012/01/01

002,CFO,2011/01/01

003,MG,2011/01/01

but I want result:

Employee Code, JobCode, FromDate

001,MRO,2011/10/10

002,CEO,2012/01/01

003,MG,2011/01/01

The date i want get is Max.

Please help...