I posted this poll because the new lead developer on my team is wanting to move everything towards sprocs. He thinks they are faster because they are precompiled and...

Craig, I don't think you understand...

All that's needed to get someone already on the system to the current version (as far as the db is concerned) is to just run...

Thanks Craig. This legacy product is not going to be changing anymore. That's why I agree we should make an importer to the current version of the ...

OK, just figured out my own problem as I read through my post again 🙂

The sql view is based off a couple of tables and the cost field was previously...

That is exactly what I need. Someone else answered my question on the microsoft replication newsgroup first though so I can only give you partial credit for the solution...

OK, either you're being repetitive (and I'm not talking about the fact that your last comment was posted twice) or I'm really missing something here... which is quite possible.

If I...

It's the other way around. The central database needs to get info from the clients. But I DON'T want the clients getting info from the central database.