Also keep in mind that what you've asked for will only set the TreatyID values for existing rows.  You will need to also take care of populating the TreatyID for...

Hey Jeff, I agree with what you are saying about not always creating clustered indexes on highly transactional tables, but I'd like your opinion on how you keep the fragmentation...

I'll have to second Bert's post.  While I did not have a specific 'hero' growing up, I've always had strong feelings towards our armed forces and the sacrifices they've made...

run sp_who2 and look at the CPU time column to see which SPID is responsible for the highest CPU usage.  Also, look at the Windows task manager to see if...

I would suggest either posting your stored procedure or profiling the execution and finding out where the problem lies.  Your procedure call does not appear to be the culprit here. 

Try removing the comma. For example:

declare @ServerName varchar(50)

declare @v1 int

set @ServerName = 'ALT1.clt_dev.dbo.proc_i_ICTG_New_Request'

exec @v1 = @ServerName @v_benmobno = "123445", @v_AcNo ="12144", @c_Cur = "AED"

select @v1

declare @table table (

    productid nvarchar(20),

    [Date] nvarchar(10) ,

    Qty int,

    userid nvarchar(20)

)

insert into @table

select '100A', '2006-07-16', 10, 'fromnotepad' union all

select '100A', '1/1/2006', 10, 'excelimport' union all

select '100A', '1/1/2006',...

"The table sysusers is editable"

Only because you've enabled updates to system tables.  Generally, you should not be updating system tables directly.  If you are looking for a way to move...

I suppose you could be correct David.  I am assuming that Best has already populated the temp table just because Best is asking for an update statement, but the fact...

Well, if you are using DTS, you can create an 'Execute Package' task on one server that will execute a DTS package on another server.  What is it that your...

If you're going to backup using UNC paths or copying the file, you'll need to have a trust relationship setup between domains.  You'll need a Domain Administrator to do this...

Well, if your tables are related on PolicyNumber,SeriesCode,TableCode, then your UPDATE would look like:

UPDATE t

SET t.EffectiveDate = ge.EffectiveDate

FROM #tmp t

    INNER JOIN GE_Claim ge

    ON t.PolicyNumber = ge.PolicyNumber

        and...

Well you should still be able to use Robert's CROSS JOIN method, but call your function instead of his RAND(CHECKSUM(NEWID())).  The CROSS JOIN in his example is the mechanism to...

" iam updating temp table.

both tables have PolicyNumber,SeriesCode,TableCode.EffectiveDate

i just want to update Effective date column in temp table"

You want to update the temp table EffectiveDate column with what value? ...

Another very similar post by you: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=328266

You'd be better served if you provided enough information to answer your question.