Multi account

05/15/2014 14:32 QQers19#1

Hello!
I try tu wirte some query's for show multi acc
But i have a problem "Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '127.0.0.1' to data type int."

Code:

 SELECT * FROM PS_UserData.dbo.users_master
Where UserIp >1

Code:

SELECT * FROM PS_UserData.dbo.Users_Master c
INNER JOIN PS_UserData.dbo.Users_Master um ON um.UserUID=c.UserUID
WHERE um.UserIp >1

05/15/2014 15:15 nubness#2

Code:

USE PS_UserData
SELECT UserUID, UserID, Pw, UserIp FROM Users_Master
WHERE UserIp IN (SELECT UserIp FROM Users_Master
GROUP BY UserIp
HAVING COUNT(UserIp) > 1)
ORDER BY UserIp

05/15/2014 15:32 QQers19#3

Thank you :)

05/16/2014 18:55 Autrux#4

#moved