Database

DECLARE @val AS VARCHAR(255)<br />
SET @val='hi this is john'<br />
<br />
IF(SELECT CHARINDEX('john',@val))>0<br />
BEGIN<br />
PRINT 'exists'	<br />
END<br />
ELSE<br />
PRINT 'doesnt exists'

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