Feb-13-2020, 03:43 PM
Hi there,
Is there any Python Utility available on the Internet, that can convert SQL Code, to Python Code ?
Here is the SQL Code, I would like converting to Python Code :-
Regards
Eddie Winch
Is there any Python Utility available on the Internet, that can convert SQL Code, to Python Code ?
Here is the SQL Code, I would like converting to Python Code :-
SELECT * INTO #Temp4 FROM ( SELECT tt5.[Venue], tt5.[BID], MIN(tt1.[Date]) AS [Date], tt5.[Display / Flypast], SUM(tt1.[Duration]) AS [Duration (mins)], (SELECT DISTINCT '; ' + t5.[Aircraft Combined] FROM #Temp5 t5 WHERE tt5.[Venue] = t5.[Venue] AND tt5.[BID] = t5.[BID] AND tt5.[Display / Flypast] = t5.[Display / Flypast] FOR XML PATH ('')) [Aircraft Combined], SUM(tt5.[Dakota and Fighters in Same Slot?]) AS [Dakota and Fighters in Same Slot?]Any info and help would be appreciated
Regards
Eddie Winch