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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Kikster813
- Order by date
-
Update query with sub query need top 1 of data
Never mind...I figured it out! And it worked perfectly...thanks so much! update tblPREmpDeductions set ORRetMemberStatus = a.orstatuscode, ORRetMemberStatusBeginDate = a.orstatusbegdate, ORRetMemberStatusEndDate = a.orstatusenddate FROM...- Kikster813
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Update query with sub query need top 1 of data
I pasted that into my query window and i don't think all the syntax is there. Where would I put the "FROM tblPROREmpMemberStatus" in the sub query? Thanks for your help so far.- Kikster813
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Update query with sub query need top 1 of data
I have a table (tblPROREmpMemberStatus)with a foreign ID, code, start date and end date. There can be multiple records per foreign ID. I want to update another table (tblPREmpDeduductions) with the values from the record from the first table that has the most recent start date. This is what...- Kikster813
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
