Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
USE BurgoyneMusic GO Declare @Emails varchar(50) Select @Emails=@Emails + (a.Email) From Student As a Where exists (SELECT * From CreditCard As b WHERE a.StudentID = b.StudentID And b.CCMonth = month(DATEADD("m",-1,GETDATE())) And b.CCYear = DATEPART(year,GETDATE())) USE msdb EXEC sp_send_dbmail @profile_name='MyProfile', @recipients= @Emails, @subject='subject', @body='message body'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.