Maybe tp_ID is an integer, and UserName a varchar 😉

I am glad I could help 🙂

You can use = (SELECT... only when you are sure the subquery returns only one row, in other cases you must use IN

Roland

If I understand what you are looking for, I think this will do it :

Select firtname, lastname

from users

where Userid in (select UserId

from classes

group by UserID

having...

Declare @LastRun varchar (50)

...

Set @LastRun =

(SELECT Process_ID, Process_Name, Last_Message_Time

FROM [ITF3].[dbo].[Process]

WHERE Process_ID IN (1,2,3,4)

...

I am sorry, but I don't see the logics behind the results you are expecting. Could you explain it a little 🙂

Roland

I am sorry if I hurted someone. It was intended to be a joke !

Another badly redacted question ! It gets a little boring :doze:

On 2012 :

on master database, 6 different values, on other databases 2 differents values :doze:

In a new database, with sensitive collation, the check constraint works fine.

How did you change the collation ?

Isn't it a problem of case insensitive collation ?

Very clear, thank you !

Thank you Gila Monster.

Clearly I made a mistake, sorry :blush:

I think I remembered it this way because in my mind I saw the logic behind. Now I don't...

:exclamation: This query will work fine is GLPOST is not empty. But if it is empty, the condition will...

Hugo Kornelis (7/28/2014)

---

The "10 row(s) affected" is from the INSERT INTO statement. (I have SSMS set to default to using SET NOCOUNT ON, so I did not get that message,...

I am sorry, but I don't agree 🙂

I executed the script in SSMS (SQL Server 2012). It returned "10 row(s) affected", the csv file was created, but was empty. If...