Your correlated subquery is not structured correctly.

As Greg Noted.

For a correlated subquery your inner query must have reference to your outer query.

Your statement should look like this I am...

Unfortunatelly debugging triggers sucks.

First of all you do not need transactions in the trigger.

Transactions are implicit in triggers if trigger fails, the transaction will rollback including the original insert/update

I removed...

Read this article, it addresses the issues you have trying to do this,.

http://www.sommarskog.se/arrays-in-sql.html

Noeld,

Yet again, almost the same answer,

Yet you beat me to the punch.

had to rewrite mine, damn time outs.

The "inserted" table is available on INSERT,UPDATE triggers

the Deleted table is available on UPDATE,DELETED triggers.

You need to make sure your triggers will handle dataSets. This trigger does not, it is...

Not trying to push you to any other site, and I'm not very familiar w/ foxpro. but perheps you can use this discussion forum to post your question.

I'm sure...

the first time you run it takes longer than subsequent times, thats usually an indication of a less than optimal query plan, but once the plan, or data gets in...

yeah, you would wanna do the same in sql.

perform dbcc showcontig on your tables.

and tables w/ less than optimally compacted indexes.

you can either rebuild the indexes, or perform dbcc...

If table is static, or updates are not Performed on variable length columns then 100% ff is fine.

But if updates are performed on variable length columns (Varchar)then a value of...

Oh man, thats a very broad question.

There is no one answer. And I find that the "Shotgun" approach to reindexing/rebuilding indexes can be problematic to the db administration specially when...

Create a staging table as noted by andrewkane17,

Look at creating a lookup.

http://www.sqldts.com/default.aspx?277

or you need to create some error handling.

The process of "Skipping" a row because it violates a rule...

I have had this issue in a previous company.

When you start coming up in the thousands of pages, (Can;t remember the actual number) Reporting services will crap out.

We went all...

No the code she showed is not VB,

Look up Case in books online.

as in your original post

Select code_field, CASE Code_Field WHEN 1 THEN Value + 100 ELSE Value - 100...

Check the application log or sql server logs for errors. It might give you more information.

What account are the sql servers running under?

a windows account, or local machine?

It should be...

Not sure, but I don't think you can use a view to "Replicate" the data thru sql server replication, it will only copy the table data.

If you are just trying...