pls write an explaination for u r syntax, shall i write this way ?

no dude,

there are around 70 text boxes, the text field which will have value will be disabled and wont allow edit

the text field which are blank will be editable,

this...

actually what i wanted to do is , iam displaying some reports

what i thought instead of some sql queries firing from an asp page and then displaying report,

THERE...

i got the solution, basically it was not the parameter, but sql was giving message of datatype error, actually the error was in union

we need to have same order of...

i tried it with numeric int, but it doesnt work.

thanks for answer, but is there any other simple way like correlated subquery, iam new to 2000 just shifted from 7 to 2000

never written any function

sorry i forgot to paste the query

here is my query

-----------

SELECT '1'=1,RMCPL_PACK_SIZEApr,RMCPL_SAMPLE_MASTER.RMCPL_SAMPLE_NAME AS sample,

RMCPL_EXPECTED_DT,ss.RMCPL_SAMPLE_NAME as APPROVEDSAMP,

BALQTY=(RMCPL_REQUISITION.RMCPL_QTY_APPROVED-sum(isnull(DispatchQty,0))),

RMCPL_REQUISITION.RMCPL_QTY_APPROVED,RMCPL_SAMPLE_MASTER.RMCPL_SAMPLE_CD,

RMCPL_EMP_MASTER.RMCPL_EMP_NAME AS Emp,RMCPL_REQUISITION.RMCPL_PACK_SIZE,

RMCPL_REQUISITION.RMCPL_QTY_REQUIRED, RMCPL_REQUISITION.RMCPL_DATE,RMCPL_REQUISITION.RMCPL_TID

FROM RMCPL_REQUISITION INNER JOIN RMCPL_SAMPLE_MASTER

ON RMCPL_REQUISITION.RMCPL_SAMPLE_CD...

aminnagpure@fastmail.fm post it here so that others can also see

does anybody has an answer to this super critical problem

thanks for ur answer, but that was not very useful, iam using sql2000

where shoiuld i write that function in sql 2000 ?., or what exactly

No dude, iam saying u r suggestion of using @@identity is the best 1 and iam using it,

but before that i was using 1 cursor to get the maxvalue from...

thanks a Lot , for ur suggestion but better alternative will be to declare all the variables as varchar, it works d00d,

even while inserting u can use varchar, and it...

that was great for the this i declare a cursor and got the max value and assumed that this is the latest identity value, thats great u ppl solved my...

where is the option for Triggers in SQL-SERVER 2000 just like sql 7.0 ?/

i have searched but not find

Same Case With me,

but iam trying some other methods, if u find any suitable pls post it, so that we can use it.