Viewing 15 posts - 376 through 390 (of 470 total)
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,...
June 19, 2015 at 8:51 am
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...
June 16, 2015 at 1:46 am
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...
May 28, 2015 at 8:55 am
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...
May 28, 2015 at 8:41 am
@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...
May 28, 2015 at 8:25 am
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...
May 28, 2015 at 7:59 am
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...
May 28, 2015 at 7:13 am
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...
April 17, 2015 at 1:36 am
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...
April 16, 2015 at 9:01 am
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
April 16, 2015 at 6:00 am
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...
April 16, 2015 at 4:58 am
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...
April 16, 2015 at 2:26 am
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...
April 15, 2015 at 9:27 am
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...
April 15, 2015 at 8:50 am
Viewing 15 posts - 376 through 390 (of 470 total)