Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 8th, 2007, 11:56 PM
Registered User
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default how i can select this records

hi
in my databse i have 15 fields i want to select fileds not null like
full name, address one, address two, keycode, delivery address sample and also like to select 3 records of same keycode based on same key code ---and put an "X" on selcted three records of same keycode.

fullName AddressOne AddressTwo Keycode DeliveryAddres sample
a 1 2 000 123
a 1 2 222 123
a 1 2 111 123
a 1 2 111 123
a 1 2 000 123
a 1 2 222 123
a 1 2 333 123
a 2 2 111 123
b 1 2 123 123
b 1 2 456 123
as 2 2 333 123
a 1 2 750 123
a 1 2 555 123
a 1 2 555 123
a 1 2 555 123






Similar Threads
Thread Thread Starter Forum Replies Last Post
select records from excel androoo VB How-To 1 March 22nd, 2005 06:39 AM
check box to select all records chacquard Access VBA 2 January 13th, 2005 09:02 AM
select out last 10 records markhardiman SQL Language 4 September 30th, 2004 04:45 AM
Select Records from this year only morpheus Classic ASP Databases 8 September 17th, 2004 09:03 PM
Select records NOT in table davesav SQL Server ASP 2 June 10th, 2003 04:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.