Hello,
I have a table in SQL server that has two columns with different dollar values. I would like to create a query that looks at each value in column 1 and compares that value to each value in column two.
I would like to extract the values in column 1 that are less than 5% the values in column 2. Remember I have to compare each and every value in column 1 to all of the values in column 2, not just one value to one value.
Many thanks for your help
Jill
I have a table in SQL server that has two columns with different dollar values. I would like to create a query that looks at each value in column 1 and compares that value to each value in column two.
I would like to extract the values in column 1 that are less than 5% the values in column 2. Remember I have to compare each and every value in column 1 to all of the values in column 2, not just one value to one value.
Many thanks for your help
Jill