I don't know if this is what you're asking (table being a multi-purpose word), but if the problem is recreating the spreadsheet file each time, I did this, which I...

Absolutely, although the format of the select statement is somewhat more complex than the test data would suggest.  I can't imagine trying to debug, much less construct, a complex recordset...

Jeff,

I guess I wasn't clear.  It wasn't four stored procedures producing identically structured recordsets, it was one stored procedure producing four different, but related, recordsets.

I think the reason I had...

No, we're not using SQL 2005, so CTEs are not an option.

Thanks to everyone who put some thought into this.  And even more thanks for coming up with the answer.

Mattie

No, incredibly simplified example. 

I'm rewriting a stored procedure that ended up building four different recordsets.  Crystal Reports, as far as I know, can only handle one recordset.  So my...

I can't comment on the proposed solutions, but if my email address

is in your database, it's in the format

myname@agency.state.statecode.us

I find it extremely annoying when I try to submit...

Thanks to both of you.  The only wildcard character I use with LIKE is '%', so I tend to forget the others.  Because I knew the original data fields were...

Very interesting article.  Is the only way to create multiple schedules for the same job through code, or can you do it through the Enterprise Manager interface?

Mattie

That is too much to think about on a Friday (or Monday, for that matter).  That's what I love about this forum:  not only do you usually get an answer,...

Jeff

At first I was just going to ask what

 set @i = ID = @i + 1

does, but I'd actually be curious to know what your entire process does.  Why...

Check out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_6e9e.asp

Mattie

Ray,

Thank you so much for your solution.  I find subqueries more intuitive than joins, but making the additions that I needed to your query made me think about why everything...

And it's not just Microsoft.

So many products are released with lots of bugs and vendors are slow to fix them.

But I think Microsoft started it, and now...

I don't know if there's something special about the ntext column that's causing your problem, but here's the VB6 code I use to get a list of towns in a...

When the Slashdot poster and I came over on the Mayflower, we didn't have PCs.  All we had was a mainframe.  And if we had had as many problems with...