Most likely, the DBA wouldn't/couldn't be held accountable in this situation. But that's counting on a sane, reasonable legal system. Definitely not the case in any country I'm...

You're welcome.

GilaMonster (12/4/2009)

---

Not helped by someone who doesn't appear to know the difference between an operating system kill process and a...

You're welcome.

Okay, couple of misconceptions there.

First, a "cartesian product" is when you join two tables together without anything telling the code which rows go with which. Your code doesn't do...

You could do this:

delete T1

from Table1 T1

inner join Table2 T2

on T1.Main = T2.Main

and T2.Type...

Create a cursor that selects all the functions from the system views, have it step through them and build a dynamic SQL command to grant the permissions.

Will this do what you need?

select *

from dbo.MyTable

where BLNA = 'True'

and exists

(select *

from dbo.MyTable T2

where FK1 = MyTable.FK1

and BLNA = 'False')

or BLNA = 'False'

and exists

(select *

from dbo.MyTable T3

where FK1 =...

Try something like this:

delete T1

from Table1 T1

inner join Table2 T2

on T1.Main = T2.Main

and T2.Type = 2

and T1.FullName = T2.FirstName + ' ' + T2.LastName;

Definitely start with the book. Anything else will mostly be an expansion on that.

Books Online has some details (or MSDN), too.

There isn't a "trim" function in T-SQL. There are "LTrim" and "RTrim". One takes spaces off of the left side, the other takes them off of the right...

Julie Breutzmann (12/4/2009)

---

There were two different crimes here. The stealing of the data is the one that is receiving the most attention. But what about the companies that received and...

GilaMonster (12/4/2009)

---

GSquared (12/4/2009)

---

Would be better in SQL 2005/2008, since you could use the Include clause for most of the columns, but in SQL 2000, you may or may not get...

I guess I'm not sure what you're asking for. Are you asking about the internal workings of the engine (memory addressing, I/O requests, etc.), or about performance characteristics (baseline...

Will this do what you need?

select ID

from TableB

inner join TableA

on TableB.SegmentValue = TableA.SegmentValue

group by ID

having count(*) =

(select count(*)

from TableA);