hey jeff

thanx for ur help.what do u mean by "logged"?

i practically understood that trigger does not get fired when bulk insert is run.

regards

Rajiv.

hey sukhoi

thanx for the reply. apart from that reason there is no difference in "functions" and "stored proc with recompile option"?

regards

Rajiv.

Thanks Jonathan and Edwin. I will try as u said and tell u wat happened. Thanks a lot

Regards,

Rajiv.

hey david

why not try the "cast" or "convert" methods

regards

Rajiv.

hey all

thanx for all ur help.....i think i need a lot of that in future.....hey troyk can u plz elaborate on what u told. r u telling that u need...

hey all

thanx for ur help...now i got it

thanx

Rajiv.

hey allen

i think even if i declare it as decimal .....i get different results....why?

i did::::

declare @var decimal

thanx

Rajiv.

hey stojce

can u tell me why is there a id field? u already have a ordr field which i presume is a primary key.is it?

tell me whether the ordr...

hey stojce

try out this query...think it works....but ordering is a pblm

i will check it out and reply to u

table name--->s_add

select t1.rid,t1.ordr,t1.vin,t1.vout,(select sum(t2.vin-t2.vout) from s_add t2

   where t2.rid<=t1.rid)from s_add t1...

hey sudhir

i think it would be jus 33.b cos of integer division

am i right or wrong?

regards

Rajiv.

hey shawn

iam sorry iam not able to get u. do u need to delete duplicate rows?? if this is the case then u can do that.....but i did not understand...

hey veena

what is the purpose of joining the two queries?iam not clear. y not execute the two sql statements as batch statements. i mean execute both the select statements together......

the...

hey all

thanx for ur help. hey burtonjb plz give me an user-defined non-deterministic function example.

thanx

Rajiv.

hey all

thanx for all ur help. answering to ken's question-->i wanna know how to select a row based on rownumber.

is there any equivalent to rownum and rowid in oracle

thanx

Rajiv.

hey chrismi and farrell

thanx for ur help. i got ur point chrismi.

but suppose i try to insert a null value into a column (that is not supposed to contain null...