your second example is throwing out so many rows because you are doing a cross join between your two derived tables.

Not exactly sure what your output needs to be...

Bummer, a quick lookup of the error message on msdn provides the following info, and document

I/O logical check failure: If a read Windows API call or a write Windows API...

Couple things.

Case statement is fairly simple.

Constructed 2 ways

always starts with the case keyword and ends with the end keyword.

you can make the expression 2 ways.

when you are just comparing values...

A parameter can only have one value,

so right here

Select @recordid=reminder.record_id,

@formtype=reminder.form_type,

@respparty=reminder.resp_party,

@resppartyemail=reminder.resp_party_email,

@subject=reminder.subject

from reminder

the parameters can only hold the last value.

but you will either have to use a cursor or...

The beautiful thing about this message is it does not tell you what column is having the trucation issue.

so you have to compare datatypes and sizes of source and destination...

What version of sql are you using?

Ansi_Nulls, and ANSI_WARNINGS are connection settings, so when you connect you tell sql you must tell sql what values you want these to...

What differences are you looking for?

Differences in DDL?

or differences in data?

Weird, I'm not sure what you mean by Check syntax. When I Copy your procedure into a query window and parse it, it looks fine.

But I'm sure your getting your...

Well it depends on how your application authenticates users.

Does the application grant the user access to your database by using their windows login?

or does the user physically have to type...

CASE cannot be used in this manner.

you have to stick with IF..ELSE Statements

select name, min(case when td.event_id = 'sd 099' then final_grade else null end) as 'sd 099'

, min(case when td.event_id = 'sd 102' then final_grade else null end) as 'sd 102'

from...

It is very simple,

I'm not sure if this is a trick question.

Under the report drop down, Select Report Parameters.

Configure your parameter.

and then you can use it to plug into...

Because at the storage level Sql server interprets datetime as 2 separate integers.

1 integer is the # of days past 01/01/1900. and the second is the Milliseconds past Midnight.

So if you...

select

Sum(case when datediff(yy, ub.Paint