Search results for query: *

Thanks Ryan. That helped a lot.

Would never go over that.. Not all the records would need the sequence number

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...

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

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...

I figured it out by using the following =IF(ISERR(FIND("PIC S9",A1,1)),FALSE,FIND("PIC S9",A1,1)) Thanks for your help

I tried what you suggested and nothing happened. I choose "Use a formula to determine which cells to format" add this in the formula =$A1="PIC S9" and then selected the color that I wanted. It took the formula but didn't highlight any of the rows where PIC S9 is in the 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...

If you could that would be great...

Let me ask one other thing about this, is there a way to make this dynamic in the sense of, not having to "decalre" each column name in the list that you stated. Basically is there a way to make this dynamic so it would do the same with either a smaller or larger number of columns. Just...

Thanks markros

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...