Since you posted in a sql 2008 forum, what are the data types for the date? Are they datetime, date, datetime2, etc.

Also, is there a PK constraint or unique constraint...

I've created a Connect item...

sturner (10/12/2010)

---

Okay, I understand your question now. It appears that the implicit conversion from (n)varchar() to uniqueidentifier involves only the first 32 valid hexadecimal characters and SQL server ignores the...

GROAN.

Ninja's_RGR'us (10/12/2010)

---

Are you looking at last date and then last date minus 1 day or even minus 1 business day?

If not you could always do "select top 2 distinct order...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

I think instead of...

Since every row doesn't have the name number of columns, you're going to have to import it manually instead of using a flat-file task.

-- first, create a temp table to...

I would think that for the evaluation of IS NULL, it would depend greatly on the distribution of data... if you have a million plus rows of data with 90%...

Geez Bob, I had forgotten all about that one. Thanks for the reminder, and for the opportunity to re-read "a great collaboration" again!

GilaMonster (10/11/2010)

---

CirquedeSQLeil (10/11/2010)

---

I found some interesting articles on the internet that perpetuated the myth too. I didn't reference them in the TSQL2sday post, but there is bad info out...

Let's NOT...

Then change "with execute as owner" to "with...

What does this return?

SELECT schema_name(schema_id), name

FROM sys.tables

WHERE name = 'empssn'

Because it's not related to sp_configure; it's related to the "user options" setting that you're trying to change.