----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: sanjaypal2809 Message 4 in Discussion _____________________ Thank's with rgds Sanjay Pal ___________> To: [email protected]> From: [EMAIL PROTECTED]> Subject: Re: Random selection> Date: Sun, 14 Oct 2007 02:43:01 -0700>> [http://sc.groups.msn.com/themes/R9c/pby/img/mail/mlstar.gif] New Message on BDOTNET> Random selection> Reply> Reply to Sender [http://sc.groups.msn.com/themes/R9c/pby/img/mb/recommend.gif] Recommend Message 3 in Discussion> From: [http://sc.groups.msn.com/themes/R9c/pby/img/cmd/cool_global_nick.gif] OrangeVarun42> 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> To: BDOTNET> Sent: Monday, October 8, 2007 6:19:54 PM> Subject: Re: Random selection>> 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>> 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!> 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. _________________________________________________________________ Get the new Windows Live Messenger! http://get.live.com/messenger/overview ----------------------------------------------------------- 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]
