Is that automatically color-coded or you do do it by hand?

I'd like to know, because some examples I give here needs color-coding.

It seems that the function returns the same string for every row. If that is the case, store the function string before and update later, as

DECLARE @result VARCHAR(10)

SELECT @result =...

Yes, it does.

Here is another approach, which I also believe as faster than Tim's suggestion. Preliminary testing shows that it is 4 times faster.

CREATE FUNCTION dbo.fnTs2Bin8

(

    @TS VARCHAR(23)

)

RETURNS BINARY(8)

AS

BEGIN

    DECLARE...

Das ist ok. Ich werde Ihnen helfen, so viel wie ich kann. Nächste Woche ist mein letzter gewöhnlicher Job Woche vor dem Urlaub. Dann habe ich Urlaub seit 5 Wochen...

Hello again Thomas!

Here is your solution.

declare @test-2 table (personalid tinyint, name varchar(3), loginid smallint, site varchar(2))

insert @test-2

select 50 ,'Tom', 1234, 'OE' union all

select 50 ,'Tom', 5678,...

Yes?

I thought the idea was to return to ID where there was discrepancy, not the fk itself.

My mistake. You have written an awsome query! Now it is mine turn to...

Doesn't it only calculate if the number of fk for each id is different?

What if ID 1 has fk 3 and 4, while ID 2 has fk 3 and 5?...

Well. That is something I don't se very often these days. An ID storage table. So I don't know if you benefit from my suggestions, but here is a SET-based...