Thanks for Reply .. I have solved that problem At early i posted here..

THANKS FOR YOUR REPLY..................THANKS SO MUCHHHH

I don't know whats your correct expectation But What I have , i given here

---if u want to get last date of current month---

SELECT DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+1,...

But, I don't know OS command like how to change the Date time of server machine...

do u have a IDEA?

Please send that

I can't understands whats your way.. Can u tell me clearly..

(Only for Mohit)

Hello Mohit,

If u don't Know Please dont reply to other request,

I done decryption.. ok

...

[font="Arial"]Please don't waste your time I got a Solution.. Thanks for Reply[/font]

can u give me a small example like create view and Index?

please..

I cant understand your expectation,

anyhow use this example

select id,sum(x) from table_name group by id

thanks but i did through the query of

kill sp_id

As per our sql_central articles

U can use DDl trigger for maintains the table activity

use DB_name

CREATE TABLE create_table_log

( create_time datetime

, DB_User nvarchar(100)

...

Hi I have a small example for Duplicate avoids Ok

...

Declare @id int,@name varchar (50),@cnt int,@roll_no numeric

Declare getall cursor local static For

Select count (1), id, name, roll_no

from t_name1 (nolock)

group by id,...

My hearty thanks to Chris Morris