Click here to Skip to main content
15,867,594 members
Home / Discussions / Database
   

Database

 
GeneralRe: A query with lot of inner queries Pin
Jörgen Andersson30-May-14 3:15
professionalJörgen Andersson30-May-14 3:15 
GeneralRe: A query with lot of inner queries Pin
indian14330-May-14 9:08
indian14330-May-14 9:08 
GeneralRe: A query with lot of inner queries Pin
Jörgen Andersson30-May-14 9:24
professionalJörgen Andersson30-May-14 9:24 
GeneralRe: A query with lot of inner queries Pin
indian14330-May-14 9:05
indian14330-May-14 9:05 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes30-May-14 12:46
professionalMycroft Holmes30-May-14 12:46 
QuestionProblem with tempdb - MSSQL Pin
Milan K SK28-May-14 4:32
Milan K SK28-May-14 4:32 
AnswerRe: Problem with tempdb - MSSQL Pin
Kornfeld Eliyahu Peter28-May-14 6:39
professionalKornfeld Eliyahu Peter28-May-14 6:39 
QuestionSQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 11:10
Seuss27-May-14 11:10 
Hi all,

I am in desperate need of help please.

I have created a stored procedure with a while loop using a hard coded date 31-12-2014 to compare against current date produced in a while loop. I need to make the hard coded date reflect every two years i.e. 31-12-2016, 31-12-2018 etc.
How can the date be automatic instead of hard coded please?
i.e While (currdate <= '31-12-2014')

Second issue, how do I make the stored procedure to run every two years as well?

SQL Agent Job doesn't have a yearly frequency at all.

Can someone please offer an example coding and suggestions to those two issues which I will be grateful please.
Confused | :confused:

Thank You!
AnswerRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Mycroft Holmes27-May-14 12:45
professionalMycroft Holmes27-May-14 12:45 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 20:10
Seuss27-May-14 20:10 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Mycroft Holmes27-May-14 20:22
professionalMycroft Holmes27-May-14 20:22 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 22:14
Seuss27-May-14 22:14 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
NitinDhapte16-Jun-14 1:55
NitinDhapte16-Jun-14 1:55 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 22:28
Seuss27-May-14 22:28 
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 
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 

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.