Click here to Skip to main content
15,904,500 members
Home / Discussions / Database
   

Database

 
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 
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 
Thanks for the suggestion Smile | :)
Richard Deeming wrote:
It's usually cleaner to use the ANSI JOIN syntax
I usually use ANSI join but in this case I felt it would be more understandable to use the 'old' syntax because the variations for the join itself are quite different.

Richard Deeming wrote:
most databases don't use a case-sensitive collation, so there shouldn't be any need to use the LOWER function here.
Not sure about this so I wanted to be on the safe side.

I should have written these reasons to the original post in the first place. Smile | :)
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 
QuestionConvert row to columns in SQL View or Procedure Pin
Member 1115418814-Oct-14 19:52
Member 1115418814-Oct-14 19:52 

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.