A=FVXMLDEMOSOO1&B=THRK$DHJK99&DEPAP=CCU&DEPDATE=20181201&DEPHR=1300
Declare @XMLFlight XML = '2018-12-03 RILEY fvXML 3.0.5.56 A=FVXMLDEMOSOO1&B=THRK$DHJK99&DEPAP=CCU&DEPDATE=20181201&DEPHR=1300 0 47 flight(s) found for this request 797 6E IndiGo 2018-12-01 320 VTIGW CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IXB BAGDOGRA AIRPORT BAGDOGRA IN 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 797 6E IndiGo 2018-12-01 6488 6E IndiGo 2018-12-01 320 VTIDW CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 DEL INDIRA GANDHI INTL DELHI IN 1D 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 6488 6E IndiGo 2018-12-01 272 SG SpiceJet 2018-12-01 737 VTSPP DO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 IXZ VEER SAVARKAR INTL PORT BLAIR IN 2018-12-01 J Y 2 2 272 SG SpiceJet 2018-12-01 557 6E IndiGo 2018-12-01 320 VTINV CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 GAU LOKPRIYA GOPINATH BORDOLOI INTL GUWAHATI IN 2018-12-01 2018-12-01 2018-12-01 J Y 5 5 557 6E IndiGo 2018-12-01 524 I5 Air Asia 2018-12-01 320 CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 IMF IMPHAL IMPHAL IN 2018-12-01 J Y 1 1 455 6E IndiGo 2018-12-01 320 VTITU CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 DIB DIBRUGAH DIBRUGAH IN 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 455 6E IndiGo 2018-12-01 711 9I Airline Allied Services 2018-12-01 ATR CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 SHL SHILLONG AIRPORT SHILLONG IN 2018-12-01 J Y 1 1 202 6E IndiGo 2018-12-01 320 VTIHL CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 AMD SARDAR VALLABHBHAI PATEL INTL AI AHMEDABAD IN 1 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 202 6E IndiGo 2018-12-01 541 G8 GoAir 2018-12-01 320 VTWGK CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 51 2018-12-01 2018-12-01 2018-12-01 IXB BAGDOGRA AIRPORT BAGDOGRA IN 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 546 G8 GoAir 2018-12-01 713 AI Air India 2018-12-01 319 VTSCB AD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IMF IMPHAL IMPHAL IN 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 744 AI Air India 2018-12-01 711 AI Air India 2018-12-01 319 VTSCA AO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 AJL LENGPUI AIZAWI IN 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 234 AI Air India 2018-12-01 6616 6E IndiGo 2018-12-01 320 VTIVD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 DEL INDIRA GANDHI INTL DELHI IN 1D 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 6616 6E IndiGo 2018-12-01 321 6E IndiGo 2018-12-01 320 VTIHP CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IXA AGARTALA AGARTALA IN 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 321 6E IndiGo 2018-12-01 76 SG SpiceJet 2018-12-01 737 VTSGH DO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 DAC HAZRAT SHAHJALAL INTL DHAKA BD 2018-12-01 J Y 1 1 623 SG SpiceJet 2018-12-01 761 G8 GoAir 2018-12-01 320 VTWAH CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 56R 2018-12-01 2018-12-01 2018-12-01 PAT PATNA AIRPORT PATNA IN 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 761 G8 GoAir 2018-12-01 874 6E IndiGo 2018-12-01 320 VTIEO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IMF IMPHAL IMPHAL IN 2018-12-01 2018-12-01 2018-12-01 J Y 3 3 874 6E IndiGo 2018-12-01 657 SG SpiceJet 2018-12-01 737 VTSPU DO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 GAU LOKPRIYA GOPINATH BORDOLOI INTL GUWAHATI IN 2018-12-01 J Y 2 2 657 SG SpiceJet 2018-12-01 722 VQ NovoAir 2018-12-01 AT7 CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 DAC HAZRAT SHAHJALAL INTL DHAKA BD 2018-12-01 J Y 1 1 275 6E IndiGo 2018-12-01 320 VTIDM CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 MAA CHENNAI INTL CHENNAI IN 1 2018-12-01 2018-12-01 2018-12-01 J Y 2 3 275 6E IndiGo 2018-12-01 433 6E IndiGo 2018-12-01 320 VTIDX CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IXB BAGDOGRA AIRPORT BAGDOGRA IN 2018-12-01 2018-12-01 2018-12-01 J Y 2 4 433 6E IndiGo 2018-12-01 247 AI Air India 2018-12-01 319 VTSCG AD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 KTM TRIBHUVAN INTL KATHMANDU NP I 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 730 AI Air India 2018-12-01 624 9W Jet Airways 2018-12-01 8851 EY Etihad Airways 6427 NH All Nippon Airways 8045 VS Virgin Atlantic 7M8 VTJXA AE CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 BOM SAHAR INTL AIRPORT MUMBAI IN 2 2018-12-01 2018-12-01 J Y 1 1 9711 AI Air India 9711 9I Airline Allied Services 2018-12-01 ATR CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 SHL SHILLONG AIRPORT SHILLONG IN 2018-12-01 J Y 1 1 771 AI Air India 2018-12-01 319 VTSCL AD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 BLR BENGALURU INTL BANGALORE IN 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 772 AI Air India 2018-12-01 102 G8 GoAir 2018-12-01 320 VTWGO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 30 2018-12-01 2018-12-01 2018-12-01 DEL INDIRA GANDHI INTL DELHI IN 2 83L 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 102 G8 GoAir 2018-12-01 958 6E IndiGo 2018-12-01 320 VTIGI CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 BLR BENGALURU INTL BANGALORE IN 2018-12-01 2018-12-01 2018-12-01 J Y 4 4 958 6E IndiGo 2018-12-01 892 6E IndiGo 2018-12-01 320 VTIFF CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IXA AGARTALA AGARTALA IN 2018-12-01 2018-12-01 2018-12-01 J Y 3 3 394 6E IndiGo 2018-12-01 320 VTIEX CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 JAI JAIPUR INTL AIRPORT JAIPUR IN 2 2018-12-01 2018-12-01 2018-12-01 J Y 2 3 394 6E IndiGo 2018-12-01 378 6E IndiGo 2018-12-01 320 VTIZH CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 IDR DEVI AHILYABAI HOLKAR INDORE IN 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 376 6E IndiGo 2018-12-01 765 AI Air India 2018-12-01 321 VTPPE AD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 MAA CHENNAI INTL CHENNAI IN 1 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 766 AI Air India 2018-12-01 3218 SG SpiceJet 2018-12-01 DH8 CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 IXS SILCHAR SILCHAR IN 2018-12-01 J Y 1 1 326 6E IndiGo 2018-12-01 320 VTIEM CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 BOM SAHAR INTL AIRPORT MUMBAI IN 1 2018-12-01 2018-12-01 2018-12-01 J Y 1 1 323 6E IndiGo 2018-12-01 417 6E IndiGo 2018-12-01 320 VTIGU CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 DEL INDIRA GANDHI INTL DELHI IN 1D 2018-12-01 2018-12-01 2018-12-01 J Y 2 2 417 6E IndiGo 2018-12-01 249 SG SpiceJet 2018-12-01 737 VTSZL AD CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 BLR BENGALURU INTL BANGALORE IN 2018-12-01 2018-12-01 J Y 1 1 248 SG SpiceJet 2018-12-01 244 6E IndiGo 2018-12-01 320 VTITK CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 2018-12-01 2018-12-01 GAU LOKPRIYA GOPINATH BORDOLOI INTL GUWAHATI IN 2018-12-01 2018-12-01 2018-12-01 J Y 4 4 244 6E IndiGo 2018-12-01 277 SG SpiceJet 2018-12-01 7M8 VTMXD DO CCU NETAJI SUBHAS CHANDRA BOSE INTL KOLKATA IN 2018-12-01 MAA CHENNAI INTL CHENNAI IN
06060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606060606'
SELECT
-- t.value('(@FlightId)', 'nvarchar(max)')
t.value('(FlightViewResults/Flight/FlightId/FlightNumber)[1]', 'nvarchar(max)')
--,t.value('(FlightId/CommercialAirline/AirlineId/AirlineCode)[1]', 'nvarchar(max)')
--,t.value('(FlightId/CommercialAirline/AirlineName)[1]', 'nvarchar(max)')
FROM @XMLFlight.nodes('Flight') AS TempTable(t)
I am Trying to Find Out Value of FlightId Number and Next etc value but i did Not get value from My Select Query So Please help Me
Jignesh KumarPosted Dec 2, 2018, 11:45 PM