Without knowing more about what you will be using this route data for, I can only suggest your NOT using NULLs. As you are well aware a NULL...

Is this what you are looking for?

DECLARE @BeginDate DATE

DECLARE @W DATE

SET @BeginDate = '28 feb 2011'

--Included so as to see what is happening -remove in actual use

SET @W = ...

Read this article...

Caroline Hecht (3/11/2011)

---

That page gives info about the sysdbmaintplan_history table, but states that it is no longer used in SQL 2008. My question is where to look for the...

And yet this:

http://msdn.microsoft.com/en-us/library/ms187752.aspx

In SQL Server, based on their storage characteristics, some data types are designated as...

Try this:

SELECT

REPLACE(CONVERT(varchar,cast('2011-03-09 15:16:41'as datetime),101),'/','-')

This might be what you want (sysdbmaintplan_history )

http://technet.microsoft.com/en-us/library/ms173549(SQL.90).aspx

For reasons of performance the recommendation is that 1000 files per folder is not exceeded. But no reference has been included in the explanation. So the justification for...

Here is an article, complete with sample code that may provide the T-SQL code you are searching for:

http://www.mssqltips.com/tip.asp?tip=1202

Additional data replete with many, many code samples

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Another possible method, have Excel pull...

GilaMonster (3/9/2011)

---

*sigh* I know I'm a little short tempered due to lingering jetlag (first time I've still been struggling to sleep 3 days later), but I really didn't need three...

Hope this helps. From a blog posting by Steve Jones (Yes Steve Jones of SSC)

TriggerProper trigger writing/* Steve Jones Blog Posting

http://www.google.com/reader/view/?tab=my#stream/feed%2Fhttp%3A%2F%2Ffeeds.feedburner.com%2FSqlMusings */

Create trigger orders_update_inventory on orders

for...

Without knowing what indexes exist it is hard to optimize the T-SQL as I am sure you understand. Now just to give you an additional approach you might want...

Please, please read this posting by Steve Jones (posted today as an editorial)

http://www.sqlservercentral.com/articles/Editorial/72676/

Added at 11:35

Also be sure to read the forum discussion on Steve's editorial.

-----------------------

If that does not get you...

Duncan Pryde (3/8/2011)

---

bitbucket-25253 (3/7/2011)

---

Duncan Pryde (3/7/2011)

---

Totally irrelevant to the question of course, but I needed to tell someone:

I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)

It's...

the table contains data for workflow auditing...tracking steps through a workflow.

after modifying thier query, the execution plan does change. However, it still has a sort step with 30%. I'm thinking...