Viewing 15 posts - 16 through 30 (of 34 total)
Hi Susannah,
I check it... in the meantime might you post the call that you use for the stored procedure ?
Thanks
Sergio
April 1, 2009 at 7:27 am
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...
March 27, 2009 at 1:23 am
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,
...
January 2, 2009 at 2:57 pm
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
August 1, 2008 at 1:15 am
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...
July 24, 2008 at 9:03 am
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...
July 9, 2008 at 11:40 am
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...
July 7, 2008 at 3:32 am
Hi,
DBCC INPUTBUFFER (PID) should interrogate sysprocesses. Take a look also to function ::fn_get_sql() at this post.
Bye
Sergio
July 4, 2008 at 11:11 am
We found the solution :D, if you want to know the final: read this article (soon write the English translation :)).
Thanks to all,
Bye
July 4, 2008 at 10:03 am
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...
June 12, 2008 at 11:02 am
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...
June 12, 2008 at 10:18 am
Hi Rajesh,
try with this query:
[font="Courier New"]Select
T.*
From
@t AS T
Join
(
Select
Value
From
@t
...
June 6, 2008 at 7:47 am
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
...
May 27, 2008 at 3:08 pm
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...
May 27, 2008 at 3:47 am
Viewing 15 posts - 16 through 30 (of 34 total)