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 John Tel 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: deswalker
  • Content: Threads
  • Order by date
  1. deswalker

    Global logon change using Crystal Enterprise

    The database password is changing at the end of this month and I need to change all the Crystal reports thru Enterprise - Crystal Administration tools. How can I change the password to all the reports? I new to this so I'd appreciate step by step instructions. The DBA is willing to help me...
  2. deswalker

    check the last position of the field

    Help! I'm a newbie, working via query analyzer I need to pull as claims where the service code ends in "T" on a varchar(6) field. The 6 th position is blank in many of the rows. the code could end at any position.
  3. deswalker

    Position variables in output using Query Analyzer

    Using Query Analyzer version SQL 8.00.194. Help! I've created output that I need to send out in a .txt file. The file calls for variables to be at a specific position. example: element length start end ------- ------ ----- --- Name 60 1 60 line 1 61...
  4. deswalker

    Separate a field into two files when a space is found

    I'm using Crystal 10. I'm working with many excel files to join with our existing SQL database. The problem is that the name field is mixed (last name first name AND first name last name) I'm looking to match this full name field by name with my last name first name fields. I think I need to...
  5. deswalker

    Count one or first occurence to compute percentage

    Using CR10, I'm looking to determine the percent screened by age group, but the numerator should not include duplicate members with a screening. ex. Member AgeGroup Screened 1 6-9 yrs Y 1 6-9 yrs Y 1 6-9 yrs N 2 6-9 yrs N 3 6-9 yrs Y...

Part and Inventory Search

Back
Top