<div>
select convert(varchar(10), getdate(), 112)<br />
from tablename<br />
<br />
as for the headers, view the results as text. &nbsp;Go to tools, options...there is an option for not showing the headers.
</div>


select convert(varchar(10), getdate(), 112)
from tablename

as for the headers, view the results as text.  Go to tools, options...there is an option for not showing the headers.

<div>
Thank you so much &nbsp;- as usual PERFECT help
</div>


Thank you so much  - as usual PERFECT help

<div>
<div class="content wysiwyg-content">
select account_id, ***date- Todays date**** format YYYYMMDD with no spaces etc from cashmgmt_payment<br />
<br />
also how can I make it so there are no 'header' or footer records so the output is something like:<br />
<br />
123 &nbsp; 20041224<br />
<br />
no reference to rows selected or no header before JUST the result set.
</div>
</div>


select account_id, ***date- Todays date**** format YYYYMMDD with no spaces etc from cashmgmt_payment

also how can I make it so there are no 'header' or footer records so the output is something like:

123   20041224

no reference to rows selected or no header before JUST the result set.

select query I want to select 'today's date' as part of my select

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.