Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check. Well, if you happen to be using Sql Server you can do that sort of ...
Ars Technica

SQL: If statement in SELECT statement, concatenation in SQL statment?

I have a table that has 2 fields, postDate, and postTime. I want to select all the the records where 1. the current date is later than the post date. 2. The post time is later than the current time. I ...