Database

SELECT DISTINCT SiteName INTO NewSites FROM Sites;
TRNCATE TABLE Sites;
INSERT INTO Sites SELECT * FROM NewSites;
DROP TABLE NewSites;

DisIsHoody wrote:

This will eliminate duplicate client names, site names, etc. However there are over 10,000 records in the database, and to go through this manually would take a long time, as it seems there is no way to start it and finish it at a later time. Does anyone have an recommendation on how I can go about making this flat database into a relational database relatively easily?

vanikanc wrote:

WE need to name the new database server as our current one

vanikanc wrote:

Can we have two such database servers at a given time?

vanikanc wrote:

How can we migrate from one server to another with no lag time, since it is the
production server constantly collecting data

select p.id
      ,c.id
      , .....
  from some_table p
      ,some_table c
 where p.id = c.parent_id_field
 sort by p.id, c.id

Ali Al Omairi(Abu AlHassan) wrote:

i can't tie a user hands.

CREATE TABLE #data
(
	ID INT NOT NULL,
	PID INT NULL,
	VALUE VARCHAR(20) NOT NULL
);

INSERT INTO #data
(ID, PID, VALUE)
VALUES
(1, NULL, 'node 1'),
(4, 1, 'node 1/1'),
(6, 4, 'node 1/1/1'),
(5, 1, 'node 1/2'),
(7, 1, 'node 1/3'),
(2, NULL, 'node 2'),
(3, NULL, 'node 3'),
(8, 3, 'node 3/1');

WITH MyCTE AS
(
	SELECT ID, PID, VALUE, 0 AS [LEVEL]
	FROM #data
	WHERE PID IS NULL
	UNION ALL
	SELECT D.ID, D.PID, D.VALUE, [LEVEL] + 1
	FROM MyCTE M
		JOIN #data D
			ON D.PID = M.ID
)
SELECT ID, PID, VALUE, [LEVEL]
FROM MyCTE;

DROP TABLE #data;