I have to add that it's the most powerfull tool, if the programmer can figure out all the possible uses.

varchar/text (might need unicode but I doubt it)

I confirm that behavior on sql server 2000 dev edition.

however this doesn't fail :

CREATE TABLE [dbo].[_tblFunc] (

[idfunc] [int] IDENTITY (1, 1) NOT NULL ,

[func] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

)...

I think you should really stick to english only .

I'll post the answer under a new thread.

NP. It's really annoying when you forget this trick and got only 1-2 cells to edit. Then you got to build a full update statement for just that

In enterprise manager :

Ctrl-0

in tsql :

update yourtable set yourfield = null

You just can't do that.

OR 1 IN (

declare @t int

set @t = 0

declare @u char

set @u = 'F'

set @u = (select isnull(support, 'F') FROM personnelData WHERE empID = $empid)

If you...

C'est pas grave... on l'aime pareils .

Ready for the final solution to be posted??

What would the query look like if you had C,N,Y,O as possible id2?

Would you have 4 derived tables now?

If you did EXEC sp_refreshview 'v_func'

then select * from v_func

then recompile the function

then select * from function, I think it would work.

Gonna restart the thread.. Where are the results?

That's the eas way out... But he would have to code each question manually in the query, or have a single scoring plan. Which he didn't seem to...

Can you post the query plan?? We can help you without that... except to tell you that the table with no index can be slowing things down.

Do you have...

Seems like the score depends on the question.

I would add another table like so :

QuestionsScoresRanges

QuestionID, ScoreFrom, ScoreTo, PointsValue

so you'd put in a few lines for each questions like

1, 0,...