asked on

how to join 2 fields(date and time) in SQL server

HI can someone help me to join to columns(date, time) together to make it become datetime.

just a by doing a select.

im using sql server 2012.

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Ganapathi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

razza_b

ASKER

actually this is what i have...

SELECT TblBusinessType.BusinessType AS Business
, TblTransaction.TaStationIdKey AS Station
, TblJob.JobProductLine AS Line
, TblTransaction.TaJobKey AS WorkOrder
, TblJob.JobPartId AS PartNumber
, TblTransaction.TaTester AS Tester
, SUM(CASE WHEN TaTransCdKey = 'OutAccept' THEN TaQty ELSE 0 END) AS Pass
, SUM(CASE WHEN TaTransCdKey = 'OutReject' THEN TaQty ELSE 0 END) AS Fails, SUM(TblTransaction.TaQty) AS Output
, 100 - CAST(100 * CAST(SUM(CASE WHEN TaTransCdKey = 'OutReject' THEN TaQty ELSE 0 END) AS Float) / SUM(TblTransaction.TaQty) AS Decimal(18,2)) AS Yield
FROM TblTransaction
INNER JOIN TblJob ON TblTransaction.TaJobKey = TblJob.JobKey
INNER JOIN TblStation ON TblTransaction.TaStationIdKey = TblStation.StaIdKey
INNER JOIN General.Part_Header ON TblJob.JobPartId = General.Part_Header.PartNbr
INNER JOIN TblBusinessType ON General.Part_Header.FKBusinessTypeId = TblBusinessType.BusinessTypeID
WHERE (TblTransaction.TaStationIdKey NOT LIKE 'MRB%')
AND (TblTransaction.TaStationIdKey NOT LIKE 'REWORK%')
AND (TblTransaction.TaStationIdKey NOT LIKE 'REPAIR%')
--AND (TblTransaction.TaStationIdKey NOT LIKE 'DEBUG%')
AND (TblTransaction.TaStationIdKey NOT IN ('FG','DISMOUNT'))
AND (TblTransaction.TaAddDtKey>= @StartDate + cast(@StartTime as datetime)
AND (TblTransaction.TaAddDtKey < COALESCE(@EndDate,'2099-01-01'))
AND (TblTransaction.TaJobKey = COALESCE(@JOB,TblTransaction.TaJobKey))
AND (TblTransaction.TaStationIdKey IN (@Station))
AND (TblJob.JobProductLine IN (@Line))
AND (TblBusinessType.BusinessType IN (@Business))
AND (TblTransaction.Tatranscdkey LIKE 'OUT%')
AND ((TblTransaction.Taoperator IN (@Operator)) OR (TblTransaction.Taoperator != ''))
AND ((TblTransaction.TaLotKey IN (@LotNo)) OR (TblTransaction.TaLotKey != Null))
--AND (TblTransaction.TaTester IN (@Tester))
GROUP BY TblTransaction.TaJobKey, TblJob.JobPartId, TblTransaction.TaTester,TblTransaction.TaStationIdKey
, TblJob.JobProductLine, TblTransaction.TaLine,TblBusinessType.BusinessType
ORDER BY Station, WorkOrder

Jim Horn

So ... how's it going?

>actually this is what i have...
Let us know if you applied our comments to your query.