Thank You ALL very much!

Sorry

DECLARE @T table (A int )

insert into @T

values

(1)

,(0)

,(1)

,(0)

,(1)

,(2)

,(1)

,(0)

,(1)

,(2)

,(3)

,(2)

,(0)

,(1)

Hello Thom

It works!!

Thank you very much

Thank you very much

Thank you MARK/PHIL

Now it works

Thank you very much

IT works if id has 2 records.

But what if there are   more than 2 records for let say id=1 ?

CREATE TABLE  Game

(id int,

Game_Time date

)

INSERT INTO Game

VALUES

(1,'20220101'),

(1,'20220102' ),

(1,'20220105'),

(1,'20220106' ),

(1,'20220107'),

(1,'20220108' ),

(2,'20220103'),

(2,'20220104' ),

(2,'20220105'),

(2,'20220106'...

no duplicates. With the first script, I am trying to get all 5 records, but getting only 3 of them. With the second script, I am trying to see if...

Correction:

with x as

(select * from table1

)

insert into table2

select * from x

some of the records are missing. Let's say records 1 and 3 are missing.

when the same script says

(select * from...

doing it in two stages works.I guess this specific t-sql  has comparability issue between 2014 and 2017 versions of sql server

Thank you guys.

Hi Guys.

Our company in transition to move to AWS cloud.I created new database on AWS and uploaded full,dif and trn backups of our production database  into S3 bucket.Now i need...

Thank you,
I came up with this which works as well
SELECT client_id, PU
FROM (
    SELECT client_id AS CLIENT_ID, PU, Due_time, ROW_NUMBER() OVER (
            PARTITION BY (
                pu, due_time...

Whoo hooo it worked.

Thank you very much sgmunson

"Do you have any third party applications running in SSMS on your machine? "

I have RedGate...

Assuming that you have tried to terminate the session using 'kill spid', I run into this issue from time to time. You need to see what the session is doing...

I restarted my workstation and it's gone.I just wonder what does this query do?