well, each table has 5 fields. one of the field is called TestID. In this field there are records like 100, 200, 1001, 4000, 20034, 49595 etc. It is an...

Thanks for the quick reply.

I have to find few TestIds which are stored in one of the tables out of this 100 tables. All the tables have the same column...

works... you guys rock...

Thanks a lot....

To be honest, all I know is this is the function to be applied on the data... don't know the real business logic behind it...

Yes, this works... Thanks a lot everyone...

One more point,

I also would like to do the opposite for power function as well...

Instead of ---- ...

Yes CAST is not needed for 10000.0..

probably case statement to differentiage positive and negative values from column1.

can this be true?

create table #t ( column1 float );

declare @TestVar float;

set @TestVar = -975.81;

insert into #t select @TestVar;

select column1, -POWER (abs(column1), 1.8) * CAST(10000 as...

Thanks Peter & Lynn,

I shall get back to you very soon on exact reqs...

I think this is because I do have some negative values in my table. and I replaced the values in above code and it doesnt work...

create table #t (

...

Lynn,

Thanks for your quick reply.. If I do,

select POWER (column1, 1.8) * 10000.0 as newvalue from #temp with (nolock)

it gives me an error:

Msg 3623, Level 16, State 1, Line...

Try this...

create table #pvt (name varchar(100), Date datetime) alter table #pvt alter column date datetime

insert into #pvt (Name, Date) values ('A','1/1/07')

insert into #pvt (Name, Date) values ('B','12/2/07')

insert into #pvt (Name,...

use this.....

create table #test (Name varchar(100), Class varchar(100), Subclass varchar(100))

insert into #test (Name, Class, SubClass) values ('Tom','Animal','Cat')

insert into #test (Name, Class, SubClass)values ('Jerry','Animal','Mouse')

insert into #test (Name, Class, SubClass)values ('Ballo','Animal','Bear')

insert into...

Herman,

Try this...

create table #test (Name varchar(100), Class varchar(100), Subclass varchar(100))

insert into #test (Name, Class, SubClass) values ('Tom','Animal','Cat')

insert into #test (Name, Class, SubClass)values ('Jerry','Animal','Mouse')

insert into #test (Name, Class, SubClass)values ('Ballo','Animal','Bear')

insert into...

try using pivot table. That should help.

will bulk insert work if I have files lying on my local desktop?