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 bkrike 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: samsci
  • Content: Threads
  • Order by date
  1. samsci

    outer joins on more than 2 tables.

    Is it possible to do an outer join on more than 2 tables in ReportSmith? I know the unmatched records does not allow it, but was hoping that it could be accomplished via selections criteria. If it is possible, could someone give an example in sql server. Thanks!
  2. samsci

    creating macros for a crosstab.

    I have 3 fields from a table PS_JOB. They are emplid, deptid and empl_status. Creating the crosstab is pretty easy. I list the deptids and the total number of employees in each deptartment. However, I also need the following. 1). Total active employees in each department. 2). Total...

Part and Inventory Search

Back
Top