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!

Register Log in
  • Congratulations derfloh 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: mhdragon17
  • Content: Threads
  • Order by date
  1. mhdragon17

    Problem with a SUM

    SELECT STD_DEMO_DISTRICT.ID_STD_DEMO_DISTRICT, FAM_STUDENT_FAMILY.ID_FAM_FAMILY_INFO, ParticipantAccount.Balance FROM STD_DEMO_DISTRICT INNER JOIN StudentPersonal ON STD_DEMO_DISTRICT.RefId = StudentPersonal.RefId INNER JOIN Participant ON StudentPersonal.RefId = Particiapnt.RefId INNER JOIN...
  2. mhdragon17

    Problem working with asterisks

    this is more a visual studio question, but i figured someone would be able to answer it... what is wrong with this =IIF ( Fields!AttendanceCode.Value = "\*" OR Fields!AttendanceCode.Value = "P", "Normal", "Bold") Somebody decided to use an asterisk in the database to make it a little more...
  3. mhdragon17

    nested query problem

    Okay, I am beginning to program in t-sql and everything is going well except for one problem. I have status dates in one table, attendance dates in another table. The status dates are based on personalids, and all are in a table. i know to join on the id, but i need the most recent status date...

Part and Inventory Search

Back
Top