Database

Unsy wrote:

Please excuse the SQL code if it is full of errors as I am 250 miles from home

SELECT
    Field1
   ,Field2
   ,SUM( CASE Divisor
            WHEN 0 THEN 0
            ELSE Amount / Divisor
         END)
FROM (
   SELECT Field1,
          Field2,
          SUM(CASE 
                 WHEN Field3 IS NOT NULL OR Term - @WeeksPassed > 0 
                 THEN 0 
                 ELSE 1 
              END
          ) amount,
          SUM(CASE 
                 WHEN Field4 IS NOT NULL OR Term - @WeeksPassed > 0 
                 THEN 0 
                 ELSE 1 
              END
          ) divisor
   FROM
       Table1
   GROUP BY
       Field1
      ,Field2) alias
GROUP BY
    Field1
   ,Field2

Aman786Singh wrote:

i ran sp_configure command on my both servers. the values are - 1

SET REMOTE_PROC_TRANSACTIONS ON

... tJ.cdSubjectCode LIKE (CASE @ciSubjectId
                              WHEN '' THEN tJ.cdSubjectCode 
                              ELSE '%' + @ciSubjectId + '%'
                           END)...

declare @ciSubjectId varchar(50);
SET @ciSubjectId = 'table';
SELECT *
FROM sysobjects
WHERE
     --tJ.cdSubjectCode 
     name LIKE (CASE @ciSubjectId                              
                WHEN '' THEN name
                ELSE '%' + @ciSubjectId + '%'
                END)

dptalt wrote:

Syntax error converting the varchar value '4,25' to a column of data type int

tLD.idClientDeptNumb IN (
   CASE 
     WHEN @ciDept <> '' 
         THEN CONVERT(REAL, REPLACE(@ciDept, ',', '.')) 
      ELSE tLD.idClientDeptNumb 
   END...