Please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Where is the data coming from that you are trying to insert? I seem to missing something when I look at the code.

Unfortunately, I can't see what your package looks like, and I realize debugging an SSIS package over the internet is more difficult than SQL code, but without more info can't...

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?