I wanted to know that which one is more effecient to use Oledb templates or ADO to do database connection and recordset commands?

Thanks tcartwright. You are great!!

You would be easily visible that I am sure and getting jobs would not be a problem for you.

tcartwright!!

what do you mean by will write code for food. Is it just slogan?

If slogan then do post an example. I would appreciate your help.

I used your example and it exactly fits into it. The one you used with sets.

Even you are right I could create one table which can have all the...

chrhedga

How can I pass temporary table to stored procedure because I know that there are multiple rows at functional level?

tcartwright

are you talking that at functional level I will create...

Sometimes we start thinking impossible.

Anyway Thanks!!

Great!!

Thanks!!

Before insert also it is like this

20.800000000000001.

I don't want to change it to decimal. Is there no way to fix it to 2 decimals only

create procedure test1

@val1 float,

@val2 int

as

declare @val3 decimal(9,2)

select @val3 = @val1

insert into testtable1

(TestField1, testfield2)

values

(@val3, @val2)

-----------------------

exec test1 20.8,12

I did it and it is still storing it

20.800000000000001

sorry procedure name is without @

Insert is thru stored procedure

create procedure @test1

@val1 float,

@val2 int

as

insert into testtable

(TestField1, testfield2)

value

(@val1, @val2)

Thanks!!