Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Cross Join / Stored Proc

Posted on 2009-07-01
1
Medium Priority
?
407 Views
Last Modified: 2012-05-07
I want to create a stored procedure that will take in a year, look up "active" rows in a "Code Table" and insert it into another table (Table B).  For instance:

Year: 2009

Code Table
ID - several other columns - Status
1 - ... - Active
2 - ... - Inactive
3 - ... - Active

Table B
Year - ID
2009 - 1
2009 - 3
0
Comment
Question by:mmeisel
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24757734
this should do:
create procedure yourproc @year int
as
  insert into table_b ( [year], ID )
   select @year, ID 
     from code_table

Open in new window

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, we’ll look at how to deploy ProxySQL.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question