Viewing 15 posts - 1,396 through 1,410 (of 4,087 total)
Is there a better way to re-write below type of queries? Most developers...
December 27, 2017 at 7:13 am
This is a fairly straitforward gaps and islands problem. Here is a solution. There may also be a solution with LAG, but I don't have access to a SQL...
December 26, 2017 at 9:49 am
What are your expected results?
Drew
December 26, 2017 at 8:52 am
Following are the values in main table.
Name ...
December 26, 2017 at 7:29 am
December 22, 2017 at 12:54 pm
Koen Verbeeck - Friday, December 22, 2017 12:32 AMPoor Drew. Noboby has selected her as an answer....
Drew is not typically a woman's...
December 22, 2017 at 10:35 am
December 22, 2017 at 7:50 amSELECT
Let's start by providing some sample data and expected results as outlined in the first link in my signature. This will help answer some basic questions.
Also, you say...
December 22, 2017 at 7:28 am
Use PATINDEX to search for two consecutive line terminators. So the next question is whether your data uses Windows (CrLf), Mac(Cr), or Unix(Lf) line terminators.
Of course, this assume...
December 21, 2017 at 2:01 pm
Is there a better way to rewrite below code without using DISTINCT operator. Other...
December 21, 2017 at 1:49 pm
December 21, 2017 at 1:26 pm
Viewing 15 posts - 1,396 through 1,410 (of 4,087 total)