Try this one

SUM(CASE CAST(IA.IAT_DATA AS VARCHAR(25)) WHEN 'Financial Reporting' THEN 1 AS ELSE 0 END) AS [Financial Reporting],

SUM(CASE CAST(IA.IAT_DATA AS VARCHAR(25)) WHEN 'Performance Management' THEN 1 ELSE 0 END)...

try this one

SET @CMD = 'SELECT [' + @ColName + '] from [Resource]' + ' where [date] between ''' + @sDate1 + ''' + and + ''' @sDate2 + ''''

exec...

Your First Problem is that you did the spelling mistake in deallocating the cursor curInsterted instead of curInserted.

To debug your trigger ,first install the SQL server debugger and then...

This Error is Not Coming because of the parameter you are passing but the Prcessing you are doing in your procedure do one thing take the query from web page...

Thanks Calvin and David for your responses

As Calvin you told that there is one method of fetching all the rows from one table

Now i just want to know that...

i have also faced this problem

Statements given below should trap the error but will not

i have gone through bol where there is written about severity of error but not...

use this connection string then try agin fetching the records in record set

"driver={SQL Server};server=;database=;uid=;pwd="

thank god you have dicussed this problem . i got the solution

Create Function sf_Monthlyconsumption(@DD Varchar(2),@MM Varchar(2),@YY Varchar(4))

Returns Table

As

--change sysobjects with your table

 Return Select * From Sysobjects Where Cast(Cast(month(CrDate) as varchar(2)) +'/'+Cast(Day(CrDate) as varchar(2))+'/'+Cast(Year(CrDate) as varchar(4)) as DateTime) > Cast(@MM+'/'+@DD+'/'+@YY As...

Yes you are right !!!

that means you can not use Set Commnads in UDF so any can make me available limitations od UDF cause i use them exetensively

Select * From Table1

Join Table2

On

Table1.DateField=Cast(Table2.CharDateField +' '+Table2.CharTimeField as DateTime)

a

Create Function DateOnly(@dt DateTime)

returns Datetime

as

begin

return Cast(convert(varchar(8),@dt,1) AS datetime)

end

select * from test where dbo.Dateonly(chkdate) = '2004-01-06'

This way...

UDF can not contain strored procedures calls and also you can not use set command in UDF so if any output required is in table with these requirements in...