Thanks for the info folks (and for the quick replies).

I suppose I should have explained a bit more (so apologies for that).

The molder will always be called Temp. Unfortunately,...

The view takes a date given by the user and displays the data for that day. It then moves on a day and displays the data for for that...

The SELECT query I posted earlier is the one I was using last week (with the exception of an extra bit in the WHERE clause which looks like this:-

and HospitalProviderSpellNumber...

Hi Chris

I'll take all the help I can get (I'm always willing to learn).

I still don't understand why (without any changes) I could select 53 records last week and only...

@ZZartin - Done that, there doesn't seem to be a reason I can see.

@ChrisM@Work - This is something I inherited so I'm still trying to untangle...

Hi Sean

It's quite a monster select statement that normally runs quite happily (or so we thought).

You're basically correct. When the select runs on it's own for some records defined...

Hi Sean

Here's the insert statement:-

set dateformat dmy

truncate table [CDSExtractInpatients6.2].dbo.CDS_Inpatients_CDS_Feeds_Import

INSERT INTO [CDSExtractInpatients6.2].[dbo].[CDS_Inpatients_CDS_Feeds_Import]

SELECT

CdsType,

i.CdsUniqueIdentifier,

CONVERT(VARCHAR(10),CdsExtractDate,120) AS [Extract_DATE],

CONVERT(VARCHAR(10),CdsReportPeriodStartDate,120) AS [Report_Start_DATE],

CONVERT(VARCHAR(10),CdsReportPeriodEndDate,120) AS [Report_End_DATE],

CONVERT(VARCHAR(10),cdsactivitydate,120) AS [Activity_Date],

-- Updates Prime Recipients for Null & Old Pct_Codes

Case

When CdsPrimeRecipient like...

Ah, didn't know that (don't usually work with Identity columns).

For my solution, I ended up cheating.

I scripted all the columns I needed from the tables, put them into Excel and...

Hi Jeff

I did think of that, but it doesn't seem to persist.

This what I had 10 minutes ago:-

USE SystmOneData

EXEC sys.sp_MSforeachtable '

truncate table ?

begin try

set identity_insert ? on

end try

begin catch

end catch

'

insert...

Thanks Grant.

I'll drop this onto the support site as SQL DAta Compare says the tables are mapped down to field level.

Regards

Richard

I've just checked the schemas in both databases and there is only the standard dbo.

The table names are identical as I scripted them from the old databases as CREATES using...

Hi Grant

I've compared the databases using SQL data Compare and it says "195 tables or views that could not be compared".

I've transferred the database from server A to server B...

Thanks Grant, I'll have a look at it now.

To be honest, speed isn't of the essence. I've pre-warned our IT dept that I'll be moving gigabytes of data around the network and they're quite happy.

I'm looking for...

The database is currently sat at around 130GB and I can't get to a network share with that much available space.

I was also hoping to do this via the linked...