Viewing 15 posts - 1 through 15 (of 92 total)
Thank you MARK/PHIL
Now it works
Thank you very much
April 12, 2022 at 2:21 pm
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'...
April 12, 2022 at 5:04 am
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...
March 25, 2021 at 9:43 pm
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...
March 25, 2021 at 8:54 pm
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.
June 29, 2020 at 7:34 pm
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...
June 27, 2019 at 6:16 pm
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...
November 21, 2018 at 2:17 pm
Whoo hooo it worked.
Thank you very much sgmunson
March 2, 2018 at 12:57 pm
"Do you have any third party applications running in SSMS on your machine? "
I have RedGate...
January 8, 2018 at 3:57 pm
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...
January 8, 2018 at 12:38 pm
I restarted my workstation and it's gone.I just wonder what does this query do?
January 8, 2018 at 12:35 pm
Thank you Grant for reply.They are separate processes,i just listed together.
Session 1: Update table1 set date='20170101' where item_id=10
Session 2: Select t2.Item_ID,t2.Col1,t2.Col2 from table2 t2,table1 t1 where t2.Item_ID=t1.Item_ID and t1.date>'20170401' and...
May 8, 2017 at 11:17 am
Installed SSMS 2014 and it works just fine.
Thank you very much
March 1, 2017 at 1:28 pm
Thanks for reply.
"SSMS version on your workstation is pre-2012 is my guess. " Yes.Is that a cause of the problem?
March 1, 2017 at 12:59 pm
Viewing 15 posts - 1 through 15 (of 92 total)