I think a better way of approaching this is to remove the HTML creation from the stored procedure completely.  HTML is usually display-tier stuff.

If you created the email engine, then...

I've been part of 2 separate SAN purchases at different companies.

Went with the HP (Compaq at the time) MSA 1000 at the first place.  It was loads cheaper than the...

If you're matching the sample code from the wesite you referred to, then line 12 should look something like this:

Set objXMLDoc = Server.CreateObject("MSXML2.DOMDocument.4.0")

The MSXML2.DOMDocument.4.0 object is part of MSXML 4,...

  So near, but yet so far away

  The only thing you need to do to get your statement working is to extend...

Take a look at 'Partitioned Views' in SQL Server Books OnLine.

Basically, you'll horizontally split your big table up into smaller tables, and then build a view that selects all the...

One of your params is off (just a typo)... try changing:

[....]

<IV00101

[....]

ALTITEM2="#ALTITEM2"

to:

ALTITEM2="$ALTITEM2"

We were getting the exact same access violation error/service restart several times over the last few weeks.

We were able to trace it to some large one-shot ad-hoc OPENQUERYs...

I admit this answer doesn't directly answer your question - how to add a sequence number directly into a SELECT statement, but it does provide that result.

This may not be...

Take a look at sp_repladdcolumn in Books Online.

* Warning: Books Online gives the wrong parameters for this sp - it misses one in the middle.

You can...

Also note that you're going to cough up half your physical RAM to the OS. If your SQL box has 4GB of RAM on Win2000 Server, then applications can...