can i Generate SQL Script once for the all jobs

in my server ?

this is the all code

-------------------

DECLARE @recipient VARCHAR(1000)

DECLARE @pstrNames VARCHAR(8000)

SET @pstrNames =''

-- Append all results into a variable

SELECT @pstrNames = @pstrNames + ISNULL(email, '') + ';'

FROM dbo.em

-- Remove the comma at...

NO

i test the tow possibility

and still a gen an error

---------------

when i do this

set @recipient='select @pstrNames'

OR

this

select @recipient='select @pstrNames'

i get this

Server: Msg 137, Level 15, State 2, Line...

can you to show put all together

i get this error

---------------

The minimum parameters are Recipient, From and Address. All must be supplied.

Quick format -

--------------

what is the problem ???

ilan

Edited by...

thnks a lot for your help

it work 100%

ilan

maybe you can take a look at this site

of the examples

in the xp_SMTPSendMail80 a new DLL file

i wont to know how to run a query to email

from sql server

---------------------------

the...

thnks but i get an error

-------------

Server: Msg 156, Level 15, State 1, Line 9

Incorrect syntax near the keyword 'THEN'.

-----------------------------------------

ilan

wow thnks

-------------

why BirthdayToday not work ??

only BirthdayThisWeek

---------

thnks A LOT

ilan

Edited by - midan1 on 07/20/2003 12:35:08 PM

Edited by - midan1 on 07/21/2003 08:59:42 AM

thnks

-------

how can i put it all in one VIEW

so thet i can see all in one table

not in Stored Procedures

---------

thnks a lot

ilan

so no help for my

seriously

------------------

question

how can i know how has a birthday

from table "users"

this week

---------------------

thnks

ilan

ok but how can i do this ??

---------

tarih BETWEEN DATEADD(hour, 1, DATEDIFF(day, 0, GETDATE()))

AND

tarihb DATEADD(hour, 16, DATEDIFF(day, 0, GETDATE() + 1)))

------------------------

ilan

i mean this

---------------

WHERE (dbo.mainb.tarih >= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND

(dbo.mainb.tarih >= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND (dbo.mainb.tarihb <= CONVERT(varchar, DATEADD([day],

1,...

ok

i only wont to know

you think in the long way (my code) am i missed any record ??

OR you say thet correct way to do it

and in the end...

and what not O.K like this ? after i fix it

i work

or i am mistake ?

-----------

WHERE (dbo.mainb.tarih >= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND...

but like your explains i can not

search evry day

between Getdate() '16:00' and Getdate()+1 '16:00'

and in tow different field

thnks ilan