Where are you exectuting this code?

What application?

What do you mean performance issue?

Are you seeing a decrease in query times?

One thing you MUST do is create check constraints on each table the check constraint is what your...

Go to the Data Tab. using dropdown select the recordset your working with.

Then click the ... Elipse. Go to the parameters tab.

Make sure the report parameters are aligned with parameters...

Something is missing where are you setting @Amount to a value,

second if your using a variable in the sp_Executesql you have to set it. Note where bolded setting @level...

Do a search for Case,

There are a million examples of this.

create table #mytable (Sno int, Colour varchar(10))

insert into #mytable (Sno, Colour)

select 1,'Red' union

select 2, 'Blue' union

select 3, 'Green'

select min(case...

The error simply means one of the values you are putting into the table is larger than the column definition.

The pain with this is it doesn't tell you which column...

To get rid of the internal error you cannot use the correlated subquery as a join operator., Just move it to the where clause,

And to get the results you...

The Data sources used in the dev environment are not deplyed to the report server.

Make sure you have a shared data source on the report server in report manager, and...

It would be easier if you would give a little more specific example on the names of the text fields, makes the code easier to follow.

But I think this is...

Can you please post a sample table structure, with some sample data, and what your expected results are.

http://www.aspfaq.com/etiquette.asp?id=5006

the way you had it would execute inefficiently and not use indexes.

Try this way.

SELECT dbo.DEC_TXN.*

FROM dbo.DEC_TXN

INNER JOIN dbo.CALENDAR ON...

Which column are you trying to set

Update Mytable

set Void = case when Cancelled = F and ServiceEvent = T Then 1

...

Depends on what version your using, sql 2000, or 2005.

For 2000

Open analasys manager, Open up your cube database, select database roles.

Only use nulls if your application requires it. It NULL is a valid value, meaning Unknown then use them, other wise avoid them by placing default values.

You cannot pass record sets around into variables like that. Sql server does not support Arrays.

Give this a read it has all you need.

http://www.sommarskog.se/share_data.html