can you show details, and not any pseudo code?

if you can show us the exact code you are using to send the emails, we can help you track down the...

... our ethics code requires us to prevent you from seeing what we are doing ...

the fix is to group the data by day to get daily totals when more than one shipement exists per day, then get the max per week or month, depending...

based on your data, and some substantial cleanup of what you pasted,(year 2104) i get a max of 60 shipped for week 2:

;WITH MyCTE([Invtid],[Case_ship],[Trandate],[FiscYr],[PerPost],[week_period],[day_period])

AS

(

SELECT 'A',CONVERT(int,'10'),convert(date,' 1/1/2014'),'2014',' 1',' 1',' 1'...

wrapping your current query and using a CTE or subquery works;

here's a simple case statemetn example:

SELECT

CASE WHEN avg_read_disk_latency_ms < 20 THEN 'fast'

WHEN avg_read_disk_latency_ms < 50...

a scheduled job could check each database, and if it finds the right role or user, perform the same script we are recommending above.

if a table was dropped, you might be able to find out who/ when it was dropped by looking at the default trace.

if you need the DDL to recreate the...

is there a DDL trigger on the database that is designed to protect specific tables?

that sounds like a custom error message to me.

select * from sys.server_triggers

apparently, the stored procedure finds the data...

I'm not sure myself, which is why i was asking;

the examples i put out are what is wierd for me. If a query takes ten seconds, i'd kind of expect...

yes it can, if you follow the correct construct;

in SQl there's no THEN:

CREATE PROCEDURE [IFTHEN] AS

DECLARE @max-2 INT, @min-2 INT;

SELECT

@min-2=MIN(idt)

,@max=MAX(idt)

FROM test;

IF ((@max-@min)>50000)

BEGIN

PRINT 'Doing stuff.'

---Execute more SQL commands---

END; ...

it depends on what you mean;

you can of course return results that have operations agaisnt them.

if you mean can you pass a command and have it interpreted, then yes, with...

and another way:

you can declare an explicit escape char like this:

select

object_name(object_id),

definition

from sys.sql_modules

WHERE definition like '%referall!_orr%' ESCAPE '!'

you are too quick! i edited almost right away, but you grabbed my first verison.

i updated my post, i think it's filtering based on your date requirement now

in the future, make your post title something other than "query help"; you'll get better responses if ti was something more like "empid wherethe max date?" or something descriptive.

there's...