SQL Server Select With Loop on second table -

-

i struggling sql logic , wondered if can help?

i need list of id's table "roles" emailenabled true, need use these ids against table "users" on roleid column grab email addresses , return these comma separated list.

i know need use loop in here it's not strong point.

let me know if need further info.

i not recommend generating comma seperated list in sql. grab data need record-wise , handle rest in program logic.

you can data need this

select users.email users join roles on roles.id = users.roleid roles.emailenabled = 1

Comments

Post a Comment

Popular posts from this blog

javascript - Why Selenium can't find an element that is graphically visible -

-
i'm using selenium test appllication running on firefox browser, when want click on button selenium, don't find it. find strange since can see element eye. have tried multiple method worked other exemple : wait.until(expectedconditions.visibilityofelementlocated(by)) wait.until(expectedconditions.presenceofelementlocated(by)); (i use xpath in path variable, , i'm sure correct) setting implictlywait on driver putting thread.sleep(1000) then again, post here because don't understand why selenium not see element diplayed on browser. important information maybe giving me proper answer html dom dynamically generate websocket triggered javascript event. edit 1: <button type="button" class="btn btn-xs btn-block btn-stroke" id="252_button"> delete </button> the element i'm trying access. use xpath it. it's not in iframe element. to access element did method supposed find , click on giving xpath in para...
Read more

android - Basic camera in app -

-
Image
i trying activate camera in app have done following , kept simple possible. androidmanifest file <uses-permission android:name="android.permission.camera"/> <uses-feature android:name="android.hardware.camera" /> <uses-feature android:name="android.hardware.camera.autofocus" /> ... <activity android:name=".cameraact" android:label="@string/app_name" > <intent-filter> <action android:name="android.intent.action.main" /> <category android:name="android.intent.category.launcher" /> </intent-filter> </activity> cameraact.class public class cameraact extends appcompatactivity { public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_camera); // have camera? if (!getpackagemanager() ...
Read more

scala - Using the kronecker product on complex matrices with scalaNLP breeze -

-
i had piece of code: def this(vectors: list[densevector[double]]) { this(vectors.length) var resultvector = vectors.head (vector <- vectors) { resultvector = kron(resultvector.todensematrix, vector.todensematrix).todensevector } _vector = resultvector } it worked way wanted work. problem needed complex values in stead of doubles. after importing breeze.math.complex, changed code to: def this(vectors: list[densevector[complex]]) { this(vectors.length) var resultvector = vectors.head (vector <- vectors) { resultvector = kron(resultvector.todensematrix, vector.todensematrix).todensevector } _vector = resultvector } this results errors: error:(42, 26) not find implicit value parameter impl: breeze.linalg.kron.impl2[breeze.linalg.densematrix[breeze.math.complex],breeze.linalg.densematrix[breeze.math.complex],vr] resultvector = kron(resultvector.todensematrix, vector.todensematrix).todensevector ...
Read more