Stored Procedure Help 3 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Stored Procedure Help 3

Author

Topic

steven.liberman1
Starting Member

15 Posts

Posted - 2011-02-28 : 10:14:25

Source Database: version5_ABCM
destination Database: version500

select template_id, template_name, template_content, template_group, template_section,
delete_ind, application
from version5_ABCM..slxHRScreenTemplates
where template_group = 'ADMIN' or template_group = 'Corp Benefits' or template_group = 'Data Proc' or template_group = 'Smartlinx'

select template_id, template_name, template_content, template_group, template_section,
delete_ind, application
from version500..slxHRScreenTemplates
where template_group = 'ADMIN' or template_group = 'Mgr' or template_group = 'Payroll' or template_group = 'HR'

I am trying to write a stored procedure in SQL Server where I would take the information from version5_ABCM in the slxHRScreenTemplates and imported into the same table in version500 where the values are above.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources