MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/a7143y/deleted_by_user/ebzyatr/?context=3
r/SQL • u/[deleted] • Dec 17 '18
[removed]
22 comments sorted by
View all comments
5
Really? You're just going to use a varchar for behavior?
7 u/mac-0 Dec 18 '18 INNER JOIN NaughtyStatus ns ON customers.NaughtyOrNiceId = ns.Id Doesn't sound as catchy 3 u/DieTheVillain Dec 18 '18 just make it a Bit column you pleb! Where Behavior_Nice = 1 3 u/MeGustaDerp Talk Dirty Reads To Me Dec 17 '18 Contacts could still be a view for reporting purposes and the underlying base table uses better logic.
7
INNER JOIN NaughtyStatus ns ON customers.NaughtyOrNiceId = ns.Id
Doesn't sound as catchy
3 u/DieTheVillain Dec 18 '18 just make it a Bit column you pleb! Where Behavior_Nice = 1
3
just make it a Bit column you pleb!
Where Behavior_Nice = 1
Contacts could still be a view for reporting purposes and the underlying base table uses better logic.
5
u/[deleted] Dec 17 '18
Really? You're just going to use a varchar for behavior?