I can't seem to build a query in SQL Server 2005 that returns rows that are not in a table. [more inside]
posted by DakotaPaul on Oct 7, 2009 - 17 answers

Can someone help me understand how the WITH common table expression works in Microsoft SQL Server? [more inside]
posted by DakotaPaul on Sep 11, 2009 - 9 answers

Fixing whitespace: Can someone translate 's/ */ /g' into T-SQL? [more inside]
posted by pompomtom on Jul 30, 2008 - 2 answers

Another SQL question (*sigh*), but this time a bit more complicated. [more inside]
posted by omnipotentq on Jul 15, 2008 - 7 answers

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted by dw on Nov 13, 2007 - 3 answers