Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select Random records from a Table
Perfect!!! Thanks Nigel, I really appreciate it.- ramone109
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Select Random records from a Table
I have a table that is made up of the following columns: RecID (primary key) Name Address City State Zip Phone As an example, I need to pull 5000 records from this table where the state is New York. However, I need to make sure that I don't get the exact same records everytime I run the same...- ramone109
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
STRUGGLING with a Stored Procedure Parameter Issue
As long as your not using wipID in any mathematical expressions, couldn't you just convert wipID to a string after its value has been established, and then use it in the IN expression against @list?- ramone109
- Post #3
- Forum: Microsoft SQL Server: Programming
-
ODBC TNS Error: ORA 12535: TNS operation timed out
I've just installed Oracle 8i onto a machine with Windows XP Pro. The installation completed fine, and I'm able to connect to SQL Plus. However, I'm getting an error message when using the Oracle ODBC test utility, as I want to create a connection to VB. The error is as follows: SQLSTATE...
