You haven't posted any table DDL or constraint definitions, nor the DELETE statement itself, so it's tough to say ..

>>and i am deleting records from store table whose flag is...

It runs sometimes and not others because it is data dependant.

>>DELETE statement conflicted with TABLE REFERENCE constraint 'FK_employeeHeader_storeemp'

Depending on what table is at the foreign key side of FK_employeeHeader_storeemp  and depending...

This is not a DTS issue, it's aproblem with the DELETE statement trying to delete records that are still referenced by foreign keys in other tables.

You either need to implement...

What is  dbo.vw_employee_days.calendar_days  ?

We don't have the view definition, and it's tough to know what to make of a WHERE that appears to compare something that is a number of...

Ever heard of Y2K ? Why not use a code in the YYYY-MM format to avoid ambiguity ? Or use a real date...

I generally just use the microsoft.public.* newsgroups.

Either via their Google archive:

http://groups.google.com/group/microsoft.public.dotnet.languages.vb?lnk=lr

Or directly through a news reader client. I've found this to be a great resource, with frequent contributions from...

Fair enough, but you see the general point ? You can't post a whole whack of code and say "it's wrong" without posting what the requirements are and what the...

>>I should be getting -165 for rmstranamt in the end, not -265 which I'm getting now.  Somewhere it's skipping 100

No-one here can assist until you explain why.

According to your query...

NOT EXISTS instead of NOT IN:

SELECT dbname, dbid, dbservername,  dbcreate

FROM AuditSYSDB_DailyRefresh As R

WHERE NOT EXISTS (

  SELECT *

  FROM AuditSYSDB_Static  As S

  WHERE S.dbid = R.dbid

  AND     S.dbname=R.dbname

)

You can't use a cursor in a derived table, regardless of whether you have atemp table pre-built. And it's a good thing too, because the performance would be hideous.

It all...

>>That's more or less what Joe Nakanishi suggested, isn't it?

Nope. That suggestion was for 2 CONVERT()'s in the WHERE, which precludes index usage.

>>"it might be worth setting 2 variables to...

When you run a large update like this, it requires log space. If your logfile isn't large enough, it may auto-grow. Auto-growing takes time, and depending on your auto-grow parameters...

>>LEFT JOIN Currency C on C.id = t.CurrencyID

>>WHERE c. is not null

That is equivalent to:

INNER JOIN Currency C on C.id = t.CurrencyID

... with no need for a WHERE. Might change the...

Unfortunately the /3GB switch only works on the Win2000 Server OS on Advanced and DataCenter versions. it is not supported on Standard.

http://support.microsoft.com/kb/291988/

Note, the answer to this and many other...

Not wierd, just working as per the original requirements - which were to strip non-numerics from the beginning of the string.

There was nothing in the original poster's question or the...