Cost.

Raid 0 doesn't protect your data from a drive failure. Raid 1 requires you to have two disks for a single disk of space (or 4 for 2, etc,...

rodrigo_fabiam (8/7/2014)

---

Hi, Evil Kraig F.

There is not this colums.

It is because this that I want to show this way for the user.

Because they will have to mark what site is...

A note on HA/DR solutions, and one that's not always considered, so bear with me. Yes, I'm playing Devil's Advocate.

The most likely need for HA/DR is power outage and/or...

Try the following, then just join normally:

DECLARE @xmlInsertRecordString XML

DECLARE @iDoc INT

SET @xmlInsertRecordString = '<AllForcast>

<SESA>SESA99999</SESA>

<EmployeeName>Alex Bea</EmployeeName>

<HiringStatus>Full Time</HiringStatus>

<EmployeeGroup>HW</EmployeeGroup>

<EmployeeSub-Group>HW</EmployeeSub-Group>

<City>Burnaby</City>

<ProjectStatus>Active</ProjectStatus>

<ProjectName>AB-1</ProjectName>

<ProjectCode>411</ProjectCode>

<ProjectManager>John Doe</ProjectManager>

<Notes></Notes>

<Date>Jan 1 2016</Date>

<Effort>1</Effort>

<RecordBy>SESA123456</RecordBy>

<RecordID>4</RecordID>

</AllForcast>'

EXEC sp_xml_preparedocument @iDoc OUTPUT, @xmlInsertRecordString

SELECT

*

FROM

OPENXML( @iDoc, '//AllForcast')

WITH (EmpSubGroup VARCHAR( 50) 'EmployeeSub-Group',

SESA VARCHAR(50)...

Can you provide a sample schema and data (just the basics, don't need to go nuts) that show how your data is organized, by what keys, and if you're update...

Wow, I don't even go near that until I have some conceptual concepts of the model.

IE: Archiving usually only happens on a few tables. Security may or...

I'm not sure I'm clear on your objective. Are you simply trying to get your three columns into a single select into the same table, or have I horribly...

Excellent Setup for clarity, Rodrigo. A question. I assume this is a simplified version of the real data. Is there a column that indicates which kit each...

After your SET NOCOUNT ON;, include:

SET FMTONLY OFF;

What mechanisms do you have to determine which is the most recent file for overlaps? Is the report/pull date in the text file, do you need to extract it...

GilaMonster (8/7/2014)

---

Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would...

I think I'm having an ESL problem. Can someone stick their head into this thread and see if I'm just not asking the right question or if they can...

Probably more than one, but you're not answering the question in the manner I'm hoping to find out....

If data overlaps between two files, how do you determine who 'wins'? I realize that it's possible there shouldn't be discrepencies, but humor me. What's your merge conflict...

More information is needed. Are these files the exact same layout/format? How do you determine who 'wins' when data overlaps? Are you allowed to create/affect schema and...