[Code]

SELECT a.people_number

FROM TheTable a

INNER JOIN TheTable b ON d.people_number = a.people_number

WHERE a.web_role = 3 AND b.web_role = 8

GROUP BY a.people_number

[/Code]

Tim Peters (4/14/2008)

---

OK, this is a first for me, I was able to answer my own post 😛

LEFT(Reference, LEN(Reference) - PATINDEX('%[.]%', REVERSE(Reference)))

Unless, of course, someone points out where this goes...

Well, now I suppose to mention whom I've got it from?

But I don't remember!!! :w00t:

:hehe:

david.buncle (4/11/2008)

---

Hi.

I have a problem where I'm storing a very large xml sting in a field of type ntext in the database. A problem arises when I try and extract...

Can you please post an example of inline UDF which will select a table field depending on a parameter and and SELECT statement using it which will not cause RBAR...

Sylvia Moestl Vasilik (4/10/2008)

---

Thanks, that's a good idea. As a matter of fact, it's made me realize I might be able to have it all in one function -...

I want to see those "certain dates" which will make the query return NULL.

I never saw COUNT(*) returning NULL in my life.

I once improved responce time of the query from 10 s to under 1 s just by replacing NOT IN with NOT EXISTS.

Don't remember exactly how many rows were in...

Which SQL SERVER interprets in the same way as using IN, therefore I would use IN, as it's easier to follow in your code:

Select * From TableA Where TableA.ID Not...

Stephen Grimshaw (4/4/2008)

---

In Sybase T-SQL (where I spend most of my time) UPDATED simply means that the column has been specified in an UPDATE command. It does not mean that...

And probaly your problem is within that "some update" thing.

Probably even in "CREATE TABLE" thing used iwithin that "some update".

They must be causing the locking, tempdb is just happenned to...

Can you start transaction AFTER you created and populated # table?

mtassin, I'm not trying to say you don't know how to use ISNULL. I don't know you at all, so I assume you're the best in SQL. 🙂

I'm just trying...

If you don't know something you must assume the worst.

And if it's...

"create table" statement causes schema lock because it changes the schema of the database.

Because you create # table it locks tempdb.

Lock stays there until transaction is finished.

Because you probably have...