stored procedure

[Harish]

I amtrying to create the procedure which will give the output to @filename.
i am using this proccedure in other procedure too.
and i am geting follwonmg error.Help me !!

===============
create procedure p1 as
@v datetime,
@filename varchar output

begin

SELECT @v = GetDate()

select @filename = 'XAPIALTMKT'+CONVERT(varchar, @v, 112)+ SUBSTRING(CONVERT(varchar, @v, 108), 1, 2)
+ SUBSTRING(CONVERT(varchar, @v, 108), 4, 2)+ SUBSTRING(CONVERT(varchar, @v, 108), 7, 2) + '.TXT'

end

=======error
Msg 170, Level 15, State 1
Line 2: Incorrect syntax near '@v'.
Msg 137, Level 15, State 1
Must declare variable '@v'.
Msg 137, Level 15, State 2
Must declare variable '@v'.

[vikram]

you will have to declare the variables..

in ur example

declare @v datetime
declare @filename varchar output

regards
vikram


------------
Harish at 8/28/01 11:09:49 AM

I amtrying to create the procedure which will give the output to @filename.
i am using this proccedure in other procedure too.
and i am geting follwonmg error.Help me !!

===============
create procedure p1 as
@v datetime,
@filename varchar output

begin

SELECT @v = GetDate()

select @filename = 'XAPIALTMKT'+CONVERT(varchar, @v, 112)+ SUBSTRING(CONVERT(varchar, @v, 108), 1, 2)
+ SUBSTRING(CONVERT(varchar, @v, 108), 4, 2)+ SUBSTRING(CONVERT(varchar, @v, 108), 7, 2) + '.TXT'

end

=======error
Msg 170, Level 15, State 1
Line 2: Incorrect syntax near '@v'.
Msg 137, Level 15, State 1
Must declare variable '@v'.
Msg 137, Level 15, State 2
Must declare variable '@v'.

[Ivo]

yes, and if it should @v and @filename to be input parameters, you should place 'as' between them and begin ...


------------
vikram at 8/28/01 2:45:37 PM

you will have to declare the variables..

in ur example

declare @v datetime
declare @filename varchar output

regards
vikram


------------
Harish at 8/28/01 11:09:49 AM

I amtrying to create the procedure which will give the output to @filename.
i am using this proccedure in other procedure too.
and i am geting follwonmg error.Help me !!

===============
create procedure p1 as
@v datetime,
@filename varchar output

begin

SELECT @v = GetDate()

select @filename = 'XAPIALTMKT'+CONVERT(varchar, @v, 112)+ SUBSTRING(CONVERT(varchar, @v, 108), 1, 2)
+ SUBSTRING(CONVERT(varchar, @v, 108), 4, 2)+ SUBSTRING(CONVERT(varchar, @v, 108), 7, 2) + '.TXT'

end

=======error
Msg 170, Level 15, State 1
Line 2: Incorrect syntax near '@v'.
Msg 137, Level 15, State 1
Must declare variable '@v'.
Msg 137, Level 15, State 2
Must declare variable '@v'.