My code-
SELECT dbo.NumericSamplesDelByTapan.TagID, dbo.Tags.TagName, dbo.Tags.Location
,(SELECT DATEADD(Millisecond, FLOOR((dbo.NumericSamplesDelByTapan.SampleDateTime - 599266080000000000) % (10000000 * 60) / 10000)
, DATEADD(Minute, FLOOR((dbo.NumericSamplesDelByTapan.SampleDateTime - 599266080000000000) / (10000000 * 60) + 330), '01-01-1900')) AS EXPR1) AS TimeStamp
, dbo.NumericSamplesDelByTapan.SampleValue
FROM dbo.Tags
INNER JOIN dbo.NumericSamplesDelByTapan
ON dbo.Tags.ID = dbo.NumericSamplesDelByTapan.TagID