Where did the 'Insert Code' toolbar go?
-
Creating a forum reply in Chrome and I can't see the toolbar. Consequently I can't add an in-line image, but there's one attached.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
I tried both Edge and Chrome - no luck. Missing the menu items - assume there was a recent update?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs - Jeffrey Williams wrote:
I tried both Edge and Chrome - no luck. Missing the menu items - assume there was a recent update?
Thanks for verifying.
In addition, it seems that I am not receiving e-mail notifications when anyone responds to a post I am subscribed to.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
same issue - no emails and toolbar gone
-
I had noticed the same thing yesterday. I send Steve and WebMaster@SQLServerCentral.com and email outlining the symptoms. Steve emailed me that a ticket has been opened and the right folks have been alerted to expedite things. They're working on the issue.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Heh... I just went to the thread to post a point so people knew and the toolbar seems to have come back. What was cool was it actually took me to the right page on the tread.
Try things out and fire a flare if something's still amiss and once of us can point Steve to this thread if there is.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Testing the code window and paste from firefox... you can ignore this post...
Code Window and paste
-- Edit test here
DROP TABLE IF EXISTS #Result
GO
CREATE TABLE #Result(
EmpNr nvarchar(10) NOT NULL,
CompCode varchar(3)NOT Null,
PaymentDate varchar(8)Not Null,
FromDate varchar(8000) NULL,
ToDate varchar(8000) NULL,
TotalDays numeric(38, 2) NULL
) ON PRIMARY
GO
INSERT INTO #Result
VALUES
(800334,301,20210225,20210111,20210111, -1.00),
(800334,302,20210225,20210114,20210114, -1.00),
(800334,301,20210423,20210214,20210214, 1.00 ),
(800334,301,20210325,20210214,20210214, -1.00),
(800334,302,20210423,20210214,20210214, -1.00),
(800334,301,20210423,20210309,20210309, -1.00),
(800334,302,20210423,20210312,20210312, -1.00),
(800334,301,20210525,20210407,20210407, -1.00), -- Edit test here
(800334,302,20210525,20210408,20210412, -5.00),
(800334,302,20210525,20210414,20210420, -7.00),
(800334,301,20210525,20210511,20210511, -1.00),
(800334,302,20210525,20210512,20210524, -13.00),
(800334,304,20210525,20210525,20210531, -7.00),
(800334,304,20210624,20210601,20210606, -6.00),
(800334,301,20210924,20210820,20210820, -1.00),
(800334,302,20210924,20210825,20210825, -1.00),
(800334,301,20211025,20210910,20210910, -1.00),
(800334,302,20211025,20210911,20210915, -5.00),
(800761,302,20201223,20201112,20201117, -6.00),
(800761,301,20210125,20201214,20201214, -1.00),
(800761,302,20210125,20201215,20201223, -9.00),
(800761,301,20201223,20201111,20201111, -1.00),
(800761,301,20210225,20210120,20210120, -1.00),
(800761,302,20210225,20210121,20210122, -2.00),
(800761,301,20210325,20210211,20210211, -1.00),
(800761,301,20211125,20211018,20211018, -1.00),
(800761,302,20211125,20211019,20211031, -13.00),
(800341,301,20201125,20201022,20201022, -1.00) ,
(800341,302,20201125,20201023,20201025, -3.00) ,
(800341,301,20201223,20201103,20201103, -1.00) ,
(800341,302,20201223,20201104,20201104, -1.00) ,
(800341,301,20201223,20201119,20201119, -1.00) ,
(800341,302,20201223,20201120,20201129, -10.00),
(800341,301,20210125,20201217,20201217, -1.00) ,
(800341,302,20210125,20201218,20201230, -13.00),
(800341,301,20210225,20210111,20210111, -1.00) ,
(800341,302,20210225,20210112,20210124, -13.00),
(800341,304,20210225,20210125,20210131, -7.00) ,
(800341,304,20210225,20210201,20210207, -7.00) ,
(800341,304,20210225,20210208,20210221, -14.00),
(800341,304,20210225,20210222,20210228, -7.00) ,
(800341,304,20210325,20210222,20210228, 7.00) ,
(800341,304,20210325,20210222,20210228, -7.00) ,
(800341,301,20210423,20210301,20210301, 1.00) ,
(800341,301,20210325,20210301,20210301, -1.00) ,
(800341,304,20210423,20210301,20210314, -14.00),
(800341,302,20210325,20210302,20210314, -13.00),
(800341,302,20210423,20210302,20210314, 13.00) ,
(800341,301,20210525,20210408,20210408, -1.00) ,
(800341,302,20210525,20210409,20210421, -13.00),
(800341,305,20210525,20210422,20210430, -9.00) ,
(800341,305,20210624,20210501,20210514, -14.00),
(800341,305,20210624,20210504,20210514, -11.00),
(800341,305,20210624,20210515,20210531, -17.00),
(800341,305,20210723,20210601,20210630, -30.00),
(800341,305,20210825,20210701,20210731, -31.00),
(800341,305,20210924,20210801,20210815, -15.00),
(800341,305,20210924,20210816,20210831, -16.00),
(800341,305,20211025,20210901,20210905, -5.00) ,
(800341,305,20211025,20210906,20210923, -18.00),
(800341,305,20211025,20210929,20210930, -2.00) ,
(800341,305,20211125,20211001,20211003, -3.00) ,
(800341,305,20211125,20211004,20211025, -22.00),
(800341,305,20211125,20211026,20211026, -1.00 ),
(800341,305,20211125,20211027,20211031, -5.00) ,
(800341,302,20211220,20211201,20211215, -15.00)
SELECT *
FROM #Result
ORDER BY EmpNr,FromDate
;
-- Edit test hereNon-code window paste.. -- Edit test here
WITH cte AS
(
SELECT *
,PrevVisitType = LAG (VisitType,1,NULL) OVER (PARTITION BY MTMRN ORDER BY MTMRN, VisitDate)
,NextVisitType = LEAD(VisitType,1,NULL) OVER (PARTITION BY MTMRN ORDER BY MTMRN, VisitDate)
FROM #T
)
SELECT MTMRN,VisitDate,VisitType,PrevVisitType,NextVisitType
FROM cte
WHERE (VisitType = 'Appointment' AND PrevVisitType = 'Discharge')
OR (VisitType = 'Appointment' AND NextVisitType = 'Discharge')
OR (VisitType = 'Discharge')
ORDER BY MTMRN,VisitDate
;
Graphics paste
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Also, please check to see if you got an email about me responding on this thread.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
There was an update to WP (Security) and Project Nami (SQL Server port of WP) deployed. This updated the minification designed to compress the response code sent to the browser. This caused a minor JS bug that broke an IF statement that produces the toolbar.
Should be fixed, albeit a few buttons missing on the toolbar. Hoping to get those back soon.
-
Still no notification emails - at least I have not received any.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs - Jeffrey Williams wrote:
Still no notification emails - at least I have not received any.
Same here as of this instant.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Jeffrey Williams wrote:
Still no notification emails - at least I have not received any.
Same here as of this instant.
Yeah... absolutely confirmed. I'm definitely not getting any email notifications.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply