BICube

BICube has asked 7 questions and find answers to 18 problems.

Stats

About

Data Generalist.

BICube questions

Drop all columns in a table if their names follow a specific pattern in SQL Server
setting a measure value to NULL if a particular dimension is used in excel
Adding a counter column for a set of similar rows in R [duplicate]
CROSS JOIN with one empty table sql server

BICube answers

Adding multiple columns in pyspark dataframe using a loop
I need to find a way to delete everything after the third .bak file in a SQL Server backup folder
How to calculate difference between 2 times in SQL
Grouping and counting of records in Haversine Formula SQL Query
How to remove the begining and ending characters if those are '0' in SQL Server
Adding primary key to some exising tables in a database
How to execute a stored procedure in Azure Databricks PySpark?
SSAS dealing with non linked data
SQL Server 2012 Random string from a list
Finding common rows in R