May I add that, in my case anyway, it really helps me a lot being here in the fora. Reading someone's problem, think about it and researching the answer was...

Hehe, Patrick, I remember this thread

Anyway, I am now kind of in a similar situation. I'm not working in the IT business at...

If you have the option to change the underlying data type in the table, you should do so. That way you avoid many problems that might come. In a SELECT...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240872

http://support.microsoft.com/default.aspx?scid=kb;EN-US;221465

HTH

When you talk of the wolf, you will see it's tail.

Hui, that sounds dangerous!

Auf Wiederschreiben! Though this phrase does not exist, you might want to stay with the...

Not sure, if I understand you.

If you want to know how to create an encrypted procedure, have a look at BOL at CREATE PROCEDURE. AFAIK, you can't create encrypted functions.

But...

Okay, then we should leave this thread alive.

Still I think, posting your table structure(s) makes things a lot easier.

Please don't cross-post in multiple fora here. That makes it difficult to see who answered what where already.

To answer your question, can you post your table structure(s)?

Before you start, read this http://www.insidesql.de/content/view/160/ It's based on a great posting from 5400andsoon (aka Len Esterhuyse) here some time ago. You might also find it here via a forum...

Actually it is an easy and convenient way to fubar SQL Server, IMHO.

Quand on parle du loup, on en voit la queue

Two days...

When you create an index on more than one column, you automatically have a composite index. And this one can either be on a non-clustered or on a clustered index.

SQL Server 2000 though will actually reset the values and the output looks like this

ColName OrdPos

-----------  ---

Col1         1

Col2         2

Col5         3

Col6         4

Umh?

create table t

(

 c1 int

 , c2 int

 , c3 int

)

select cast(name as...

That must be it

DECLARE @test-2 TABLE(

 [Test_WK] [int],

 [Test_CODE] [varchar] (4)

PRIMARY KEY (Test_WK, Test_CODE)

)

Oops, forget it.

Reread it that you want it on both columns. Sorry.

Doesn't this work?

DECLARE @test-2 TABLE(

 [Test_WK] [int] PRIMARY KEY,

 [Test_CODE] [varchar] (4)

)