`WITH Seq AS ( SELECT Number , FirstNameSeq = ABS(CHECKSUM(NEWID())) % @FirstName_Range + @FirstName_StartValue , MiddleNameSeq = ABS(CHECKSUM(NEWID())) % @FirstName_Range + @FirstName_StartValue , LastNameSeq = ABS(CHECKSUM(NEWID())) % @LastName_Range + @LastName_StartValue , BirthYearSeq = ABS(CHECKSUM(NEWID())) % @BirthYear_Range + @BirthYear_StartValue , StudySigSeq = ABS(CHECKSUM(NEWID())) % @StudySig_Range + @StudySig_StartValue FROM DataSampling.dbo.Numbers WHERE Number BETWEEN 1 AND @BirthYearCount
My actual work query was an inner join, but this simple example with cross join seems to nearly always reproduce the problem. SELECT * FROM ( SELECT 1 UNION ALL SELECT 2 ) AA ( A ) CROSS JOIN ( SELECT NEWID() TEST_ID ) BB ( B ) With my inner join I had many rows for which I added t...
Update 1 - 2022-01-25 Most of the reported bugs have been squashed. We're currently gathering together all the discussion and feature-request feedback items to decide how we want to alter the design. Thank you everyone for your feedback. Original Post tl;dr We’re starting a rollout of the new po...
feature-request I cared about question scores, but now my head hurts. On the previous layout, I could quickly survey the question scores by reading down the votes column: Now, I simply cannot quickly survey the front page for question scores, as those scores are quite small and buried between ot...
« first day (4040 days earlier) ← previous day next day → last day (827 days later) »