thoughts about technology, photography, ...

How to select last month’s entries from your database

Daniel Walzenbach — Wed, 13 Mar 2013 17:58:11 +0000

SELECT TOP 1000 [OrderID] ,[CustomerID] ,[EmployeeID] ,[OrderDate] ,[RequiredDate] ,[ShippedDate] ,[ShipVia] ,[Freight] ,[ShipName] ,[ShipAddress] ,[ShipCity] ,[ShipRegion] ,[ShipPostalCode] ,[ShipCountry] FROM [Northwind].[dbo].[Orders] WHERE OrderDate > DATEADD(MONTH,-1,GETUTCDATE()); ]]>

If you could listen to only one song today – Manfred Hubler & Siegried Schwab – The Lions & The Cucumber

Daniel Walzenbach — Mon, 02 May 2011 17:02:07 +0000

]]>

If you could listen to only one song today – Fettes Brot-Jein

Daniel Walzenbach — Sun, 01 May 2011 17:53:08 +0000

]]>

If you could listen to only one song today – Mos Def – Next Universe

Daniel Walzenbach — Fri, 29 Apr 2011 08:20:40 +0000

]]>

If you could listen to only one song today – Tom Jones – Thunderball

Daniel Walzenbach — Wed, 27 Apr 2011 17:14:54 +0000

]]>

If you could listen to only one song today – Portishead – Roads

Daniel Walzenbach — Wed, 27 Apr 2011 07:18:55 +0000

]]>

If you could listen to only one song today – Bill Withers – Ain’t No Sunshine

Daniel Walzenbach — Mon, 25 Apr 2011 17:14:16 +0000

]]>

If you could listen to only one song today – The Prodigy Weather Experience

Daniel Walzenbach — Sun, 24 Apr 2011 17:09:28 +0000

]]>

If you could listen to only one song today – The Dave Brubeck Quartet – Take Five

Daniel Walzenbach — Sat, 23 Apr 2011 17:06:36 +0000

]]>

If you could listen to only one song today – Aphex Twin – Didgeridoo

Daniel Walzenbach — Fri, 22 Apr 2011 17:25:29 +0000

]]>