You're right. Temporary tables work; table variables do not. That's what I get for inferring without testing first.

Not directly. You can load the results returned by a stored procedure into a table, including temporary tables or table variables if necessary, which can then be used in a...

I don't know if this would work or not, since I've not had the chance or available equipment to test it. It looks to me like SQL Mail just uses...

The best I have come up with is to create a schema for the data and run the document through an external validating parser, but this still has to happen...

I'm not aware of anything in SS2000 for that. I usually validate in the application while I'm building the XML doc before passing it to the database.

I don't believe the LIMIT keyword is part of SQL Server.

This is a cross-post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=326345

The web user for your application (generally the anonymous IUSR_[machine name] account) needs write-access to your .mdb file.

It's there. Look at the string for trusted connections under OLE DB.

You asked "Is there a way to stop the SP from running through the other statements if one IF statement is sastisfied?"

Vladan's post answered that. (Though I have the same...

I would add a case statement to Sergiy's query to handle possible division by zero.

SELECT Text, SUM(answered ) as answered , SUM(correct) as correct, 
   (CASE 
 ...

I don't have access to that system anymore, and not knowing whether you are using Outlook/Exchange, GroupWise, etc., I don't know how applicable the code would be anyway.

I put a...

Just a thought (and maybe not a good one)....

What if you use either of Kathi's solutions above (I am thinking the latter would really need to be a FULL OUTER...

Ram's solution works as long as all values of EmailID for a particular project are contiguous. I think this will work regardless:

SELECT EmailID, ProjID, EmailStatus
FROM <TableName>
WHERE EmailID IN (
SELECT...

I did this for a project once. The data file we needed was distributed via internal e-mail and they would not consider FTP or a networked storage location. I had...