Having a basic SQL issue using microsoft sql server 2012

Question

I am new to SQL statements and I am guessing this is something obvious so I apologize ahead of time for the newbie question.

Here is the code:

use test;
declare @time_24_2 int;
declare @hours_diff_2 int;

SELECT 
    end_date_full 
FROM 
    example 
WHERE 
    datediff(hour, getdate(), end_date_full) < 24
GROUP BY 
    end_date_full

SET @time_24_2 = end_date_full;
select @time_24_2

This is my code and I am simply trying to pull the end_date_full column of every row that fits the criteria. However every time I try to use the column end_date_full like seen below I get an error that says Unknown column name.

Any help would be amazing!

P.S end_date_full is a column name and it works for the first select statement, just not the SET statement.

Duplicate?: How to set variable from a SQL query?.

user456814
– user456814

2014-08-14 08:24:23 +00:00
Commented Aug 14, 2014 at 8:24 — user456814
– user456814, Commented Aug 14, 2014 at 8:24

shree.pat18 · Accepted Answer · 2014-03-19 07:07:12Z

4

That's because you are trying to use the column name outside a query when you assign it to variable. This should do the trick:

SELECT @time_24_2 = end_date_full 
FROM example 
WHERE datediff(hour, getdate(), end_date_full) < 24
group by end_date_full

answered Mar 19, 2014 at 7:07

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Having a basic SQL issue using microsoft sql server 2012

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related