Is the phone data stored in a separate table ? Can you give DDL of the tables involved ?

Is this what you are looking for -

SELECT getdate()

Your cursor declaration needs to select a single column - EmailId. You cannot select all column into a single variable.

Leave the clustered index. You may need to add an index on the month column.

Also the log size will grow. This might give you some more insight.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=222360

Couple of things to check:

What index on there on the table. Index would be rebuilt as deletion takes places which would slow the process. An option to consider would be...

SELECT t.FKID, MAX(t.Item) Item, t.ATime

FROM #Test t INNER JOIN (

select FKID,  MAX(ATime) ATime FROM #Test

GROUP BY FKID ) t1 ON t.FKID = t1.FKID AND t.[ATime] = t1.[ATime]

GROUP BY t.[FKID], t.[ATime]

MAX(CASE WHEN CL.Category NOT IN ('A', 'B', 'C', 'N', 'O') THEN 'Z' ELSE '' END) AS 'Category Z'

DECLARE @tbl TABLE (Pole_ID int, Attachment_ID int, dt datetime)

INSERT INTO @tbl

SELECT 1,                101,                       '2008-01-01'

UNION

SELECT 1,                102,                       '2008-01-01'

UNION

SELECT 2,                103,                       NULL

UNION

SELECT 2,                104,                       '2008-01-01'

UNION

SELECT 3,                105,                       '2008-01-01'...

A good article by Brian kelley

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritythedb_executorrole.asp

This would get you started.

UPDATE

#tbls SET tbl_name = REPLACE(REPLACE(REPLACE(tbl_name,

You can do a update before the select

UPDATE

#tbls SET tbl_name = REPLACE(tbl_name,