Viewing 15 posts - 436 through 450 (of 15,381 total)
May 16, 2018 at 2:10 pm
May 16, 2018 at 1:36 pm
Stewart "Arturius" Campbell - Wednesday, May 16, 2018 12:05 AMThat is a really strange way to cut data.
Interesting question, thanks Steve.
Strange is...
May 16, 2018 at 7:18 am
DECLARE @t table(Participants nvarchar(1000));May 15, 2018 at 7:01 am
The basic gist here is that you would use Jeff Moden's splitter to normalize this first. Then you would use STUFF and FOR XML to denormalize into two pieces of...
May 14, 2018 at 1:18 pm
May 14, 2018 at 1:15 pm
May 14, 2018 at 10:08 am
The issue here is that your original data structure is downright awful. It violates 1NF. And the desired output isn't really any better. You are taking one denormailzed pile of...
May 14, 2018 at 9:36 am
May 9, 2018 at 12:31 pm
May 9, 2018 at 6:58 am
May 8, 2018 at 1:27 pm
It is no secret that queries from ORMs are horrific.
I think they can be...
May 8, 2018 at 12:58 pm
May 8, 2018 at 12:28 pm
May 8, 2018 at 10:31 am
Viewing 15 posts - 436 through 450 (of 15,381 total)