Time as Decimal, Date as string, Combine to DateTime.

DECLARE @f [real] DECLARE @CurDate [Date] SET @f = 13.5323653232 SET @CurDate  = ‘20140911’ SELECT DATEADD(mi, (@f – FLOOR(@f)) * 100, DATEADD(hh, FLOOR(@f), CAST (’00:00:00′ AS TIME))) SELECT Cast(CONVERT(DATETIME, CONVERT(CHAR(8), @CurDate, 112)   + ‘ ‘ + CONVERT(CHAR(8), DATEADD(mi, (@f – FLOOR(@f)) * 100, DATEADD(hh, FLOOR(@f), CAST (’00:00:00′ AS TIME))), 108)) as DATETIME) SELECT datediff(dd,Cast(CONVERT(DATETIME, CONVERT(CHAR(8),… Read More »

What is DDE and why is it totally different from COM?

DDE stands for Dynamic Data Exchange. That’s exactly what it does, and nothing more. It sends data between applications using Windows messages according to a documented protocol. Saying that DDE is old-fashioned and is being replaced by COM is something you see repeated parrot fashion over and over again. DDE and COM do not work… Read More »


Well you only need the light when it’s burning low Only miss the sun when it starts to snow Only know you love her when you let her go Only know you’ve been high when you’re feeling low Only hate the road when you’re missin’ home Only know you love her when you let her… Read More »


From Wikipedia, the free encyclopedia Innovation is a new idea, device or process.[1] Innovation can be viewed as the application of better solutions that meet new requirements, inarticulated needs, or existing market needs.[2] This is accomplished through more effective products, processes, services, technologies, or ideas that are readily available to markets, governments and society. The… Read More »