thoughts about technology, photography, …

Skip to content
  • DANIEL WALZENBACH
  • ABOUT
← Older posts

How to select last month’s entries from your database

Posted on March 13, 2013 by Daniel Walzenbach
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());
Posted in Software Development, SQL, Tipps & Tricks | Leave a comment

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

Posted on May 2, 2011 by Daniel Walzenbach

Posted in Music | Tagged one song today | Leave a comment

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

Posted on May 1, 2011 by Daniel Walzenbach

Posted in Music | Tagged one song today | Leave a comment

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

Posted on April 29, 2011 by Daniel Walzenbach

Posted in Music | Tagged one song today | Leave a comment

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

Posted on April 27, 2011 by Daniel Walzenbach

Posted in Music | Tagged one song today | Leave a comment
← Older posts
  • Daniel Walzenbach
    Daniel's LinkedIn profile
    Daniel's XING profile
  • Recent Posts

    • How to select last month’s entries from your database
    • If you could listen to only one song today – Manfred Hubler & Siegried Schwab – The Lions & The Cucumber
    • If you could listen to only one song today – Fettes Brot-Jein
    • If you could listen to only one song today – Mos Def – Next Universe
    • If you could listen to only one song today – Tom Jones – Thunderball
  • Categories

    • Climbing
    • Music
    • Photography
    • Software Development
    • SQL
    • Tipps & Tricks
    • Tools
thoughts about technology, photography, …
Proudly powered by WordPress.