Hi and thanks for taking the time to reply to my intial question.

RAW Disk Mappings are indeed a hinderance with VMware and Microsoft clustering. From what I have read...

Example of table and sample data.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Exchange_Rate_History](

[Currency_Key] [char](3) NOT NULL,

[Effective_Date] [datetime] NOT NULL,

...

Folks - Thanks for this.

Same old "So near and yet so far"....

Again - Thanks for taking the time to work on this as it was driving...

Thanks for the reply.

Tried running

BULK INSERT TEST.dbo.NA_BANKACCTTYPELOOKUP

FROM 'C:\TEST\WXBankAcctType.txt'

WITH

(

FIELDTERMINATOR ='|',

...

Can you supply the servername and the instance name if it is not the default instance on the server. This will help us format the SQLCMD parameters you should...

Everyone thanks for your help / guidance on this one. Looks like I have managed to get the desired results.

Unfortunately the design is not the best and as you...

--#1

CREATE VIEW [dbo].[Address_Member_View]

AS

SELECT * from address

--WHERE address_key LIKE '%Member'

WHERE Address_Provider = 'Member'

--#2

CREATE ...

Views defined as follows:

--MEMBER_VIEW

CREATEVIEW [dbo].[Member_View]

AS

SELECT

Member_key,

date_modified,

Person_No,

CASE WHEN CIGNA_Member = 'Y' THEN 'Confidential'

ELSE Member_Name

ENDAS Member_Name,

Subscriber_No,

Member_Add_Month,

Member_Add_Year,

Country_code,

Country_Name,

Relationship_Code,

Date_of_Birth,

Gender,

Smoker_flag,

Nationality,

Nationality_Country_Name,

Country_of_Residency,

Country_of_Residency_Name,

Subscriber_Flag,

Date_Record_Loaded,...

TABLE STRUCTURES that make up the VIEWS:

-- ELIGIBILITY TABLE:

CREATE TABLE [dbo].[Eligibility](

[Group_Code] [varchar](6) NOT NULL,

[Product_Key] [varchar](4) NOT NULL,

[Subscriber_No] [varchar](9) NOT NULL,

[Person_No] [varchar](2) NOT NULL,

[Eligibility_From_Date] [datetime] NOT NULL,

[Eligibility_To_Date] [datetime] NULL,

[Plan_Code] [varchar](3) NOT...

As i mentioned in my initial posting there is only 1 common field I can join these 3 tables on "Environment_Key".

Ran the following code to give me an idea how many rows on each table have the environment_key 'DL' which is used for joining the 3 tables together to get...

Do you have any Triggers on the table in question for the inserts / update ?

Folks - many thanks for taking the time to reply and comment accordingly. As I mentioned previously I have not done any of this in the past so apologies...

Here's some code to build tables and sample data. This generates the aforementioned results. I then need to be able to add other XML fields as per my...

Here's the code I've ran so far...I'll post table defs and sample data shortly...

DROP TABLE #CurrencyList

go

DROP Table #Effective_Date

go

CREATE TABLE #CurrencyList(CurrencyList_Date datetime NOT NULL)

SELECT DISTINCT

Effective_Date

INTO#Effective_Date

FROMdbo.Exchange_Rate_History

SELECT

CurrencyRatesInstance.Effective_dateAS "CurrencyRatesInstance/Date",

CurrencyList.CurrencyList_Date ...