<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
I have a table consisting of the following fields:<br />
<br />
ref &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int<br />
issue &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int<br />
startdate &nbsp; &nbsp; date/time<br />
expdate &nbsp; &nbsp; &nbsp;date/time<br />
<br />
I would like to be able to select issue from the table where the expdate falls within the month after this month. &nbsp;I understand I will have to use GETDATE to work out the current month but I am not sure on the correct syntax for this.<br />
<br />
Can anyone help<br />
<br />
Thanks<br />
<br />
&nbsp;
</div>
</div>


Dear Experts

I have a table consisting of the following fields:

ref               int
issue           int
startdate     date/time
expdate      date/time

I would like to be able to select issue from the table where the expdate falls within the month after this month.  I understand I will have to use GETDATE to work out the current month but I am not sure on the correct syntax for this.

Can anyone help

Thanks

 

TSQL Syntax

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.