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

    Sequence numbering

    I need to create a sequence number for certain rows that are pulled from a raw data file that I'm getting. Here is the situation. I have a data file with about 3 million rows, which I’m able to process into various tables. However, I need to give certain rows a sequence number, basically a...
  2. French79

    Find out last time a user logged in

    Is there a way of finding out when a user last logged into the ReportServer to run a report?
  3. French79

    Check numeric value for whole and certain increment

    How can I do a data integrity check on a numeric field. I need to check to make sure that the data is a whole number and if the number is in decimal format, that the decimal is either .25, .5(0) and .75. I need to pull the rows where the data is not whole or the decimal that I indicated...
  4. French79

    EXCEL - Highlight row based on text in a cell

    I know that this has been several thousand times but I can't find the answer for what I'm trying to do. I'm able to highlight the cell based on text if I choose that cell only. I want to check every row and highlight the row if PIC S9 is anywhere in that cell on that row. The data that I want...
  5. French79

    PIVOT

    I have data the I need to put into a table. However, it's all in one row. Example is a snapshot, there are more columns in the table than listed below. ID Male Female Gender Undefined White Black Asian RaceUn 1 1 0 0 0 1 0 0 I need to look at each...

Part and Inventory Search

Back
Top