How about providing the DDL (CREATE TABLE statements) for the table(s) involved (including the constraints applied), sample data you are trying to insert (series of INSERT INTO statements) for the...

2Tall (6/10/2010)

---

Hi. I have a DueDate field in a table. I would like to set this value in a SELECT to be the current date if less than current date.

Users...

Starting with SQL Server 2005 SP 1, database mirroring is available without enabling any trace flags.

Steven James Gray (6/6/2010)

---

Lynn Pettis (6/6/2010)

---

Steve,

Unfortunately, you are using the same logic everyone else uses to defend the use of inefficient code, "It works for my case." Problem is,...

Steve,

Unfortunately, you are using the same logic everyone else uses to defend the use of inefficient code, "It works for my case." Problem is, it is still inefficient. ...

Amazing how some people will continue to defend their code even when shown it is inefficient.

Special note, I found no real appreciable difference between the following:

select * into #Test2 from dbo.fn_GetTimestampRangeRCTE ('2006-01-01','2006-02-01', 0) OPTION (MAXRECURSION 0);

select * into #Test2 from dbo.fn_GetTimestampRangeRCTE ('2006-01-01','2006-02-01', 0) OPTION (MAXRECURSION...

Steven James Gray (6/6/2010)

---

Inefficiency is relative. As slow as it is, it's possible to generate enough data to cover a century in less than half an hour when dealing at...

Unless you have already established auditing processes to capture these types of changes, you may not be able to determine the who and when this occurred.

You may want to start...

Jeff Moden (6/4/2010)

---

Actually, the op said nothing about a SELECT and you don't know how your answer will be used.

If it's for a SELECT to return a result set to...

This:

select

d.col1,

d.col2,

e.col4,

e.col5

from

dbo.table1 d, dbo.table2 e

where

d.col1 = e.col1

is...

I'm assuming that this meant dropping both the partner and witness servers from the principal database, correct?

Never mind (at least for now) as the problem with the server turned out...

timmynew11 (6/4/2010)

---

Thanks, but i figured out my issue with a cartesian join. It appears you have too much time on your hands to post an article on the proper...

Disaster alleviated. Turns out some memory went south. SysAdm replaced all the RAM in the server (resulted in an upgrade from 20GB to 24GB) and it is up...