Try this. You need to do the casts in the comparision.

select

tli.iItemID,

tva.ianswerID,

CAST(tva.nvcanswer AS varchar(max)),

...

Unfortunately, we can't see what you see and you aren't giving us enough information to really help. Please provide the FULL error message(s) you have received.

It would help if provided the DDL (CREATE TABLE statements), sample data (in a readily consummable format that can be cut/paste/run in SSMS), expected results bassed on the sample data,...

Please, when you get a chance, go back and eliminate the cursor. Since there is a set-based solution, you really should use that as it should scale better than...

With some of the issues I have at times here at work,...

Have to agree, this is how to accomplish this task. Too bad the OP didn't show us what they had tried.

create table dbo.Grade (

LowPercent tinyint,

...

Doesn't mean the problem is in the data. It could be a problem in the front-end.

Personally, I'd rewrite this but here is what you should try:

SELECT PART.DESCRIPTION,

sum(case when invoice_date between '1/1/'+@Year and '1/31/'+@Year then total_amount else 0 end) as 'Jan',

sum(case when invoice_date between '2/1/'+@Year and...

Untested as you didn't provide the necessary DDL or sample data:

select

cl.*

from

dbo.calllog cl

where

not exists(select 1 from dbo.asgnmnt asg where...

Please provide the DDL for the tables (CREATE TABLE statements), sample data in a readily consummable format (We should be able to simple cut/paste/execute to load the tables), expected results...

Options page. This won't, however, change the collation of character data in any of the tables. Those will still have the case sensitive collation.

Curious, why the concern? ...

What makes you think that there are carriage returns in the datetime data?

Both work for me, but then AdventureWorks database on my development server is using a case insensitive collation. It appears that your install of AdventureWorks is using a case...

Are you asking this because you are preparing to interview people for an SSRS position or to prepare for an interview for an SSRS position?

??????? :blink: ????????

Care to share your solution; and I mean the code, not just what you did?