Database

SELECT
	PID,
	AVG(qty)/DATEDIFF	(d,MAX(date),	MIN(date))
FROM TableName
WHERE date > DATEADD(-6, GETDATE())
GROUP BY pid

SELECT ...
FROM DatesBetween(startdate, enddate) a
WHERE DATEPART(weekday, a.DateValue) = 1;

DECLARE @start DATETIME = '1950-01-01'
DECLARE @end DATETIME = '2011-03-31'

;WITH dateRange (date)
AS
(
	SELECT
        @start Date
    UNION ALL
    SELECT
        DATEADD(day, 1, Date) Date
    FROM
        dateRange
    WHERE
        Date < @end
) 
SELECT * FROM dateRange WHERE DATEPART(WEEKDAY,date) = 1
OPTION (MAXRECURSION 32767);

DECLARE @start DATETIME = '1950-01-01'
DECLARE @end DATETIME = '2011-03-31'
DECLARE @dates TABLE (date DATETIME)

WHILE (@start <= @end) 
BEGIN
      INSERT INTO @dates VALUES (@start);
      SET @start = DATEADD(day, 1, @start);
   END;
SELECT * FROM @dates WHERE DATEPART(WEEKDAY,date) = 1

DECLARE @start DATETIME = '2011-01-01'
DECLARE @end DATETIME = '2011-03-31'

;WITH dateRange (date)
AS
(
    SELECT
        @start Date
    UNION ALL
    SELECT
        DATEADD(day, 1, Date) Date
    FROM
        dateRange
    WHERE
        Date < @end
)
SELECT * FROM dateRange 
WHERE DATEPART(WEEKDAY,date) = 1 -- 1 is Sunday

UPDATE TableName
SET ColB = CASE
              WHEN ColA < 0 THEN 0
              ELSE ColA
           END;

UPDATE TableName
SET ColB = CASE
              WHEN ColA >= 0 THEN 0
              ELSE ColA
           END

UPDATE table SET colB = DECODE( SIGN( colA ), -1, colA, 0 )

Mika Wendelius wrote:

you're sure the IF is not hit at all...

Mika Wendelius wrote:

call this procedure from another and check if you can handle the error properly in the calling procedure.

EXEC [spName]

IF(@@error <> 0)
BEGIN
	Print 'No error'
END
ELSE
BEGIN
	Print 'error'
END