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...

Yes, but you should probably read up on files and filegroups b4 you proceed.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_6epf.asp

a db can have many files in 1 filegroup . Which sql server will spread data...

What exactly are you looking for?

Sql server books online is quite extensive, and should be able to answer alot of your questions.

From Books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_07_7yw5.asp

Here's some more light reading

http://www.sql-server-performance.com/tn_stored_procedures.asp