Hi Susannah,

I check it... in the meantime might you post the call that you use for the stored procedure ?

Thanks

Sergio

Hi susannah,

I am very happy that the solution will be helpful.

In addition, I recommend you to use the latest version of the stored procedure [dbo]. [USP_DMO_Refresh_Excel_Pivot_Table] that you can find...

Thanks for your suggestions.

After some tests, I found the following solution:

[font="Courier New"]/* Create stored procedure */

create procedure [dbo].[USP_DMO_Refresh_Excel_Pivot_Table]

(@FileName varchar(512),

@WorksheetIndex int,

@PivotTableName varchar(100),

@Debug tinyint)

as

begin

declare @hr int,

...

Hello wthigo,

before executing the stored procedures you've connected to the database ?

For example:

[font="Comic Sans MS"]USE TestDB

EXEC USP_ExecReorgRebuildIndex 'TestDB', 0, -1, 10[/font]

Bye

Sergio

OK, and happy holidays 🙂 .

Sergio

Hi Dirk,

which version of SQL Server are you using ?

This script[/url] uses the DMV sys.dm_db_index_physical_stats usable only by the 2005 version of SQL Server.

To defragment indexes with SQL Server 2000...

Sorry, there was a small bug in step 5 (subtract the result obtained in paragraph 4. by multiple of 10 higher).

The local variable [font="Courier New"]@i[/font] must start from zero and...

The example queries (in the first post of this thread) run on two connections (first connection with ANSI_NULLS = ON and second connection with ANSI_NULLS=OFF) are no longer equivalent if...

Hi,

DBCC INPUTBUFFER (PID) should interrogate sysprocesses. Take a look also to function ::fn_get_sql() at this post.

Bye

Sergio

We found the solution :D, if you want to know the final: read this article (soon write the English translation :)).

Thanks to all,

Bye

I attach the word document that contains the definition of the stored procedures USP_DMOExportToExcel that allows you to export the result set of a query on Excel.

Call for example:

With SQL...

Thanks for your answer.

I added the conditions IS NOT NULL on the fields and trafficking of I/O has decreased drastically, but I still do not understand the difference in execution...

Hi Rajesh,

try with this query:

[font="Courier New"]Select

T.*

From

@t AS T

Join

(

Select

Value

From

@t

...

Hi,

here's a possible solution:

[font="Courier New"]if object_id('TabDate') is not null

drop table TabDate

go

create table TabDate

(birthmonth int,

birthday int,

birthyear int)

go

insert into TabDate(birthmonth, birthday, birthyear) values (06, 19, 1975)

go

select

...

Hello rbarryyoung,

this is the approach that I used to solve the problem:

1) Creating a stored procedures can accept as a parameter the name of temporary table (relative to the...