As Lowell has already mentioned, your question does not make sense. A table being an UNORDERED set is a fundamental part of relational theory.

The only guaranteed way to order a...

Brandie Tarvin (5/19/2016)

---

Ken McKelvey (5/18/2016)

---

tcalloway (5/17/2016)

---

I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table...

tcalloway (5/17/2016)

---

I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table and then repopulate the...

SELECT * FROM TBL_metrics T

PIVOT (MAX(MetricValue) FOR Metric IN ([Torque], [BHP]) ) P

or use SELECT INTO:

SELECT <YourCols>

INTO #tbl

FROM <YourTables>

WHERE 1 = 0;

ALTER TABLE #tbl ADD PRIMARY KEY (<YourCol(s)>);

--etc

This has the advantage that datatype changes will also be picked up.

An alternative would be be have an XML column in the base table where user defined fields could be placed. This would give you the option to use indexes if...

Try splitting the MERGE out into its component INSERT, UPDATE and DELETEs.

https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/

I have just done a search and came across:

http://www.doogal.co.uk/AdministrativeAreas.php?district=E09000001

Your problem is that postcodes are designed to direct mail so postcode districts do not always tie up with geographic areas of administration.

I suspect you are going to need all...

Your description of what you want does not tie up with your results.

I agree with Sergiy, it is not complicated. Try playing with:

SELECT COALESCE(S1.PERSON, S2.PERSON) AS Person

,COALESCE(S1.STARTDATE, S2.STARTDATE) AS StartDate

,COALESCE(S1.END_DATE,...

This looks like a rather contrived example for a FULL JOIN to me.

The OP might like to look at the following article:

https://www.mssqltips.com/sqlservertip/2231/avoid-external-dependencies-in-sql-server-triggers/

Removed

There are plenty of articles on how to use Net Manager and set up an Oracle linked server.

Here is the first one I came across:

http://sqlmag.com/sql-server/connecting-sql-server-and-oracle-using-linked-servers

From the Windows menu:

Oracle - oraClient...

Configuration and Migration Tools

Net Manager

Then expand:

Oracle Net Configuration

Local

Service Naming

Highlight Service Naming and press the Green plus on the left