Click here to Skip to main content
15,901,897 members
Home / Discussions / Database
   

Database

 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra20-Oct-14 2:24
professionalShweta N Mishra20-Oct-14 2:24 
GeneralRe: Stored Procedure for Item Allotment Pin
avisharma@sharma27-Oct-14 2:42
avisharma@sharma27-Oct-14 2:42 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra27-Oct-14 3:37
professionalShweta N Mishra27-Oct-14 3:37 
GeneralRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson20-Oct-14 4:53
professionalJörgen Andersson20-Oct-14 4:53 
QuestionCheck if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 0:25
bjay tiamsic19-Oct-14 0:25 
AnswerRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 0:41
mentorWendelius19-Oct-14 0:41 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 17:58
bjay tiamsic19-Oct-14 17:58 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 18:20
mentorWendelius19-Oct-14 18:20 
If the students table contains the email address, then you can use that to check if the recipient is equal to student.email. If multiple recipients can be found ind recipients field then you can join using a string search with CHARINDEX function.

So either something like:
SQL
SELECT ...
FROM sysmail_allitems sai,
     student s
WHERE LOWER(sai.recipients) = LOWER(s.email)

or
SQL
SELECT ...
FROM sysmail_allitems sai,
     student s
WHERE CHARINDEX(LOWER(s.email), LOWER(sai.recipients)) > 0 

SuggestionRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Richard Deeming20-Oct-14 2:16
mveRichard Deeming20-Oct-14 2:16 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius20-Oct-14 17:23
mentorWendelius20-Oct-14 17:23 
QuestionSQL report to get average amount of time for helpdesk closures Pin
Danpeking17-Oct-14 3:29
Danpeking17-Oct-14 3:29 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 3:45
professionalGuyThiebaut17-Oct-14 3:45 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius17-Oct-14 3:47
mentorWendelius17-Oct-14 3:47 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 4:16
professionalGuyThiebaut17-Oct-14 4:16 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius17-Oct-14 4:25
mentorWendelius17-Oct-14 4:25 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Danpeking17-Oct-14 6:03
Danpeking17-Oct-14 6:03 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius19-Oct-14 0:35
mentorWendelius19-Oct-14 0:35 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Danpeking9-Nov-14 22:27
Danpeking9-Nov-14 22:27 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius10-Nov-14 8:33
mentorWendelius10-Nov-14 8:33 
QuestionRoadmap to learn SSIS Pin
arunUB16-Oct-14 15:47
arunUB16-Oct-14 15:47 
AnswerRe: Roadmap to learn SSIS Pin
Peter Leow16-Oct-14 16:05
professionalPeter Leow16-Oct-14 16:05 
AnswerRe: Roadmap to learn SSIS Pin
Shweta N Mishra20-Oct-14 2:31
professionalShweta N Mishra20-Oct-14 2:31 
QuestionCreate 2 sets of results using old school foxpro or dbase III dbf files Pin
jkirkerx16-Oct-14 10:49
professionaljkirkerx16-Oct-14 10:49 
AnswerRe: Create 2 sets of results using old school foxpro or dbase III dbf files Pin
David Mujica17-Oct-14 2:54
David Mujica17-Oct-14 2:54 
Questiongood book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
johnpol1215-Oct-14 0:04
johnpol1215-Oct-14 0:04 

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.