thanks for reply.

I found this in my event viewer:

-- ========================================================

Event Type:Error

Event Source:ClusDisk

Event Category:None

Event ID:1209

Date:11/18/2008

Time:12:46:08 AM

User:N/A

Computer:ServerName_of_PassiveNode

Description:

Cluster service is requesting a bus reset for device \Device\ClusDisk0.

For more information, see Help and...

I have similar problem in my database.

I need to purge 10 mil record every month. My table size is 233 mil.

I can move the data to a temp table first....

I thought DTS can allow you to specify what you want to do if failed?

From the menu, choose WorkFlow --> On Failure

Hope this help.

I think your tabledetails is getting bigger and bigger from time to time. Do you have index for replyavm column?

Instead of running  this:

Select top 1 @PropertyIDBuffer = sa_property_id from tabledetails...

oh yeah, there is a comma missing after Solmon_Bill.

Hi, I think you are trying to sum the BILLING_TIME intead of billing amount.

If it is a FLOAT value, you should not have problem to CAST it.

Thanks.

Can you post a sample table structure?

Leo

I think you can check a few things:

1. Lock

2. Profiler

3. Execution Plan

It depends on what is in your stored proc.

Leo

Can you try this?

Select t.columnA, t.columnB from subquery1 t where not exists (select 1 from subquery2 t1 where t.columnA = t1.columnA

and t.columnB = t1.columnB)

Would you get what you want?

Leo

i am not sure this will help. your post is tooo long.

How if you change:

SELECT     TOP 1 lastmodifiedtime

FROM          dbo.tbl_seedDisposition sd1

WHERE      sd1.seedname = sd.seedname

ORDER...

I am sure you can do better than me.

Hi, there is something that I am not clear. In your Rates table, do you store data like this?

projID     empID     rate

A                         100

A            001         50

B            002         150

-------------------------

Cost for project A =...

Hi friend,

try this:

create table products(

 product_id varchar(25),

 qty int

)

create table invoice_product(

 product_id varchar(25),

 qty int

)

insert into products

select 'car', 10

insert into products

select 'boat', 10

insert into products

select 'bike', 10

insert...

how if you put the date range in your join and make your call to Table1 become a derived table?

is it still using PK or InvoiceDate index?

Thanks.

Leo

In your case, select id, sum(point) will not work.

I am wondering whether you want a logic to sum(point) regardless id.

From the data above, what I can see is you may...