I got this helpful response on another list. Hope it helps others.

---

There is an interesting story behind all this. First read kb287515 @

http://support.microsoft.com/?id=287515

This type of query...

SQL Server 7

Oddly this works also:

SET @vcValue = 'We sell '

SELECT @vcValue = @vcValue + a.CategoryName + ', ' FROM Categories a WHERE a.CategoryID IN (SELECT * FROM #temp) ORDER BY a.CategoryID...

I support what the article recommends.

You have to be careful using WA for internet and intranet apps because the user that IIS and now ASP.Net run under is sometimes a...

The authors tested MS's beta 1 and beta 2 JDBC versions and both had problems.