May 2, 2019 at 2:15 pm
I enter this text first with some questions. Now I enter code
CREATE TABLE Claim
( PharmNo VARCHAR(20)
, ClaimNo VARCHAR(20)
, ClaimDate date
)
GO
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate)
VALUES ('ABC', '123', '2019-01-01'),
('ABC', '987', '2019-01-02'),
('DEF', '234', '2019-02-01'),
('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.*
FROM Claim a
INNER JOIN Claim b
ON a.PharmNo = b.PharmNo
AND a.ClaimDate < b.ClaimDate
Below the code, I've entered this line.
May 2, 2019 at 2:19 pm
I enter this text first with some questions. Now I enter code
CREATE TABLE Claim
( PharmNo VARCHAR(20)
, ClaimNo VARCHAR(20)
, ClaimDate date
)
GO
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate)
VALUES ('ABC', '123', '2019-01-01'),
('ABC', '987', '2019-01-02'),
('DEF', '234', '2019-02-01'),
('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.*
FROM Claim a
INNER JOIN Claim b
ON a.PharmNo = b.PharmNo
AND a.ClaimDate < b.ClaimDateBelow the code, I've entered this line.
Everything above this is quoted.
May 2, 2019 at 2:32 pm
Let's check wide code in this post.
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate) VALUES ('ABC', '123', '2019-01-01'), ('ABC', '987', '2019-01-02'), ('DEF', '234', '2019-02-01'), ('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.* FROM Claim a INNER JOIN Claim b ON a.PharmNo = b.PharmNo AND a.ClaimDate < b.ClaimDate
This appears to scroll.
May 2, 2019 at 2:46 pm
Let's check wide code in this post.
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate) VALUES ('ABC', '123', '2019-01-01'), ('ABC', '987', '2019-01-02'), ('DEF', '234', '2019-02-01'), ('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.* FROM Claim a INNER JOIN Claim b ON a.PharmNo = b.PharmNo AND a.ClaimDate < b.ClaimDateThis appears to scroll.
The scrolling works, which is a good thing.
May 2, 2019 at 2:46 pm
Steve Jones - SSC Editor wrote:Let's check wide code in this post.
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate) VALUES ('ABC', '123', '2019-01-01'), ('ABC', '987', '2019-01-02'), ('DEF', '234', '2019-02-01'), ('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.* FROM Claim a INNER JOIN Claim b ON a.PharmNo = b.PharmNo AND a.ClaimDate < b.ClaimDateThis appears to scroll.
The scrolling works, which is a good thing.
Quoting code seems to be failing. Thanks for working on this.
May 2, 2019 at 4:14 pm
Yeah, posted another note on the issue and reopened that code needs to be quoted.
May 17, 2019 at 6:01 pm
Luis Cazares wrote:Steve Jones - SSC Editor wrote:Let's check wide code in this post.
INSERT dbo.Claim (PharmNo, ClaimNo, ClaimDate) VALUES ('ABC', '123', '2019-01-01'), ('ABC', '987', '2019-01-02'), ('DEF', '234', '2019-02-01'), ('HIJ', '343', '2019-03-01')
GO
SELECT a.*, b.* FROM Claim a INNER JOIN Claim b ON a.PharmNo = b.PharmNo AND a.ClaimDate < b.ClaimDateThis appears to scroll.
The scrolling works, which is a good thing.
Quoting code seems to be failing. Thanks for working on this.
Is the code quoted? It should be indented from this code:
SELECT NumericValue = CAST(x.RecValue AS DECIMAL(17, 2))
FROM
(
SELECT TOP 2147483647
T1.RecValue
FROM
T1
INNER JOIN T2
ON T1.TypeId = T2.Id
WHERE T2.ContentType = 'N'
) AS x
WHERE CAST(x.RecValue AS DECIMAL(17, 2)) > 10;
This should eb my last line of text
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply