Please provide a CREATE TABLE statement for the dbo.LogExtract table.  You can script that out using SSMS.   We have no way to test your code to see what's going on...

Erland,

Thanks so much for the detailed specification what will require the mode changes.  In my case, it was an INSERT into a table with clustered index, where the table had...

FYI, the final key restore was about 5 seconds in duration.  I'd still love to know why the initial attempt to restore the key just hung up and sat there...

Well, ... the problem has been solved.   Apparently, if you don't reconfigure SSRS's service account using the Reporting Services Configuration Tool, SSRS never thinks that the account has changed.   The...

Okay, folks... I finally have this working.   I was actually able to demonstrate the working report today and I'm a very happy camper.   It's been a rather long hard road...

Well, this has been an interesting exercise...   I've learned a couple of things, and hope some of this is useful, as my troubles are not yet over.   I'm communicating with...

Here's the updated VB Code:

    Private Sub GetImpactButton_Click(sender As Object, e As EventArgs) Handles GetImpactButton.Click

        Dim VendorID...

Well, folks, it seems I've had a "dumb" problem, in that the server URL was not set correctly, but I only discovered that after having to scour the web for...

All,

My query is not going to perform well, but it will get accurate results for the existing data, in which I included the m6 example and where I changed the...

Whatever you have there, it's not valid XML.  You'll have to fix that problem first.

Well,

Leave it to Mr. Celko to be a jerk about this.  Admittedly, there are some problems with this setup, and the performance isn't going to be great.  Also, it's not...

Try the following:

ISNULL(TOTAL_BILL_AMT_PRD) == True ? (DT_NUMERIC,1,0) NULL : ((TOTAL_BILL_AMT_PRD - TOTAL_BILL_AMT) == 0 ? 1 : 0)

Well,

No surprises from Mr. Celko... he's as rude and insensitive as ever.   Maybe even a new low with accusing you of the equivalent of a Hansel and Gretel Witch crime. ...

USE master;
GO

SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO

CREATE TABLE #ChargeDataTemp (
Id int NOT NULL,
AssetReference varchar(50) NOT NULL,
RentType varchar(100) NOT NULL,
EffectiveFromDate datetime NOT NULL,
EffectiveToDate datetime NULL
);
INSERT INTO #ChargeDataTemp (Id, AssetReference,...

How about the following, using LAG:

USE master;

GO

SET ANSI_NULLS ON;

GO

SET QUOTED_IDENTIFIER ON;

GO

CREATE TABLE #ChargeDataTemp (

Id int NOT NULL,

AssetReference varchar(50) NOT NULL,

RentType varchar(100) NOT NULL,

EffectiveFromDate datetime NOT NULL,

EffectiveToDate datetime NULL

);

INSERT INTO #ChargeDataTemp...