Try this. Don't put the % sign in the variable

WHERE Column1 like '%' + @Variable + '%'

How is that data stored? datetime, time, or char datatype?

I think you are looking form something like this.

SELECT ConsoleFormat, GameNumber, RetailPrice

FROM [Table1]

WHERE GameNumber NOT IN (SELECT GameNumber FROM [Table2])

I would double check your parameter assignment to the dataset in the SSRS report. You may have a report parameter pointed to the wrong sp parameter

I would try to put in a bpc or something to bulk out the data to a file. This way you can see what data is being returned.

I understand. The issue has to be with the setup of the alert, the code is clearly working as it is suppose to or it wouldn't be logging the information.

I don't think your RAISERROR severity is high enough to cause the job to "fail" setting the alert to the operator. I belive it has to be 16 or higher...

Let me ask this, how are you firing the notification event?

I don't think your RAISERROR severity is high enough to cause the job to "fail" setting the alert to the...

I wonder if it is a timing thing with the job.

have you tried changing

and r.DateCreated between job.last_executed_step_date and GETDATE()

to

and r.DateCreated >= job.last_executed_step_date

Also, are you using getdate() everywhere....

Try adding a batch size or packet size.

The %S and %d are variables. T-sql doesn’t have a format string like.Net does. You could create a CLR user defined function to implement the .NET format string but...

look at stored proc sp_msforeachdb

Insert a modifieddate where? I usually have columns on stuff like this, DateCreated and DateModified and updated them when needed.

The difference in your way and the way I stated above is .... yours will ALWAYS run two queries and mine will only run two queries if the item needs...

You can use the merge statement if you are on SQL Server 2008 or

--Try to update the record

Update dbo.tblData

Set Name = @Name

WHERE ID = @id

--If the row wasn't updated, it...