<div>
<blockquote>
What am I doing wrong? 
</blockquote>
This is wrong:<br />
set @age = DATEDIFF(YY,BirthDate,GETD<wbr />ATE())<br />
&nbsp;set @years = DATEDIFF(YY,HireDate,GETDA<wbr />TE())<br />
<br />
You can solve this by rewriting the WHERE criteria:<br />

<pre><code id="code-20-41078605-1">SELECT FirstName, Birthdate, Hiredate
FROM Employees
WHERE (DATEDIFF(YY,BirthDate,GETDATE()) + DATEDIFF(YY,HireDate,GETDATE())) &gt;85</code></pre>
</div>


> What am I doing wrong?

This is wrong:
set @age = DATEDIFF(YY,BirthDate,GETDATE())
 set @years = DATEDIFF(YY,HireDate,GETDATE())

You can solve this by rewriting the WHERE criteria:


SELECT FirstName, Birthdate, Hiredate
FROM Employees
WHERE (DATEDIFF(YY,BirthDate,GETDATE()) + DATEDIFF(YY,HireDate,GETDATE())) >85

<div>
That's how I originally wrote it and it works fine.<br />
I wanted to write it with a variable if that were possible.<br />
Why can't I define the expression with a variable?
</div>


That's how I originally wrote it and it works fine.
I wanted to write it with a variable if that were possible.
Why can't I define the expression with a variable?

<div>
Makes sense...<br />
Got it!<br />
Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have a SELECT that I want to use a variable with for an expression, but the variable(s) contains columns from my database.<br />
<br />
Here is my SQL statement: <br />
<br />
USE Northwind<br />
GO<br />
declare @age VARCHAR(4), @years VARCHAR(4)<br />
set @age = DATEDIFF(YY,BirthDate,GETD<wbr />ATE())<br />
set @years = DATEDIFF(YY,HireDate,GETDA<wbr />TE())<br />
<br />
SELECT FirstName, Birthdate, Hiredate<br />
FROM Employees<br />
WHERE (@age + @years) &gt;85<br />
<br />
I receive the following errors:<br />
<br />
Msg 207, Level 16, State 1, Line 4<br />
Invalid column name 'BirthDate'.<br />
Msg 207, Level 16, State 1, Line 5<br />
Invalid column name 'HireDate'.<br />
<br />
What am I doing wrong?
</div>
</div>


I have a SELECT that I want to use a variable with for an expression, but the variable(s) contains columns from my database.

Here is my SQL statement: 

USE Northwind
GO
declare @age VARCHAR(4), @years VARCHAR(4)
set @age = DATEDIFF(YY,BirthDate,GETDATE())
set @years = DATEDIFF(YY,HireDate,GETDATE())

SELECT FirstName, Birthdate, Hiredate
FROM Employees
WHERE (@age + @years) >85

I receive the following errors:

Msg 207, Level 16, State 1, Line 4
Invalid column name 'BirthDate'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'HireDate'.

What am I doing wrong?

SQL Variables used with a SELECT Clause

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.