CallableStatement st = connect.prepareCall(sql);        
ResultSet rs =  st.executeQuery();

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.

CallableStatement st = connect.prepareCall(sql);        
st.execute();
ResultSet rs =  st.executeQuery();

DECLARE @day datetime,@start datetime,@minstart datetime,@maxend datetime,@end datetime,@stddev float
SET @start = convert(datetime,'02/10/2012',101)
SET @end = convert(datetime,'02/17/2012',101)

SELECT @minstart = min(event_time), @maxend = max(event_time)
FROM my_user.audit_table

IF @start < @minstart OR @start IS NULL SET @start = @minstart
IF @end > @maxend OR @end IS NULL SET @end = @maxend

SELECT @stddev = STDEV(all_count)
FROM
(
	SELECT count(1) AS all_count
	FROM my_user.audit_table
	WHERE event_class in (14, 20)
		AND event_time BETWEEN @start AND @end
	GROUP BY CONVERT(datetime, CONVERT(varchar, event_time, 112), 112)
) AS t

SET @day = dateadd(dd, -1, @start)

DECLARE @t TABLE (day datetime PRIMARY KEY)

WHILE @day < @end
BEGIN
	INSERT INTO @t VALUES (@day)
	SET @day = dateadd(dd, 1, @day)
END


SELECT 	a.day,
	sum(CASE WHEN t.event_class = 14 THEN 1 ELSE 0 END) AS success_count,
	sum(CASE WHEN t.event_class = 20 THEN 1 ELSE 0 END) AS failure_count,
	@stddev AS stdev_all_count,
	CASE WHEN CONVERT(float, count(t.event_class)) > @stddev * 1.2 THEN 1 ELSE 0 END AS flagged_activity
FROM   @t AS a
	LEFT OUTER JOIN  my_user.audit_table AS t
		ON t.event_time BETWEEN a.day AND dateadd(dd, 1, a.day)
		AND t.event_time BETWEEN @start AND @end
		AND t.event_class IN (14, 20)
GROUP BY a.day
ORDER BY a.day

SET NOCOUNT ON