Click here to Skip to main content
15,615,155 members
Home / Discussions / Database
   

Database

 
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 
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 
It's usually cleaner to use the ANSI JOIN syntax, so that you keep the join conditions separate from any filter conditions.
SQL
SELECT 
    ...
FROM 
    sysmail_allitems sai
    INNER JOIN student s
    ON sai.recipients = s.email

Also, most databases don't use a case-sensitive collation, so there shouldn't be any need to use the LOWER function here.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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 
AnswerRe: good book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
ZurdoDev15-Oct-14 5:45
professionalZurdoDev15-Oct-14 5:45 

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.