Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2007-03-28 : 15:23:00
|
Is it possible that if I have the following:select TICKNUM,ROUND(SHARES_TARGET,3) as trgtunits,convert(numeric,TARGET_CASH) as TARGET_CASH,PRICE_DBL as estprice,convert(numeric,SHARES_TARGET * PRICE_DBL) as [trgt units* est price],(convert(numeric,TARGET_CASH) - (convert(numeric,SHARES_TARGET * PRICE_DBL))) as [Difference]from TICKET where SECTYPE = 'MF' and CASH_ORDER_FLAG = '1' and (convert(numeric,TARGET_CASH) - (convert(numeric,SHARES_TARGET * PRICE_DBL))) > .5If i want to run this from a scheduler and have it notify me whenever it returns a result whats the best way? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-28 : 15:48:07
|
You can put the query in an IF EXISTS, then have it e-mail when the IF is true. For 2000, you can use SQL Mail for your e-mail solution.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|