Hai Kenneth,

Thanks

I link this Journal table with large queries to get the journal name.

Now i think to substitute the linking of select queries with journal table to linking of...

The datatypes as

Trans_header.CompanyID -- varchar(16), Trans_header.Finyear --  varchar(15), Journal.JrlID -- varchar(10)

I repeat Journal is a master table for Journal Types. and in that i am holding the lastno.thats it.

Also I do not want...

1.I am  not using cursors.

2.All the fields i am using in where condition are primary keys (which i have already mentioned)

I just want to know the optimised method to find...

Thank a lot Vasc. It works . Great. !!

Rohini

Hey ganesh. Great ! this works fine.

Thanks a  lot.

i want the output to a variable . Only in the back end.

What will be the output of ur proc?

I want the value of the field Apr or May or June whatever it is..

Based on the value,i will perform some action..not just...

What do u mean the monthname here  ? A fieldname or parameter or command? or what is it?

Eg:

The table structure is

CompanyID     varchar(10)

Finyear       varchar(10)

April numeric(10,2)

May numeric(10,2)

June numeric(10,2)

July numeric(10,2)

and the data is

BM   2004-2005 ...

LedgerID 's datatype in table is varchar(10).

I use 'like' in the query so i pass comma separated values to the parameter.so i declared as    varchar(500). I did not specify the...

Thanks for ur help.

But There is no data type problem @ all.

The @LedgersID..  param is a varchar field and here i pass comma separated...

maddog I have tried even this. But this does not work.Any other suggestions?

The parameters are

 @GrpCompID varchar(15),

 @StDt datetime,

 @EdDt datetime,

 @LedgerIDsL varchar(500),

The Actual query i am using is

 SELECT     Trans_Detail.CompanyID, Trans_Detail.Finyear, Trans_Detail.LedgerID, Trans_Header.HORefNo,

                        Trans_Detail.JrlID, Trans_Detail.TrnNo, Trans_Detail.TrnSNo, Trans_Detail.TrnDate, Trans_Detail.AmtD, Trans_Detail.AmtC,

                        Trans_Detail.HOCode, Trans_Header.Trnmmyy, Trans_Header.Narration, Trans_Header.BillNo, Trans_Header.BillDate,

                        Trans_Header.Posted,...

Any quick help appreciated .

No the indexing is all properly given.

I want to know, an alternative function or something like that ,instead of MAX().