Avatar

Jon Gaydos

Follow

"Sometimes life hands you lemons that are worth 2 in the bush, I like puppies." - John Lennon 6'0"; bathes regularly**; read a book once; talks good; diurnal at the moment; likes zoos; can write codes if have too; **at uniform intervals of time.

  • Total activity 5
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 3

Activity overview

Latest activity by Jon Gaydos
  • Avatar

    Jon Gaydos commented,

    1. Community
    2. BI Tool User Community
    3. SQL Issues

    For your IN problem: Instead of concatenating a bunch of strings together and using IN, I would recommend using EXISTS and move the values you are returning to the WHERE clause of the sub query. CU...

    • View comment
    • Jon Gaydos
    • Created
    • 0 votes
  • Avatar

    Jon Gaydos commented,

    1. Community
    2. BI Tool User Community
    3. user-site affiliations

    If you want to do this in a SQL query the user role affiliations are stored in public.user_term_role_aff & site affiliations in public.user_term_site_aff.  A few additional joins will be required t...