Select all usernames except few usernames

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Select all usernames except few usernames

Select all usernames except few usernames

Rate Topic

Display Mode

Topic Options

Author

Message

jaype-365633

Posted Sunday, February 14, 2010 10:06 PM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 11:37 PM
Points: 17, Visits: 107

Hi, i am having a table with usernames(Field is USERID), select * gives all usernames
but i need to take that except 2 or 3 usernames, please help me on the query

Thanks
Jprakash

Post #865361

krayknot

Posted Sunday, February 14, 2010 10:16 PM

Old Hand

Group: General Forum Members
Last Login: Friday, October 07, 2011 1:41 AM
Points: 346, Visits: 534

select * from <TABLE> where <cOLUMN> not in (nVALUES)

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

Post #865363

jaype-365633

Posted Sunday, February 14, 2010 11:11 PM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 11:37 PM
Points: 17, Visits: 107

Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases

Post #865370

krayknot

Posted Sunday, February 14, 2010 11:36 PM

Old Hand

Group: General Forum Members
Last Login: Friday, October 07, 2011 1:41 AM
Points: 346, Visits: 534

jaype-365633 (2/14/2010)

Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases

in LINQ or iin SQL??

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

Post #865374

jaype-365633

Posted Monday, February 15, 2010 1:02 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 11:37 PM
Points: 17, Visits: 107

in SQL-2008, all the databases are in same server

Post #865399

luckysql.kinda

Posted Tuesday, February 16, 2010 1:51 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 11:19 AM
Points: 309, Visits: 645

What is LINQ KrayKnot?

Post #865898

nigel.

Posted Wednesday, February 17, 2010 2:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 1,163, Visits: 2,601

luckysql.kinda (2/16/2010)

What is LINQ KrayKnot?

Click here

--
Nigel

Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #866820

« Prev Topic | Next Topic »

Permissions