I must be missing something. You have my screen name...

Well, that was predictable.

Marvin the Martian will be greatly disappointed...

Grant Fritchey (7/14/2009)

---

If we are coming up on the number of the beast & the end times & all that because of the Thread, then the four horseman & the...

Grant Fritchey (7/14/2009)

---

I hate to pop everyone's bubble, but wasn't it established a while back that the 666 number is either a mistranslation or a bad copying job and tha...

My two favorites were always:

666 1/2

Basement of the Beast

665.95

Retail Number of the Beast

There is a certain portion of the human species that feels the need to do things differently, regardless of whether it's actually an improvement or not.

I have a friend who...

Don't worry about the discrepancy in estimated cost. Most of the time, that's a meaningless value. It's one of those things I kind of wish Microsoft would just...

Given those constraints, I'd go with one image table and two details tables.

Is there a constraint that limits which tables the Source value 123 can be in?

Or at least an index on that column in each table?

If so, then it probably won't...

I'm going to assume this is SQL 2005. If you're actually using 2008, then take a look at the FileStream data type.

For 2000/2005, you're almost certainly going to be...

What's the actual script you're trying to run?

Is it an Alter Table statement? If so, please provide the table definition (create script) and the Alter Table script....

If there are jobs that are going to start up and expect the user databases to be there, you might get error messages because of that.

What are those values? Are they hex or some such?

Varchar does alphabetical comparisons for Between. Thus, since "2" is between "0" and "6", you're going to get that...

Simplify it to:

datediff(day, start_date, isnull(end_date, getdate())))

I just tested:

create table #T (

ID int identity primary key,

Start_Date datetime,

End_Date datetime,

Duration as datediff(day, start_date, isnull(end_date, getdate())));

--

insert into #T (Start_Date, End_Date)

select '1/1/2009', null union all

select...