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 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: *

  1. TennisNut

    Sql Query to find latest score using Max of 2 Dates

    markros, thanks for the quick reply...unfortunatley, I am unable to use PIVOT.
  2. TennisNut

    Sql Query to find latest score using Max of 2 Dates

    Hello All, I am trying to write a SQL Query against a DB2 database to find the latest 2 scores for each individual. (I know this is a SQL Server forum, but the DB2 forum did not have many posts regarding SQL Queries). To simplify: Table1 has indiv#, scrid#, datetime1, score1 Table2 has scrid#...
  3. TennisNut

    Calculate % of 1 column to another in Crosstab

    Hi all, CRXI A record with negative amount = fee A record with a positive amount = refund Have Crosstab in Group Header (group is a dummy group: WhileReadingRecords; 1) like: mo/yr Fees Refunds 01/10 1,595.00 375.50 02/10 975.80 140.65 etc Mo/Yr is grouped by...
  4. TennisNut

    Error Message: Logon failure: unknown user name or bad password

    Thanks for the response Turkbear. Yes, the job servers are under an account with rights to the destination, so I am told by our Network Admin. Well, after many trial and errors, I have a solution... On the Schedule-Destination page, for the User Name I have to put our domain name first and then...
  5. TennisNut

    Error Message: Logon failure: unknown user name or bad password

    Here is my dilemma, Crystal Reports Server XI Trial on Windows Server 2003 R2 Standard with Sql Server 2000. From CRS XI, added report created in CR XI Trial on WinXP client. Able to Preview report from Properties tab and in Infoview. Unable to schedule unmanaged disk to another server. Get...

Part and Inventory Search

Back
Top