In reviewing the code I posted, I figured out that the second cursor is not needed. I simply replaced the portion of the where clause.

Where b.ITEMCODE = @itemCode

with

Where b.ITEMCODE...

Thanks Hugo and ScottPletcher for the feedback and suggestions. I will look into "SQL Server Crosstabs" as well.

Here is a similar code that I have to fix that assigns value...

Hi Hugo,

Thanks for the feedback. The values represent six working days (days of the month) and are initially stored in a table. This can be sorted. A report is generated...

What causes the double hop authentication issue and is there a way of preventing it?

Thanks,

MC

Thanks John for the information. I will look into setting up Kerberos authentication.

Thanks,

MC

I am doing something similar with the code below.

--Declare a table to hold a list of servers you want to check

declare @list table(id int identity(1,1),Instance nvarchar(50))

--Declare a table to hold...

Hi Jeff,

It is a vendor supplied database and it came with page level locking disabled on some of the indexes.

Do what Jeff?

Both servers are running the same maintenance jobs. And yes, it is failing on the ALTER INDEX REORGANIZE. Based on fragmentation level, the index is reorganized or rebuild. It...

I found this WMI code here http://craftydba.com/?p=1114 and it works for me. I modified it for every 60 seconds and when CPU is higher than 25% for testing.

EXEC...

Thanks for the information. I also found what I was looking for in the Performance Dashboard IO report.

Thanks,

MC

I am using distributed queries, that is a select statement that joins between the local and remote server using four part naming convention.

Ran it again and it took 00:01.29 to complete. There is a few warning and table scan in the plan.

Type conversion in expression (CONVERT(char(8),[Data_04].[dbo].[Rpt_FiscalCalendar].[BPCSSDate],0)) may affect "CardinalityEstimate" in query plan...

Hi mister.magoo Kristen-173977,

Thanks for the suggestions. I checked permissions and everything is okay there. Collation is the same on old and new server, include the column collations. Local DB tables...