----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: OrangeVarun42 Message 3 in Discussion Hi , Also the following statement can be used in sql server. SELECT TOP 20* FROM tablename TABLESAMPLE (1000 ROWS) OR SELECT TOP 20* FROM tablename TABLESAMPLE (10 PERCENT) Varun R.Doharey Software Design Engineer k-Bridge India Pvt.Ltd ----- Original Message ---- From: Srinee <[EMAIL PROTECTED]> To: BDOTNET <[email protected]> Sent: Monday, October 8, 2007 6:19:54 PM Subject: Re: Random selection <STYLE type=text/css> /* Foreground colors */ ThmFgColumnHeader, A.FrameLink, A.HeaderLink, A.FooterLink, A.LgtCmd, A.MSNLink {color:#FFFFFF;} ThmFgTitleLightBk {color:#FF6600;} ThmFgSmallLight {color:#ff0000;} ThmFgNavLink, A.NavLink, A.ChildLink:hover {color:#666699;} ThmFgInactiveText, A.SystemLink {color:#666666;} ThmFgFrameTitle {color:#FFFFCC;} ThmFgTitleDarkBk, A.NavLink:hover, A.TitleLink {color:#CC6600;} ThmFgMiscText, A.Cat, A.SubCat {color:#336699;} ThmFgCommand, A.Command, A.LargeCommand, A.MsgLink {color:#003366;} ThmFgHeader {color:#333333;} ThmFgStandard, A.SystemLink:hover, A.SubLink, A.ChildLink, A.StdLink, SELECT.Standard {color:#000000;} ThmFgDivider {color:#CCCCCC;}/* primarily for HR tags */ /* Background colors */ ThmBgStandard {background-color:#FFFFFF;} ThmBgUnknown1 {background-color:#FF6600;} ThmBgFraming {background-color:#666699;} ThmBgUnknown2 {background-color:#666666;} ThmBgHighlightDark {background-color:#FFFFCC;} ThmBgHighlightLight, #idToolbar, #tbContents {background-color:#FFFFE8;} ThmBgTitleDarkBk {background-color:#F1F1F1;} ThmBgAlternate {background-color:#ECF1F6;} ThmBgUnknown3 {background-color:#CCCCFF;} ThmBgDivider {background-color:#CCCCCC;} ThmBgHeader {background-color:#9999CC;} ThmBgLinks {background-color:#8696C9;} ThmBgSharkBar {background-color:#8696C9;} ThmBgGlobalNick {background-color:#9394A9;} /* Calendar styles */ calfgndcolor {color:#E00505;} calbgndcolor {color:#E00505;} </STYLE> New Message on BDOTNET Random selection Reply Reply to Sender Recommend Message 2 in Discussion From: Srinee Hi, In SQL Server you can do like this Select col1, col2, col3 from tablename Order by NEWID() which return in a random order. Regards Srikanth From: [EMAIL PROTECTED] To: [email protected] Subject: Random selection Date: Sun, 7 Oct 2007 05:49:19 -0700 <META content="Microsoft SafeHTML" name=Generator> <STYLE> ExternalClass EC_ThmFgColumnHeader, .ExternalClass EC_A.FrameLink, ExternalClass EC_A.HeaderLink, .ExternalClass EC_A.FooterLink, ExternalClass EC_A.LgtCmd, .ExternalClass EC_A.MSNLink {color:#FFFFFF;} ExternalClass EC_ThmFgTitleLightBk {color:#FF6600;} ExternalClass EC_ThmFgSmallLight {color:#ff0000;} ExternalClass EC_ThmFgNavLink, ExternalClass EC_A.NavLink, ExternalClass EC_A.ChildLink:hover {color:#666699;} ExternalClass EC_ThmFgInactiveText, .ExternalClass EC_A.SystemLink {color:#666666;} ExternalClass EC_ThmFgFrameTitle {color:#FFFFCC;} ExternalClass EC_ThmFgTitleDarkBk, .ExternalClass EC_A.NavLink:hover, ExternalClass EC_A.TitleLink {color:#CC6600;} ExternalClass EC_ThmFgMiscText, .ExternalClass EC_A.Cat, .ExternalClass EC_A.SubCat {color:#336699;} ExternalClass EC_ThmFgCommand, .ExternalClass EC_A.Command, ExternalClass EC_A.LargeCommand, .ExternalClass EC_A.MsgLink {color:#003366;} ExternalClass EC_ThmFgHeader {color:#333333;} ExternalClass EC_ThmFgStandard, .ExternalClass EC_A.SystemLink:hover, ExternalClass EC_A.SubLink, .ExternalClass EC_A.ChildLink, ExternalClass EC_A.StdLink, .ExternalClass EC_SELECT.Standard {color:#000000;} ExternalClass EC_ThmFgDivider {color:#CCCCCC;} ExternalClass EC_ThmBgStandard {background-color:#FFFFFF;} ExternalClass EC_ThmBgUnknown1 {background-color:#FF6600;} ExternalClass EC_ThmBgFraming {background-color:#666699;} ExternalClass EC_ThmBgUnknown2 {background-color:#666666;} ExternalClass EC_ThmBgHighlightDark {background-color:#FFFFCC;} ExternalClass EC_ThmBgHighlightLight, ExternalClass #EC_idToolbar, ExternalClass #EC_tbContents {background-color:#FFFFE8;} ExternalClass EC_ThmBgTitleDarkBk {background-color:#F1F1F1;} ExternalClass EC_ThmBgAlternate {background-color:#ECF1F6;} ExternalClass EC_ThmBgUnknown3 {background-color:#CCCCFF;} ExternalClass EC_ThmBgDivider {background-color:#CCCCCC;} ExternalClass EC_ThmBgHeader {background-color:#9999CC;} ExternalClass EC_ThmBgLinks {background-color:#8696C9;} ExternalClass EC_ThmBgSharkBar {background-color:#8696C9;} ExternalClass EC_ThmBgGlobalNick {background-color:#9394A9;} ExternalClass EC_calfgndcolor {color:#E00505;} ExternalClass EC_calbgndcolor {color:#E00505;} </STYLE> New Message on BDOTNET Random selection Reply Reply to Sender Recommend Message 1 in Discussion From: ravisperavali Hi.. I want to select a ID randomly that is retrieved from the database using c#..Can any one send me source code for the same ... ravi View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from BDOTNET. Windows Live Spaces is here! It?s easy to create your own personal Web site. Check it out! View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from BDOTNET. Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings, and more! ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
