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?]
Could someone please tell me, what the Python Code equivalent would be ?
I’ve edited your post for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.
See this post to find the backtick on your keyboard. The “preformatted text” tool in the editor (</>) will also add backticks around text.
I actually have a Python Code, using Pandas in Jupyter Notebook, getting a DataFrame from an. xls Excel File. but I have hit an issue, with the Code.
I have a friend who, is good with SQL Code, and he is trying to, to help me by writing Code in SQL, to do what I want. That particular part of the current Code, is significant to the issue I have. Could I post the full Python Code here ?
The issue I am talking about is covered in the following Link, on page 3 Of that Thread :-