How about scripting the stored procedures from the old database (Enterprise Manager -> Objects -> Generate SQL Scripts -> etc.), and then pull the script into Query Analyzer and select...

Look at CASE in SQL Books. With CASE you process by set and still set different columns to values depending on complex evaluations of columns in one or more...

Excellent suggestion. Will check tomorrow at my client. I don't get the problem, but they do, and I'm usually (always) more current than they are. Thanks!

Sorry for the flubbed reply. I'm new at this board. Anyway, I have not had the problem with SQL Server 7, but maybe because I have a newer...

quote:

---

Have no experience with it. Does it work ok with SQL7? You might try setting the compatability back to 70 if so.

Andy