This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Solved
sql 2005 email store procedure
Posted on 2009-07-01
i am trying to create a store procedure. where the count is more than zero it should send an email with all records. can some one help me out with this.
declare @maxcount as varchar(10)
select @maxcount = count(id_number)from dbo.iqm_newemployees
select @maxcount
if @maxcount >= 3
Select @maxcount
DECLARE @ProductTotals TABLE
(
[id_number] [int] NOT NULL,
[employee_name] [varchar](51) NOT NULL,
[account_disabled] [bit] NOT NULL,
[startdate] [datetime] NULL,
[defaultlocation] [int] NULL
)
insert into @ProductTotals(id_number,employee_name,account_disabled,startdate,defaultlocation)
select id_number,employee_name,account_disabled,startdate,defaultlocation from dbo.iqm_newemployees
where status = 0
select * from @ProductTotals
EXEC msdb.dbo.sp_send_dbmail
@recipients='reddy@arjaywireless.com',
@body= 'select * from @producttotals',
@subject = 'new record inserted',
@profile_name = 'Arjayreddysemail'
else
select 'test'
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
Active today
just do
select * from @productTotals
if @@rowcount > 0
exec . . .
else
select 'No Rows to Email' as Status
select * from @productTotals
if @@rowcount > 0
exec . . .
else
select 'No Rows to Email' as Status
insert into @ProductTotals(id_number,e
select id_number,employee_name,ac
where status = 0
IF @@ROWCOUNT > 0
EXEC msdb.dbo.sp_send_dbmail
@recipients='reddy@arjaywi
@body= 'select * from @producttotals',
@subject = 'new record inserted',
@profile_name = 'Arjayreddysemail'
select id_number,employee_name,ac
where status = 0
IF @@ROWCOUNT > 0
EXEC msdb.dbo.sp_send_dbmail
@recipients='reddy@arjaywi
@body= 'select * from @producttotals',
@subject = 'new record inserted',
@profile_name = 'Arjayreddysemail'
EXEC msdb.dbo.sp_send_dbmail
@recipients='reddy@arjaywi
@query = 'select * from @producttotals',
@subject = 'new record inserted',
@profile_name = 'Arjayreddysemail'
@recipients='reddy@arjaywi
@query = 'select * from @producttotals',
@subject = 'new record inserted',
@profile_name = 'Arjayreddysemail'
this is the error i am getting now
(3 row(s) affected)
Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 478
Query execution failed: Msg 1087, Level 15, State 2, Server ARJAYDATA, Line 1
Must declare the table variable "@producttotals".
(3 row(s) affected)
Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 478
Query execution failed: Msg 1087, Level 15, State 2, Server ARJAYDATA, Line 1
Must declare the table variable "@producttotals".
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi all,
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month11 days, left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.