this should do the trick

hth Mike

drop table #tests

create table #tests

(

 valone char(20),

 valtwo char(20)

)

insert into #tests values('12345','23456')

insert into #tests values('22345','33456')

insert into #tests values('32345','43456')

insert into #tests values('42345','53456')

--data is stored in one var sum...

Hi could you post you DDL. Do you need to convert the data to a decimal and move it somewhere? Or do you just need the output in a decimal...

Thanks for the lift. There is always a bright side. In this case it is the red circle on my forhead from beating it aganist a brick wall for two...

What is the relationship between t1 and t2? What is the business rule for determining the value in t2?

Mike

Check BOL, under syscomments. You can also include comments when you create/modify your tables in SQL statements in QA or enterprise manager. These comments are not compiled and do not add to the...

My test results match govinn's. Test results for both programs set to not start timer until after value is loaded into the array. (in both cases it requires about 0.0156 seconds to...

The format YYYYMMDD hh:mm:ss (no quotes) is the iso standard for dates. Frank posted a great link for information on dates. But I did not find it (must be located...

Vasc your alg runs fast in the VB version searching for numbers ending in 4 or 9. I should have know that the inability to have a combination of numbers that ended 4 or...

Vasc there is no possible combination of numbers from this data set that be summed so that the digit in the units column (right most column) can end in either...

Thanks, I am still using Visual Studio 6.0 and have not changed to C#. But I should be able to translate this to either c++ or VB. 

The value of the return code should not have a meaning. Always return +1."

Knowing if a procedure passed or failed is vauable information and has a definite meaning.