I am having two columns in my display output, first one is previous_month_value and the second column is current_month_value. I am calculation...
Hi, Table Values Syscode Value 1 100 2 200 3 300 4 300 5 500 6 500 From the above table i am tring to retrive the...
Thank u very much friends.......
Thank u very much Dinakar and Adriaan....I also wrote one function....Please check whether this is feasible.... create FUNCTION fn_getmonth ( --...
Hi, I am having to values from Date (15-Jan-2007)and to date (15-Feb-2008) now I want the result in a table having two columns 'start date ' ---->'01...
Thank u very much ya it's working and I execute after the 'begin transaction' statment.
Hi, Table 1 user_syscode date value1 1 01-jan-2006 10 2 05-jan-2006 40 Table 2...
Frankkalis ur Link is very useful for me I got the result from that Link... Thank u all
Thank u Adriaan Regards, Prabhu.
Hai Table : scheme_master temp_scheme_syscode scheme_syscode status ------------------ -------------- ------- 166...
sorry i didn't notice the return type... S.Jeya Prabhu "A ship in Harbour is safe, But that is not what ships are built for."
Try this also.... SELECT convert(varchar,DATEADD(day, 90, current_timestamp),110) AS "RETURNDAYS" RETURNDAYS...
But if we put not exists I display nothing but I got that by put min(folio_map.customer_syscode) and use group by function Thank u ramkumar S.Jeya...
Ram alignment is not working fine....I just align and sent...
Hai friends...I am inserting values from the temp table to the customer bank detail table and in the bank detail table in am having bank account...
To smy Thank u very much, Its works fine... Thanks to all.
Only one record is get affected... select t1.position_date,t1.to_date from fiv_position_limit t1 where isnull(to_date,0) in (select top 1...
To ranjitjain If we add that position_date to_date ---------------------- ------- 2006-06-08 00:00:00.000 NULL won't...
Hello position_date to_date ------------------------------...
To Frank This calculation is to find the BSE (Bombay Stack Exchange)...for that we have to find varience instead of adding and between range of...
Separate names with a comma.
