Lynn Pettis

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 26,484 total)

RE: The SQL Saturday Thread

Michael L John - Wednesday, March 27, 2019 12:20 PM
On your way back home, stop at Skyline Chili and get a...

March 27, 2019 at 12:22 pm

#2033998
RE: CTE Group By not grouping results correctly

kdrymer - Tuesday, March 26, 2019 4:13 PM
below86 - Tuesday, March...

March 26, 2019 at 9:51 pm

#2031851
RE: CTE Group By not grouping results correctly

below86 - Tuesday, March 26, 2019 3:18 PM
I see Lynn, but I'll take my chances for now.
WITH CTE AS
(SELECT...

March 26, 2019 at 3:27 pm

#2031838
RE: CTE Group By not grouping results correctly

below86 - Tuesday, March 26, 2019 3:08 PM
Lynn Pettis - Tuesday, March 26, 2019 2:28 PM

March 26, 2019 at 3:12 pm

#2031834
RE: Need some help with a query

Dra-489663 - Tuesday, March 26, 2019 2:43 PM
Lynn Pettis - Tuesday, March 26, 2019 2:07 PM

March 26, 2019 at 3:07 pm

#2031832
RE: CTE Group By not grouping results correctly

I reformatted your original code like this:

WITH [CTE]
AS
(
SELECT
[A].[BUSINESS_UNIT]
, [A].[PO_ID]
, [A].[PO_TYPE]
,...

March 26, 2019 at 2:28 pm

#2031827
RE: CTE Group By not grouping results correctly

kdrymer - Tuesday, March 26, 2019 2:04 PM
below86 - Tuesday, March 26, 2019 1:55 PM

March 26, 2019 at 2:13 pm

#2031824
RE: Need some help with a query

Dra-489663 - Tuesday, March 26, 2019 1:49 PM
sgmunson - Tuesday, March 26, 2019 10:00 AM

March 26, 2019 at 2:07 pm

#2031823
RE: Need some help with a query

Dra-489663 - Tuesday, March 26, 2019 9:05 AM
It's cool, I figured it out 🙂
Also I disagree with a "heck of a lot...

March 26, 2019 at 12:39 pm

#2031805
RE: Problem using CTE

wegrob - Tuesday, March 26, 2019 6:27 AM
That is interesting to know that SQL may not process the CTE first. I did...

March 26, 2019 at 7:13 am

#2031762
RE: Limit Size of Tables

RonMexico - Monday, March 25, 2019 8:16 AM
I want to be able to control it at the table level. They should be...

March 25, 2019 at 10:33 am

#2031691
RE: Like operator with additional conditions

drew.allen - Friday, March 22, 2019 12:56 PM
Lynn Pettis - Friday, March 22, 2019 10:51 AM

March 22, 2019 at 1:11 pm

#2025277
RE: Like operator with additional conditions

Scott Coleman - Friday, March 22, 2019 12:52 PM
It is possible to do it while only evaluating each condition once.
SELECT...

March 22, 2019 at 1:10 pm

#2025276
RE: Looping through a table-valued function

RacerX330 - Friday, March 22, 2019 12:39 PM
Lynn Pettis - Friday, March 22, 2019 11:00 AM

March 22, 2019 at 12:48 pm

#2025267
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

matter2003 - Friday, March 22, 2019 11:22 AM
Lynn Pettis - Friday, March 22, 2019 10:55 AM

March 22, 2019 at 11:39 am

#2025245

Viewing 15 posts - 421 through 435 (of 26,484 total)