A collection of snippets that might be useful for among others:

- sql
- R
- python
- iPython
- conda

and more


## sql
cte
```sql
with cte1 as (
  select *
  from dbo.someTable
), cte2 as (
  select *
  from cte1
)  select *
from cte2
```


sql switch using case:
```sql
SELECT
  var = case
             when col1 = 1 then 1
             when col1 = 2 then 2
        end
FROM dbo.someTable
```

## python

## R

## git

## iPython
Install kernel in conda environment using:
```bash
source activate myenv
python -m ipykernel install --user --name myenv --display-name "Python (myenv)"
```
List/delete all jupyter kernels
```bash
jupyter kernelspec list
jupyter kernelspec remove myenv
```