Drop table if exists in SQL Get link Facebook X Pinterest Email Other Apps August 17, 2022 Create temp table in SQL Server drop table if exists #sfa_measurementinto #sfa_measurement Get link Facebook X Pinterest Email Other Apps Comments
WHERE or IF function in Numpy August 12, 2022 Script union['CH'] = np.where(union['Invoice Type'] == 'Normal Sales', union['Channel Name'],'Wedding & Function') Explanation IF "Invoice Type" = "Normal Sales" then union['CH'] = union['Channel Name'] Else union['CH'] = "Wedding & Function" Read more
Read Parquet file in pandas August 12, 2022 callplan_202205 = pd.read_parquet('../../ReportMart/Call_Plan/data/call_plan_202205.parquet', engine='pyarrow') Read more
SQL Server shortcut keys August 18, 2022 SQL Server Management Studio keyboard shortcuts - SQL Server Management Studio (SSMS) | Microsoft Docs Read more
Comments
Post a Comment