Click here to Skip to main content
15,906,708 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Mycroft Holmes27-May-14 22:55
professionalMycroft Holmes27-May-14 22:55 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 23:00
Seuss27-May-14 23:00 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss28-May-14 5:28
Seuss28-May-14 5:28 
AnswerRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Chris Quinn27-May-14 22:53
Chris Quinn27-May-14 22:53 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 23:01
Seuss27-May-14 23:01 
QuestionHow to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 6:09
ven75326-May-14 6:09 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
jschell26-May-14 8:11
jschell26-May-14 8:11 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 21:27
ven75326-May-14 21:27 
if todays date is 2014-05-26 then
1. 2012-05-25 if u consider 2 years means 730 (365 X 2) days will come but in this 731 that 2 years 1 day so we should display this, it should complete exactly year
2. 2012-05-26 i think this is coming 730 days means 2 years exactly we can display
3. 2012-05-27 in this 1 day required to complete exactly 2 years now it is 729 days
4. 2013-05-27 in this 364 is coming it should be 365 to complete a year so we should display this record

How to achieve this. Please reply me.
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Mycroft Holmes26-May-14 12:52
professionalMycroft Holmes26-May-14 12:52 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Sunasara Imdadhusen26-May-14 21:30
professionalSunasara Imdadhusen26-May-14 21:30 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
NitinDhapte16-Jun-14 2:18
NitinDhapte16-Jun-14 2:18 
Questionaccess2010 pivot table Pin
hakata21-May-14 5:59
hakata21-May-14 5:59 
QuestionAbnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 20:52
jugnu_ad20-May-14 20:52 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 21:45
mveRichard MacCutchan20-May-14 21:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 21:47
jugnu_ad20-May-14 21:47 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 22:26
mveRichard MacCutchan20-May-14 22:26 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael21-May-14 1:35
Tim Carmichael21-May-14 1:35 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 1:45
jugnu_ad21-May-14 1:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Simon_Whale21-May-14 1:50
Simon_Whale21-May-14 1:50 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 1:56
jugnu_ad21-May-14 1:56 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen21-May-14 7:52
professionalEddy Vluggen21-May-14 7:52 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Mycroft Holmes21-May-14 12:51
professionalMycroft Holmes21-May-14 12:51 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael22-May-14 3:41
Tim Carmichael22-May-14 3:41 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen22-May-14 5:10
professionalEddy Vluggen22-May-14 5:10 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Shameel22-May-14 3:05
professionalShameel22-May-14 3:05 

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.