var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
How yould i loop trought all the records in a table and fetching a specic record that is flagged and sending for each record found a email with that records data to a mail recipient. this should be part of a step in a sql job. PLZ HELP
Had a little problem in understanding your phrases. You may check cursor in BOL for looping actions.
create proc abc as
declare c1 cursor as select primary key from table name where condition
while (@@fetch_status =0)
exec xp_sendmail .....
something like this and schedule as job !!!
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors