New code formatting checks

Question

Post reply

New code formatting checks

Steve Jones - SSC Editor

SSC Guru

Points: 734434

May 2, 2019 at 2:15 pm

#3628294

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.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

anonuser Old Hand Points: 302 More actions · Answer 1

Steve Jones - SSC Editor wrote:

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.

Everything above this is quoted.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 2

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.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 3

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.ClaimDate

This appears to scroll.

The scrolling works, which is a good thing.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Luis Cazares SSC Guru Points: 183698 More actions · Answer 4

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.ClaimDate
This appears to scroll.
The scrolling works, which is a good thing.

Quoting code seems to be failing. Thanks for working on this.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 5

Yeah, posted another note on the issue and reopened that code needs to be quoted.

anonuser Old Hand Points: 302 More actions · Answer 6

Luis Cazares wrote:

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.ClaimDate
This 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