then make sure the group by is still there. 🙂

Just take the rowid out of the list. You don't want the details, you just want to get the calculation.

LOL. :blush: I was not aware that you could do that.

Back to your situation, did it in fact update the underlying data?

I am really confused by a lot of things here. First of all you can't put a trigger on a view. You can't insert or update a view. You can...

Please don't create new threads for new answers to your existing question. It just fragments the answers.

Reply to the original post here

It may very well be an IIS execution timeout given the amount of data and the time it takes since this probably called during a post back. If the original...

I see a number of problems here. You are wrapping your variables with '@variablename'. That will not do what you think. Secondly and most importantly I don't see why you...

Try this link.

I don't think it can be. How could sql server "rollback" previous write to an external location?

Can you chunk this out into batches? It would probably make it run a ton faster if you handle this in batches instead of all at once. I don't know...

virender.singh (4/21/2011)

---

i am having a strange problem while fetching incremental data from live transaction table.

this table sufferes a huge insert commands.

I am fetching incremental records with row_id

query is...

Not to mention that most servers have the time changed twice a year. Daylight saving time. :w00t:

I guess it depends. Is this process failing normal or critical? What this message is...

There is no "best practice" or "generic should always have" list of constraints. The application, ddl and business rules as well as db knowledge go into this. There is no...

ChrisM@home (4/26/2011)

---

Put a PRINT before the INSERT statement, like this:

PRINT @l_sql_string

insert into TSTDB.dbo.CAPACITY...

The last query printed will be the one which fails. Copy and paste it into a new query...