Where and how do you do step 2

I'm not sure that helps me.

If you notice in my example the 3rd column header has double quotes but the data for column 3 does not.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=185751

replace

'%@name%'

with

'%' + @name + '%'

Replace

LEFT JOIN (

SELECT

msp_flag,

bc_code

...

DECLARE @Blocksize AS BIGINT = 5000,

@pagenum AS BIGINT = 0,

@ROWCNT AS BIGINT = 1;

While @ROWCNT > 0

BEGIN

Update ceb set CEB.new_WCDSCreatedOn = D.CreateDate

from contactextensionbase ceb join

(SELECT IndividualID,CreateDate

from #tmpIndividualCreateDates

order by...