| Author |
 Topic  |
|
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 03/29/2013 : 06:58:17
|
kindly help on the query for this sp
CREATE PROCEDURE [dbo].[usp_pkg_audit_execute] (@execute_type char(3))
AS
BEGIN
If @execute_type ='PRE' then
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '1',GETDATE())
SELECT @ssis_audit_id=CAST(SCOPE_IDENTITY() AS INT)
else if @execute_type ='POS' then
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '2',GETDATE())
end if
END
THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com |
|
|
bandi
Flowing Fount of Yak Knowledge
India
2242 Posts |
Posted - 03/29/2013 : 07:12:57
|
What is the problem ? Where is the declaration for @package_name
I've fixed some typos......
1) Pass @package_name VARCHAR(10) as Input Param
2) If @execute_type ='PRE'
BEGIN
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '1',GETDATE())
SELECT @ssis_audit_id=CAST(SCOPE_IDENTITY() AS INT)
END
else if @execute_type ='POS'
BEGIN
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '2',GETDATE())
end
END |
 |
|
|
shanmugaraj
Posting Yak Master
219 Posts |
Posted - 03/29/2013 : 07:47:17
|
Thanks bandi
quote:
Originally posted by bandi
What is the problem ? Where is the declaration for @package_name
I've fixed some typos......
1) Pass @package_name VARCHAR(10) as Input Param
2) If @execute_type ='PRE'
BEGIN
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '1',GETDATE())
SELECT @ssis_audit_id=CAST(SCOPE_IDENTITY() AS INT)
END
else if @execute_type ='POS'
BEGIN
INSERT INTO ssis_audit(package_name,status,start_time) VALUES(@package_name, '2',GETDATE())
end
END
THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
2242 Posts |
Posted - 03/29/2013 : 08:05:14
|
quote:
Originally posted by shanmugaraj
Thanks bandi
Declare @ssis variable inside Procedure...
Welcome
--
Chandu |
Edited by - bandi on 03/29/2013 08:06:36 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
52326 Posts |
Posted - 03/29/2013 : 13:48:47
|
you dont need if ...else construct. just below would do
INSERT INTO ssis_audit(package_name,status,start_time)
SELECT @package_name,CASE @execute_type WHEN 'PRE' THEN '1' WHEN 'POS' THEN '2' END,GETDATE()
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
|
|
query for this sp