Hello! I'm drawing a big blank here! I've got a SELECT query whose results I need to be put into a table. The table already exists in the Database, but any records in it need to be deleted and then the results of the SELECT query should be inserted.
Here's the SELECT statement I'm using.
select student_ssn, last_name, first_name, value_09, value_15 from Pfaids2005.dbo.user_string as u
join pfaids2005.dbo.stu_award_year s on u.stu_award_year_token=s.stu_award_year_token
join PFaids2005.dbo.student st on u.student_token=st.student_token
where(((value_09='MPN' or value_09='PIF') and (value_15='P' or value_15='Y')))
and u.award_year_token='2014'
order by last_name, first_name
Here's what the query looks like:
I'd like those query results to be inserted into a table called "CustomData".
Any quidance is appreciated!