Advertisement

06.12.2008 at 08:44AM PDT, ID: 23479922
[x]
Attachment Details

How to Compare DateName(YEAR, TABLENAME) to NOW YEAR.......

Asked by PhatAdam in SQL Reporting, MS SQL Server, SQL Server 2005

Tags: MS, SQL Server / Reporting, 2005, Visual Studio

DATABASE NAME:
HR_ASSOCIATES
TABLE NAME :
HireDate
COMMAND:
 (DATENAME(YEAR, HireDate)

Hello,
 im trying to build a report out of the HR DATABASE to allow our Users to Pull a Report of Associates Anniversary's and have it output the number of years the associate has been there.
any help would be greatly appreciated. the report is already working for the user to select the month and it will only show the people with anniversarys that month but I would love it to show the number of years as well........for example....if Table data Shows 2002, and Todays Year is 2008 how can i get SQL to Show me 6 YEARS?

Thanks,
PhatAdam
Information SystemsStart Free Trial
[+][-]06.12.2008 at 08:56AM PDT, ID: 21770836

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 08:58AM PDT, ID: 21770866

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:05AM PDT, ID: 21770946

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:08AM PDT, ID: 21770976

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:10AM PDT, ID: 21770987

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:18AM PDT, ID: 21771059

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:20AM PDT, ID: 21771079

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 10:31AM PDT, ID: 21771735

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Reporting, MS SQL Server, SQL Server 2005
Tags: MS, SQL Server / Reporting, 2005, Visual Studio
Sign Up Now!
Solution Provided By: jgv
Participating Experts: 4
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628