Date Column Changes in Sandbox

vanamala-narasimhan commented 5 years ago

Due Date: COB Aug 17 Description: Changing Q2 MozART data sets created in Sandbox by converting relevant columns from varchar to date

Time Needed: 20 minutes

Steps

1) Connect to Sandbox via SQL Management Studio 2) Open script (attached) that will be used to make changes 3) Determine which columns in that table needs to be date format 4) Update the script to A) the table you want B) the exact columns you want to change 5) Run Script for columns you need to change 6) Return some rows to see if it worked (in script)

Assignments

[x] Sandbox.dbo.maincohort -----Marcela
[ ] Sandbox.dbo.retention_cohort_2012_2019_12mo ----- Adelino
[x] Sandbox.dbo.test_gaac ----- Mala
[x] Sandbox.dbo.test_paciente ----- Mala
[x] Sandbox.dbo.test_hdd ------ Mala
[x] Sandbox.dbo.TX_CURR_test_OCT18 ----- Timoteo
[x] Sandbox.dbo.ViralLoadenrolledDSD1 ----- Neha
[x] Sandbox.dbo.VLsubcohort ----- Orrin

SQL Script to Change Columns to Date Format.txt

orrinft commented 5 years ago

Thanks @vanamala-narasimhan that was very easy and fast due to the great explanation in the code!

MarcelaTorresOte7 commented 5 years ago

Sandbox.dbo.maincohort -----Marcela (DONE)

TimoteoSimone commented 5 years ago

Sandbox.dbo.TX_CURR_test_OCT18 ----- Timoteo (DONE)

mozaude / MozART_ETL

Date Column Changes in Sandbox #3