Instead of posting a bunch of code that doesn't work, please explain exactly what you want to do.

It would also help it you posted the structure of the table, some...

SQL Server 2005 Books Online

http://msdn.microsoft.com/en-us/library/ms187658(SQL.90).aspx

Maintenance Plans

"...Maintenance plans only run against databases...

andrewd.smith (3/27/2009)

---

I think this is in the spirit of that thread. I'm quite pleased to have found a new use for...

It is not a bug.

The documentation specifically states that databases in 7.0 compatibility mode are not supported by SQL Server maintanance plans.

I thought that you could create a database snapshot of a mirror that you could use to run queries.

I'm a littel disappointed that no one wanted to play.

Ed Salva (3/27/2009)

---

"convince them your a nut and that they had better stay away from you." -- Grasshopper

never been able to successfully accomplish this, can't seem to get past the...

select * from information_schema.columns where column_name = 'lname'

In the spirit of the completely ridiculous, here goes:

SELECT id, CASE WHEN Abs( Sin(Ascii(Reverse ...

Use a check constraint on the table for the first rule:

( case when col2 is not null then 1 else 0 end + case when col3 is not null then...

select WorkTime = convert(varchar(5),dateadd(ss,sum(Work)*3600,0),114)

from

( --Test Data

select Work = 4.75 union all

select Work = 1.50

...

george sibbald (3/25/2009)

---

...Michael, I like the boot from SAN idea, do you do that?. Our intel guys don't seem keen, saying there are performance problems. Seems to me it would...

It's best to just set the files to equal size, and to set the growth size equal on each file.

As you add data over time, the files with less data...

I try to keep my disagreements with other posters on the level to discussion of the issues and avoid name calling.

Not because I like to take the high road or...

How would you like to see the output, considering that all rows in the result set must have the same number of columns and they must have the same datatype?...