Reputation
1,271
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 13 44
Newest
 Caucus
Impact
~90k people reached

1d
awarded  Caucus
Jul
9
awarded  Popular Question
Jul
3
awarded  Popular Question
Jun
9
awarded  Notable Question
May
21
awarded  Notable Question
May
11
awarded  Yearling
Apr
9
awarded  Notable Question
Feb
26
awarded  Popular Question
Feb
12
comment Sum(Case When) Question
yup, without running the code myself that seems to be the issue.
Feb
12
awarded  Nice Question
Feb
12
awarded  Nice Question
Feb
9
answered Best practice - Update Primary Keys
Feb
6
comment Why would a default constraint be missing an index?
@DanGuzman that seems to have done it.
Feb
6
comment 1 hour query, is there another way to do this?
@koljanep i didn't expect it to work right out of the box, was more trying to provide a general layout for you to use. As far as i can tell, without the actual database to play with, this should work.
Feb
6
comment Medical History - Is this DB properly design?
What happens when a patient changes doctors?
Feb
6
revised 1 hour query, is there another way to do this?
added 313 characters in body
Feb
6
answered 1 hour query, is there another way to do this?
Feb
6
comment Updating one table from another table where non-primary-key field is similar string
@CarenRose yeah it sucks when you get so far and then realize that you're missing vital data. but it's always best to do it this way so that you can 100% ensure data quality.
Feb
3
comment Why would a default constraint be missing an index?
@a_horse_with_no_name added
Feb
3
revised Why would a default constraint be missing an index?
added code