Since I believe this should be a basic question I know this question has probably been asked, but I am unable to find it. I'm probably about to earn my Peer Pressure badge, but I'll ask anyway: Is there a way in SQL Server that I am not aware of for using the wildcard character % when using IN. I realize that I can use OR's like: sele...
Hi guys, I'm trying to use the value of another field inside an IN. SELECT types.id, title, auth_users.types FROM types LEFT JOIN auth_users ON auth_users.id IN (8,9) WHERE types.id IN (1,2,3) GROUP BY types.id Works SELECT types.id, title, auth_users.types FROM types LEFT JOIN auth_users ON auth_users.id IN (8,9) WHERE types.id IN ...
Can someone help me to convert from SQL Query to LINQ VB.NET: select rls.* from Roles rls(nolock) where rls.id not in ( select r.ID from usersRole ur (nolock) inner join Roles r(nolock) on ur.RoleID = r.ID where user_id = 'NY1772') Thanks ...
Hi all, I have a PHP array with numbers of ID's in it. These numbers are already ordered. Now i would like to get my result via the IN() method, to get all of the ID's. However, these ID's should be ordered like in the IN method. For example: IN(4,7,3,8,9) Should give a result like: 4 - Article 4 7 - Article 7 3 - Article 3 ...
Hey guys, I am building a suggestive tagging system (sounds seedy), I pass in a string to the db and if there is a match it sends back that tag. I want to stop duplicate tags, so if one tag is WEB, I only want it to be returned once. So if I had WEB as a tag and then add WEEKLY, typing "WE" doesn't bring up WEB for a second time as a s...