GilaMonster (10/6/2011)

---

Lynn Pettis (10/6/2011)

---

Then the code Jack ran into my be a vestige left over...

Actually, I think I found where my logic died. Haven't used it in a while so I didn't quite remember the rules correctly.

I stand corrected and back on track...

Did some testing and it looks like you do want to ANDs in the NOT EXISTS statement.

Okay, boolean logic doesn't always work as you think in T-SQL.

I...

Then the code Jack ran into my be a vestige left over when the database...

GilaMonster (10/6/2011)

---

Lynn Pettis (10/6/2011)

---

Jack Corbett (10/6/2011)

---

So working on a system where there is a UDF that calls a view and the view definition is:

create view SYSTEM_DATE_VIEW

as...

GilaMonster (10/6/2011)

---

Lynn Pettis (10/6/2011)

---

Jack Corbett (10/6/2011)

---

So working on a system where there is a UDF that calls a view and the view definition is:

create view SYSTEM_DATE_VIEW

as...

Jack Corbett (10/6/2011)

---

So working on a system where there is a UDF that calls a view and the view definition is:

create view SYSTEM_DATE_VIEW

as select getdate() SYSTEM_DATE

...

It would help if you could post the DDL for the table(s), sample data for the table(s), expected results based on the sample data, and what you have done so...

Actually, I would not worry about purging the data from the database backups. Doing so simply is beyond the scope of the corporate/state/federal requirements. Purging the data from...

GilaMonster (10/4/2011)

---

I'm busy building a monster of a server (8 cores, 16GB memory, 6TB drive space) that can support multiple virtual machines, so I can play with mirroring, replication, AlwaysOn,...

Glad I was able to help.

~Dev~ (10/4/2011)

---

1)I'm using .net - is there a way I can configure schema name as a part of connection string.

Dev:: I am not sure on this but if you have...

derek.colley (10/4/2011)

---

Hah, fair enough! This is not the first time I've heard that opinion aired!

Out of interest, does anyone know why AUTO_SHRINK is such a bad idea? I...

Here is the problem, your query has no order by so that your result set, before eliminating dups, instead of looking like this:

Request, city, Service, Complaint

123 - Arcadia - abc...