hic, i have another question

My table

CREATE TABLE [dbo].[AAATable01](

[K1] [int] NOT NULL,

[K2] [int] NOT NULL,

[KBN] [int] NULL,

[SKU] [int] NULL,

[MONEY] [int] NULL,

)

With data

K1 ...

Thanks HowardW , a good asnwer

😀

😀 many many pro SQL

I like ChrisM@home's SQL. I compare 3 SQL and the best performance is: My SQL :-D:-D

Thank Jeff Moden 😀

I were try this SQL but it complex, any one else?

SELECT

Col1,

Col2,

Col3,

Max(Rnk2) OVER (PARTITION BY Col1) as C_col21,

Max(Rnk3) OVER (PARTITION BY Col1) as C_col31

FROM

(SELECT

...

I...

C_col21: count distinct col2 by col1

C_col31: count distinct col3 by col1

Regard

Ah, Tally table. Thanks Peter Brinkhaus.

thanks Peter Brinkhaus. so it's will wrong if @i > 2100

Thanks Peter Brinkhaus.

Thanks for your reply but your SQL cannot extract this data

2 b 2 null <--A.K=B.K...

I have same problem but my data is:

create table A

(

H int,

D int

)

insert into A

select...

thank All.

I understand about this case.

I understand about this case, thank all.

Thanks for your saving me.:-D

CREATE TABLE TEMPTEST

(

INT...