Yeah but d'oh I always thought it was pronounced gee-oh-duck :doze:. Surprising what you can learn on here innit! Thanks...

Well blow me, what a fascinating critter. Bet they taste like razor clams, which are kinda like concentrated scallop. Yum!

This works for me, Ahmad - c:\CambridgePubs.xls is created - and Excel isn't installed on the server.

Either there's a mistake in your sp, there's a problem with the driver...

Not tried emu, but ostrich is very good, similar to steak but milder taste. Low cholesterol and fat so quite healthy.

Crustaceans and molluscs would be at the top of my...

Hi Ahmad

This isn't the method I use for reading / writing spreadsheets using TSQL, however I created the stored procedure using your code above and executed the following:

EXEC spExecute_ADODB_SQL

'Create...

SQLBill (3/17/2008)

---

I wasn't listing foods that COULD be eaten. Those are all things that I HAVE eaten.

Half of my Air Force career was spent in other countries. So I...

Loner (3/17/2008)

---

Exotic food - Yummmmmm.

Fried Alligator tails

Fried Conch

Fried Rattlesnake

Raw Rattlesnake

Elk

Moose

Bear

Raw Sea Urchin

Camel

Reindeer

Pigeon

Horse

Eel

Fried Octopus

Fried Squid

Grilled Squid

(note on Octopus and Squid - if you really want to have fun, stick the tentacles...

Sure Alan. If you are only updating a fixed number of columns in one table using data from another table, you can do it with a single statement, written something...

Is the same table UPDATEd in each statement? If so, the batch would run very much faster if it was written as a set-based update (UPDATE...FROM...)

Ahmad Osama (3/15/2008)

---

Yes it is, Ahmad. I'm using it for something very similar.

I can post the main stored procedures I use for this in their entirety, and fragments...

Hi Jason

I guess it does, having read a few bits and bobs about Reporting Services. We don't have it here, we're stuck on 2k for a while yet. I didn't...

Yes it is, Ahmad. I'm using it for...

It would have to be Chernobyl Chicken. Everybody knows normal chickens don't have fingers. Fish do.

Ahmad, you can do either. I'm currently using stored procedures, in a process which flows as follows:

Start with a formatted Excel template file placed in an accessible folder

Copy to...

Using Adam's sample data:

-- Top 21 TO 30 (less than one second)

SELECT TOP 10 * FROM (

SELECT TOP 30 * FROM dbo.TestData ORDER BY RowNum

) t ORDER...