Hi All

I am able to send email through a variable,but unable to attach the emails.

If there are 10 extracts or 100 extracts in the folder an email will be sent,but...

Lets say they have to be restarted and those moments when the server is getting restarted is when the SQL jobs are scheduled.Is there a configuration which would take care...

Sure,will keep in mind

Thanks Jeff/Eirikur .Should have updated the forum.I got what I was looking for.Thanks again.

ascii value for comma

nothing just ...just learning some coding

I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks

This is my IF clause which did not work...

if (@charvaluefront= @charvalueback)

Print 'its a palindrome'

I am not sure why it did not work...

Yes,I do plan to get it done using SSIS and SSRS.

I got the code working properly.

The code worked for sometime ...

then it stopped working.

It gave me these extracts SSIS570.html where 570 is the ID passed as a parameter.

After testing it a couple of times it...

Already tried that...still getting an error...

Msg 139, Level 15, State 1, Procedure usp_Names, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Procedure usp_Names,...

Did what you suggested...still throws an error...

Here is the code I tried executing...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

Select...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

EXEC sp_makewebtask...

It still throws an error...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\'...