Database

Mika Wendelius wrote:

if you don't have any difficulties implementing this using SSIS

Mycroft Holmes wrote:

Databases do not have columns, they have tables, are you tlaking about copying a table from 1 DB to another?

SELECT *<br />
INTO Database2.dbo.TableName<br />
FROM Table1

SELECT *<br />
FROM t_log<br />
WHERE invno NOT IN (SELECT Inventryno from inv)<br />
	AND transactiontype = 'R/S'<br />

UPDATE t_log SET Comment = 'Thinking is good for you'<br />
--SELECT *<br />
FROM t_log<br />
WHERE invno NOT IN (SELECT Inventryno from inv)<br />
AND transactiontype = 'R/S'

SELECT CustomerID, MIN(TransTimeStamp) AS StartTime
FROM CustomerLog
WHERE Status = 2
GROUP BY CustomerID

SELECT CustomerID, MAX(TransTimeStamp) AS EndTime
FROM CustomerLog
WHERE Status = 3
GROUP BY CustomerID

SELECT CustomerName, StartTime, EndTime
FROM Customer AS c
INNER JOIN (SELECT CustomerID, MIN(TransTimeStamp) AS StartTime
            FROM CustomerLog
            WHERE Status = 2
            GROUP BY CustomerID) AS s ON s.CustomerID = c.CustomerID
INNER JOIN (SELECT CustomerID, MAX(TransTimeStamp) AS EndTime
            FROM CustomerLog
            WHERE Status = 3
            GROUP BY CustomerID) AS e ON e.CustomerID = c.CustomerID

SELECT CustomerName, 
       (SELECT MIN(TransTimeStamp) FROM CustomerLog cl WHERE cl.CustomerID = c.CustomerID) AS StartTime, 
       (SELECT MAX(TransTimeStamp) FROM CustomerLog cl WHERE cl.CustomerID = c.CustomerID) AS EndTime
FROM Customer c

SELECT CustomerName, 
       (SELECT MIN(TransTimeStamp)  --min to find first stop after each start
        FROM   CustomerLog cl2 
        WHERE  cl2.CustomerID     = c.CustomerID 
        AND    cl2.Status         = 3
        AND    cl2.TransTimeStamp > cl.TransTimeStamp) AS EndTime 
FROM Customer c, 
     CustomerLog --starts
WHERE cl.CustomerID = c.CustomerID
AND cl.Status = 2