hi,

i can understand what you feel when is there any change into one table you need to do changes into lot of sp for one column .......

i have one suggestion...

pavan,

actually here we are using exchange server so in smtp i need to put that, my problem seems different then you.

guys when i go deep into this i got one...

you don't get my point previously it was working fine

let me tell you step by step

for testing purpose i am executing like below

EXEC msdb..sp_send_dbmail

@profile_name = 'profilename'

,@recipients =...

yeh you are right ......... thank you all

this code works fine

EXEC msdb..sp_send_dbmail

@profile_name = 'admin'

,@recipients = 'xyz@companyname.com'

,@subject = @header

,@body_format = 'HTML'

,@body = @txt

,@from_address = 'admin@companyname.com'

but this one is not

EXEC msdb..sp_send_dbmail

@profile_name = 'admin'

,@recipients...

hi,

this way you can do that

DECLARE @string VARCHAR(100)

SET @string = 'going to school'

SELECT ltrim(REPLACE(@string,'going',''))

hi,

can u some sample data with

create script of table

insert script

and your query which causing error

and one more thing when you did as per i told you declare all...

select Profession from BK_TagSMS_Access where Profession in

(select cast(value as int) from BK_TagSMS_ParameterSplit(@Profession,','))

is this query run completely ............

do one thing to get complete solution for your problem give some sample data...

yeh you are right where = (1,2,3,4)

will be get error for that

and another cause for that where = case when 1 or 2

if she used case...

hi,

are you facing problem where these subquery error occurs ?

is this right

then if you are going to execute direct procedure then will show you this error but it will...

hi,

actually if you put some example data then it will be more useful to tell you, but don't know why you write such query i think your query structure is...

hi,

you can do that through both ...

but for easy way go to management studio and into that go management

there you will see maintenance plan .... and create new ...

through...

may be this can help you

SELECT * FROM TEST

WHERE CONVERT(VARCHAR,DAT_TIM,101) >= CAST (@startdate AS DATETIME )

AND CONVERT(VARCHAR,DAT_TIM,101) < (CAST (@startdate AS DATETIME )+1)

i don't get all things what you say but one thing i can suggest you for

if you want to insert data into two tables right dpends on first table...

hi can u tell me steps for that i m till now know that to just genrate report and but can we do that like automatically save that into one...