This query run fine. it sends me the emails that i need.
here is the query:
use ANALYTICS
create table #ezpayloc
(locations varchar(50), storeemail varchar(50))
insert into #ezpayloc SELECT distinct [LOCATION], +('mac'+(location)+'@maclocal.com')
FROM vw_PAST_DUE_LESSONS_EZPAY] order by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.