The 5 types of programmers

In my code journeys and programming adventures I’ve encountered many strange foes, and even stranger allies. I’ve identified at least five different kinds of code warriors, some make for wonderful comrades in arms, while others seem to foil my every plan. However they all have their place in the pantheon of software development. Without a… Read More »

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 »