Click here to Skip to main content
14,487,309 members
   

Database

 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 1:10
MemberMember 138060854-May-18 1:10 
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 14:12
Memberindian1432-May-18 14:12 
AnswerSelf answered just if somebody has similar problem it would be helpful. How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1433-May-18 8:41
Memberindian1433-May-18 8:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 7:03
Memberindian14326-Apr-18 7:03 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 8:00
mveRichard Deeming26-Apr-18 8:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 10:09
Memberindian14326-Apr-18 10:09 
Questionmysql query Pin
Member 1360728325-Apr-18 16:47
MemberMember 1360728325-Apr-18 16:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 21:48
professionalJörgen Andersson25-Apr-18 21:48 
You need a reference for all active users.
Assuming you have a Users table you should try something similar to this:
SELECT  u.UserID
FROM    Users u
LEFT JOIN Timesheet t
    ON  t.UserID = u.UserID
    AND t.Date = "2018-04-23"
WHERE   t.UserID IS NULL
    AND u.IsActive = 1
The existence of IsActive is just an assumption on my part. Add or change conditions as needed.

There are other solutions, but this is the probably the best way to do it.
Wrong is evil and must be defeated. - Jeff Ello

GeneralRe: mysql query Pin
Member 1360728326-Apr-18 10:56
MemberMember 1360728326-Apr-18 10:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 21:22
professionalJörgen Andersson26-Apr-18 21:22 
QuestionShipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 4:51
Memberbfg9000d36025-Apr-18 4:51 
AnswerRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 5:37
professionalEddy Vluggen25-Apr-18 5:37 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 7:19
Memberbfg9000d36025-Apr-18 7:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:19
professionalEddy Vluggen25-Apr-18 8:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 8:31
Memberbfg9000d36025-Apr-18 8:31 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:38
professionalEddy Vluggen25-Apr-18 8:38 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 9:46
mveRichard Deeming25-Apr-18 9:46 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 9:50
Memberbfg9000d36025-Apr-18 9:50 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 10:08
mveRichard Deeming25-Apr-18 10:08 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 10:12
Memberbfg9000d36025-Apr-18 10:12 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 10:16
mveRichard Deeming25-Apr-18 10:16 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36026-Apr-18 1:17
Memberbfg9000d36026-Apr-18 1:17 
QuestionCopying the Headers of Result Set of Select statement Pin
indian14324-Apr-18 9:05
Memberindian14324-Apr-18 9:05 
AnswerRe: Copying the Headers of Result Set of Select statement Pin
JChrisCompton24-Apr-18 11:42
MemberJChrisCompton24-Apr-18 11:42 
AnswerRe: Copying the Headers of Result Set of Select statement Pin
Mycroft Holmes24-Apr-18 12:53
professionalMycroft Holmes24-Apr-18 12:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.