If I read correctly what you didn't write, I think you're trying to add rows with ids N+1, N+2, etc to a table with N records in it.

You can do...

A couple of comments:

Using OpenQuery causes the entire resultset to be shipped across the network.

If it is large, then this will take some time.

For example

Select...

Execute only returns status information for the last command presented to it. You need to execute each insert statement separately, testing @@error after each.

Let me try to explain what's going on in a little more detail.

Using the northwind database query

SELECT EmployeeID

FROM Orders

GROUP BY EmployeeID

returns 9 rows (Employee ids 1, 2, ... 8,...

Been playing around with the SQL above.

The reason the original SQL returns 0, 0 is because hidden in the query is a cross join where one of the queries returns...

Looks like you're trying to execute a table name as a stored procedure:

i.e. something like

Set ocmd = Server.CreateObject("AODB.Command")

...

ocmd.commandtext = "table_name"

ocmd.commandtype = adcmdstoredproc

ocmd.execute

This will fail with an error similar to the...

I'd use both options, especially if the reports are essentially static:

XML+XSLT to generate a HTML page, which you then serve to the client. This works well if you can pre-generate...

Try

Set DateFormat dmy

Declare @dt DateTime

Set @dt = '2/09/2005 12:42:32'

select convert(char(10), @dt, 103), convert(char(8), @dt, 108)

Works for me.

Regards

Otto

Gentlemen,

Thanks for the comments.

I don't think RGR'us' solution meets the needs despite being neat code, as usual.

The problem setting was:

"I need to pass a StartDate parameter and count of businessdays....

after the detective work and name calling , back to work.

How's about:

Declare @d datetime

Declare @businessDays int

Declare @cnt int

set @d = '2004/09/18' --...

I'm struggling.

I tried connecting to MSDE with Access (I have version XP/2002) on my test box using both a data project (.adp) and an ODBC connection in a MS...

Phill,

Thanks for the reply.

We can't use SQL/Server/64bit as we're running on opterons (x86 architecture) and not itaniums. We are using Windows 2003 Enterprise 64 Bit.

The little documentation I found trawling...

How does Windows 2003/64 bit fit into the picture? We're running on opteron (not itanium) boxes with 32GB ram, but the most I'm able to allocate to sql/server is 4GB....

Try SQL Server Query Performance Tuning Distilled by Sajal Dam. It's published by Apress ISBN 1-59059-421-5.

Good reason not to use SP_:

If you do SQL/Server will look for the sproc in Master, and then your user database if it doesn't find it even if you qualify...