Snippet 005

1SELECT TOP 1002       s.PROCHI,3       s.PRESCRIBED_DATE,4       s.SCAN_REF_NO,5       s.line_no,6       i.Approved_Name,7       i.formatted_BNF_Code,8       i.Strength,9       i.Formulation_code10FROM Project_12345..Prescribing_Scripts s11INNER JOIN Project_12345..Prescribing_Scripts_Prescribing_Item i12    ON s.hic_drugID = i.hic_drugID13ORDER BY NEWID()

1with engine.connect() as conn:2    df = pd.read_sql("""3        SELECT TOP 1004               s.PROCHI,5               s.PRESCRIBED_DATE,6               s.SCAN_REF_NO,7               s.line_no,8               i.Approved_Name,9               i.formatted_BNF_Code,10               i.Strength,11               i.Formulation_code12        FROM Project_12345..Prescribing_Scripts s13        INNER JOIN Project_12345..Prescribing_Scripts_Prescribing_Item i14            ON s.hic_drugID = i.hic_drugID15        ORDER BY NEWID()16    """, conn)17 18df.head()

1df <- dbGetQuery(conn, "2    SELECT TOP 1003           s.PROCHI,4           s.PRESCRIBED_DATE,5           s.SCAN_REF_NO,6           s.line_no,7           i.Approved_Name,8           i.formatted_BNF_Code,9           i.Strength,10           i.Formulation_code11    FROM Project_12345..Prescribing_Scripts s12    INNER JOIN Project_12345..Prescribing_Scripts_Prescribing_Item i13        ON s.hic_drugID = i.hic_drugID14    ORDER BY NEWID()15")16 17head(df)