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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
INSERT EXEC without defining table structure
This one's been bugging me all night. OK, at present this is what I do. I have a stored procedure (usp_ReportMaster) which returns the result of a dynamic SQL query like this: SELECT Improvement.* FROM .......... I then have many other stored procedures that run the above stored proc first and...- woodpd
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Distinct select problems
Scaled down table structure: TblCustomer: CustomerID FirstName Surname etc TblEnquiry: EnquiryID CustomerID Source etc I am trying (as part of a larger query) to get a list of the EnquiryIDs for a customer's most recent enquiry (therefore the list will only have 1 entry for each customer...- woodpd
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Impossible SQL query?
Dear people, I am tearing my hair out trying to write an SQL statement to do the following: In Table "Team" amongst other things I have a "TeamID" and a "TeamName". In Table "Match" amongst other things I have a "HomeTeamID" and an...- woodpd
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Impossible SQL query?
Dear people, I am tearing my hair out trying to write an SQL statement to do the following: In Table "Team" amongst other things I have a "TeamID" and a "TeamName". In Table "Match" amongst other things I have a "HomeTeamID" and an...
