System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The column 'Y201609' was specified multiple times for 'B'. The column 'Y201609' was specified multiple times for 'A'. The column 'Y201609' was specified multiple times for 'B'. The column 'Y201609' was specified multiple times for 'B'. The column 'Y201609' was specified multiple times for 'A'. DECLARE @IINT VARCHAR(max) DECLARE @JINT VARCHAR(max) SET @IINT=1 SET @JINT=1 DECLARE @MFINAL TABLE(YC INT,COLCOUNT INT,VAL FLOAT) DECLARE @MFINALVarchar TABLE(YC INT,COLCOUNT INT,VAL Varchar(max)) DECLARE @MTEMP TABLE([R] [INT] IDENTITY (1, 1) NOT NULL ,DTTYPE Varchar(max),DISPORDER int,YEAR1 FLOAT) DECLARE @MAINT TABLE([R] [INT] IDENTITY (1, 1) NOT NULL, A1 float,A2 int,A3 int,A4 float,A5 float,A6 float,A7 float,A8 float,A9 float,A10 float,A11 float,A12 float,A13 float,A14 float,A15 float,A16 float,A17 float,A18 float,A19 float,A20 float,A21 float,A22 float,A23 float,A24 float,A25 float,A26 float,A27 float,A28 float,A29 float,A30 float,A31 float,A32 float,A33 float,A34 float,A35 float,A36 float,A37 float ) INSERT INTO @MAINT( A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37) SELECT QTR,Date_End,Case Isnull(AUDITED,'U') When 'U' Then 1 Else 0 End,Net_Sales,Expenditure,isnull(Net_Sales,0)-isnull(Expenditure,0),Other_Income,Operating_Profit,Interest,Exception_Items,Gross_profit,Depreciation,Pbt,Tax,PAC,Pat,EI,PPI,Other_Adjustments,Net_Profit,Minority_interest,Shares_Associate,Other_related_items,Misc_expd_woff,Consolidated_net_profit,Equity_Cap,Fv,Reserves,EPS_BASIC,EPS_BASIC_EXTRAORD,Case When Isnull(Prom_No_Of_Shares,0)=0 Then nsTotalpublic Else Prom_No_Of_Shares End as Prom_No_Of_Shares,Case When Isnull(Prom_Percent_Of_Shares,0)=0 Then tpTotalpublic Else Prom_Percent_Of_Shares End as Prom_Percent_Of_Shares,dbo.Dividefn((isnull(Net_Sales,0)-isnull(Expenditure,0)),isnull(Net_Sales,0))*100,dbo.Dividefn((Total_Income-Expenditure),Net_Sales)*100,dbo.Dividefn((Isnull(PBT,0)+Isnull(Depreciation,0)),isnull(Net_Sales,0))*100,dbo.Dividefn(isnull(PBT,0),isnull(Net_Sales,0))*100,dbo.Dividefn(isnull(PAT,0),isnull(Net_Sales,0))*100 FROM RESULTS R Left Outer Join ( Select Fincode as ShpFincode,Date_End as Shp_DateEnd,nsTotalpublic, tpTotalpublic from shp_Summary Where FINCODE=132286 )Q On R.Fincode=Q.ShpFincode And R.Date_End=Q.Shp_DateEnd WHERE FINCODE=132286 AND RESULT_TYPE='Q' and Validated='T' and R.Type='C' ORDER BY DATE_END DESC INSERT INTO @MTEMP(DTTYPE,DISPORDER ) SELECT DATATYPE,DISPORDER FROM RESTULT_DISPLAYFORMAT Where Isnull(FIELDNAME,'') <>'' and Format='MAN' and Mode='S' and Type='C' and ACTIVE='T' ORDER BY DISPORDER WHILE (@IINT<=4) BEGIN UPDATE M SET M.YEAR1 =CASE M.R WHEN 1 THEN A1 WHEN 2 THEN A2 WHEN 3 THEN A3 WHEN 4 THEN A4 WHEN 5 THEN A5 WHEN 6 THEN A6 WHEN 7 THEN A7 WHEN 8 THEN A8 WHEN 9 THEN A9 WHEN 10 THEN A10 WHEN 11 THEN A11 WHEN 12 THEN A12 WHEN 13 THEN A13 WHEN 14 THEN A14 WHEN 15 THEN A15 WHEN 16 THEN A16 WHEN 17 THEN A17 WHEN 18 THEN A18 WHEN 19 THEN A19 WHEN 20 THEN A20 WHEN 21 THEN A21 WHEN 22 THEN A22 WHEN 23 THEN A23 WHEN 24 THEN A24 WHEN 25 THEN A25 WHEN 26 THEN A26 WHEN 27 THEN A27 WHEN 28 THEN A28 WHEN 29 THEN A29 WHEN 30 THEN A30 WHEN 31 THEN A31 WHEN 32 THEN A32 WHEN 33 THEN A33 WHEN 34 THEN A34 WHEN 35 THEN A35 WHEN 36 THEN A36 WHEN 37 THEN A37 END FROM @MTEMP M,@MAINT T WHERE T.R=@IINT and M.DTTYPE in ('float','int') INSERT INTO @MFINAL(YC,VAL,COLCOUNT) SELECT @IINT,YEAR1,R FROM @MTEMP SET @IINT=@IINT+1 END Select * from ( Select B.DispOrder as Disp,B.BOLD,B.DESCRIPTION,B.HTML_HEAD as Display,B.NULLVALUE,A.* from (Select * from RESTULT_DISPLAYFORMAT Where Format='MAN' and Mode='S' and Type='C' and ACTIVE='T' ) B Left Outer Join ( SELECT A.DISPORDER,B.* FROM @MTEMP A INNER JOIN ( SELECT COLCOUNT AS RID, MAX(CASE YC WHEN 1 THEN VAL ELSE NULL END) AS Y201612,MAX(CASE YC WHEN 2 THEN VAL ELSE NULL END) AS Y201609,MAX(CASE YC WHEN 3 THEN VAL ELSE NULL END) AS Y201609,MAX(CASE YC WHEN 4 THEN VAL ELSE NULL END) AS Y201606 FROM @MFINAL GROUP BY COLCOUNT )B ON A.R=B.RID )A On B.DispOrder =A.DispOrder And B.FORMAT='MAN' )B Order by Disp Select * from ( Select B.DESCRIPTION,b.useunit from (Select * from RESTULT_DISPLAYFORMAT Where Format='MAN' and Mode='S' and Type='C' and ACTIVE='T' ) B Left Outer Join ( SELECT A.DISPORDER,B.* FROM @MTEMP A INNER JOIN ( SELECT COLCOUNT AS RID, MAX(CASE YC WHEN 1 THEN VAL ELSE NULL END) AS Y201612,MAX(CASE YC WHEN 2 THEN VAL ELSE NULL END) AS Y201609,MAX(CASE YC WHEN 3 THEN VAL ELSE NULL END) AS Y201609,MAX(CASE YC WHEN 4 THEN VAL ELSE NULL END) AS Y201606 FROM @MFINAL GROUP BY COLCOUNT )B ON A.R=B.RID )A On B.DispOrder =A.DispOrder And B.FORMAT='MAN' )B --Order by Disp at MintCompanyService.GetResults(String Mode, String FinCode, String YEARCOUNT, String RType, String sOpt2, String sOpt3, String sOpt4, String sOpt5) in d:\websites\websites\MintCompanyService\App_Code\MintCompanyService.cs:line 523 --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at CompanyService.MintCompanyService.GetResults(String Mode, String FinCode, String YEARCOUNT, String RType, String sOpt2, String sOpt3, String sOpt4, String sOpt5) at test_quaterly_results.BindQuarterlyResultsData(String yr, String type) Jindal Steel & Power Ltd. Quarterly Results
29 Apr 2017 | Livemint.com

BSE
NSE
Last Updated: Mar 31, 03:52 PM
Jindal Steel & Power Ltd.

BSE

  • 120.95 2.05 (1.72%)
  • Vol: 2250031
  • BSE Code: 532286
  • PREV. CLOSE
    118.90
  • OPEN PRICE
    120.80
  • BID PRICE (QTY.)
    120.95(73)
  • OFFER PRICE (QTY.)
    0.00(0)

NSE

  • 121.00 0.00 (0%)
  • Vol: 15018988
  • NSE Code: JINDALSTEL
  • PREV. CLOSE
    121.00
  • OPEN PRICE
    121.00
  • BID PRICE (QTY.)
    0.00(0)
  • OFFER PRICE (QTY.)
    121.00(4903)

Jindal Steel & Power Ltd. Quarterly Results

Quarters
Select year