Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Select all usernames except few usernames Expand / Collapse
Author
Message
Posted Sunday, February 14, 2010 10:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 23, 2013 11:33 PM
Points: 39, Visits: 111
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
Posted Sunday, February 14, 2010 10:16 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 7, 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
Posted Sunday, February 14, 2010 11:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 23, 2013 11:33 PM
Points: 39, Visits: 111
Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases
Post #865370
Posted Sunday, February 14, 2010 11:36 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 7, 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
Posted Monday, February 15, 2010 1:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 23, 2013 11:33 PM
Points: 39, Visits: 111
in SQL-2008, all the databases are in same server
Post #865399
Posted Tuesday, February 16, 2010 1:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
What is LINQ KrayKnot?
Post #865898
Posted Wednesday, February 17, 2010 2:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 5:17 AM
Points: 1,180, Visits: 2,672
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 »

Add to briefcase

Permissions Expand / Collapse