Try defining the parameter as varchar(50) and filter it in the query like this:

( SELECT name + ',' + state

...

The parameter should be definded as float, if it holds float data and is compared to a float column.

What value are you passing?

Which datatype did you choose for the stored procedure parameter?

Which table field are you comparing to the parameter?

Very well. Still missing definition for table [be_xref_oa]. Can you post it?

Can you post the procedure signature as well?

I think you can raise an error and have it returned to the report.

Am I missing something?

Same as here

This should do the trick:

DECLARE @test-2 TABLE (

D int,

HT int,

Adresse1 char(2),

Adresse2 char(2)

)

INSERT INTO @test-2 VALUES (1,1,'AD','DS')

INSERT INTO @test-2 VALUES (1,2,'BS','HG')

INSERT INTO @test-2 VALUES (1,3,'XD','JH')

SELECT address

FROM @test-2 AS T

UNPIVOT (address FOR...

Tom Brown (4/22/2010)

---

Gianluca Sartori (4/22/2010)

---

Jack Corbett (4/22/2010)

---

Gianluca Sartori (4/21/2010)

---

I've seen even worse things in my app (Visual Basic):

Public const SC AS String = "'" 'Yes, you got...

Jack Corbett (4/22/2010)

---

Gianluca Sartori (4/21/2010)

---

I've seen even worse things in my app (Visual Basic):

Public const SC AS String = "'" 'Yes, you got it right, it's a single...

You'd better post the whole procedure text, including parameters and their data type.

It would also be extremely useful if you could post table scripts, in order to understand which data...

You're welcome!

Glad this solved your issue

A nonclustered index should drop very quickly (should be metadata only).

I found this in BOL, maybe it could be helpful, even if it comes from SQL2008...

It depends...

Is the index clustered or nonclustered? It makes a huge difference.

This should do the trick for you:

declare @CurrentSPResult table(ID int,name varchar(50),unitscompleted varchar(50))

insert into @CurrentSPResult

select 50547, 'rupert', '30%'

declare @CodeTable table(ID int,PersonID int,Code1 char(1),Code2 char(1),Code3 char(1))

insert into @codetable

select 1 ,50547 ,'O'...

Ooops! MDF file has usually id = 1, not 0.

Try to run this and you'll get the file list for your database:

select *

from sys.database_files