Also, does the row number get populated? Without that, you can't tell where the columns are. Rows have no natural order.

This can probably be done in T-SQL, though how do...

An I forgot. You can not like posts. There is a like link next to the date/time of a post

It was easiest to not rewrite. I personally think that's better as this isn't the thread, but a post.

It's possible, I think. Never thought about this, but I'll raise an issue to look at this. It's likely to be low priority, but an interesting idea.

A quote test:

SELECT *
FROM MyTable
WHERE ID = 1
AND Name = 'Thom'
AND Status !='';

Fingers crossed

Can I link to this post https://www.sqlservercentral.com/forums/topic/intra-site-links-at-least-to-other-forum-postsrender-incorrectly-in-the-forums#post-3098797

I hope so

Do you need to account for DST? Because the SWITCHOFFSET function wants your parameter to be DST adjusted when you pass it in.

Also, how do you get this data?

retired

Content didn't get published for some reason, so it's a 404 for you. I see it fine. Bug filed for scheduler issues.

That was a SPAM post, and it was removed between the time the newsletter was sent and you clicked the link. I'll work on a better messages.

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

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.*,...

Good luck. If you have more issues, ask more questions.

I encountered...