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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select records by max(date) in another related table?
Here is the scenario: Two tables-1)Prospects table, 2)Events table Prospects table holds data on the individual and is assigned a unique number 'pkey'. Events on each individual prospect is recorded in the Events table and is related back to the Prospect table by the foreign key also named... -
Read Text File Into SQL Server 7 Table
Working with our ISP host we have a user account set-up(no admin rights) on sql server 7. Every night we have to do a data push to the database of between 50000 to 500 records in five separate tables. Trying to find a stored procedure that will read a text file into a table. Not allowed to use...- RyanAG
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
