Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 59,091 total)

Reply To: Help with SQL Select with ^^^^
David Burrows wrote:
WHERE SUBSTRING([column],CHARINDEX('^',[column],PATINDEX('%PQ5|1|[0-9]%',[column])),4) = '^^^^'
If you look at the following post where the OP finally posted some semblance of the data he's actually trying to filter, you'll...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
June 29, 2020 at 3:41 pm

#3766204
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
A moment of silence, please.
I heard from his family and Mike Vessey, https://www.sqlservercentral.com/author/mvdba, passed away on 25 Jun 2020. I was pleased to meet Mike and host him...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 29, 2020 at 3:36 pm

#3766198
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Look at the code... I had to write it without being able to run it. You have the advantage of testing. 😀 Look at the ON clause... see the mistake...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 27, 2020 at 11:01 pm

#3765360
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Tech wrote:
well, that is way over my head. I have a lot to learn. I understand the Joins and the Alias but is there a way to do it with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 27, 2020 at 10:26 pm

#3765357
Reply To: How to get data for 7 days Sunday to Saturday of the previous week
I still don't have test data and don't have the time today to make some but this should be close...
```
   WITH cteShift AS
(
 SELECT ShiftStartDT...
```
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
June 26, 2020 at 11:14 pm

#3765294
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Understood... back in a few...

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 26, 2020 at 10:11 pm

#3765290
Reply To: Help with SQL Select with ^^^^

srisadhu wrote:
Just posting some solution that you can think of doensot make you pro and doesnot make ignorant.
When someone posts on forum it means that they can't get through documentation(which...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 26, 2020 at 7:06 pm

#3765268
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

It's difficult to tell if you just want a sum by week (observing the times of the shifts) or if you want the sums by shift. If the former, the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 26, 2020 at 7:01 pm

#3765267
Reply To: Help with SQL Select with ^^^^

Post deleted because the op seemed offended by advice on how to post such problems.,
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 26, 2020 at 5:47 pm

#3765263
Reply To: Need Help with SQL Code

I agree. It's been a very long time since I worked with Oracle but semi-colon placement was critical.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 26, 2020 at 3:11 am

#3765125
Reply To: Falling Over our Assumptions

Heh, nothing changes. I find the licks in the article to still be very relevant today and the more than a decade old discussion sound as if it occurred today.
Nothing...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 25, 2020 at 2:45 am

#3765015
Reply To: Storing VARCHAR(MAX) off-row

That leads us back to the question I asked that hasn't yet been answered... before the OP makes any "plans", the first thing that should be done is an evaluation...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 25, 2020 at 1:59 am

#3765011
Reply To: Storing VARCHAR(MAX) off-row

Lynn Pettis wrote:
Also, when you have columns that have the same names except ending with a 1 or a 2, you may also want to look at normalizing the data into...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2020 at 7:52 pm

#3764989
Reply To: Storing VARCHAR(MAX) off-row

richardmgreen1 wrote:
Hi Jeff
We have to pull in everything from the documents as we don't know what is needed for reporting purposes (orders from the higher-ups).
This is the only document that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2020 at 1:50 pm

#3764952
Reply To: Storing VARCHAR(MAX) off-row

Have you checked seriously to see if you need a table with than many NVARCHAR(MAX) columns? If so, perhaps you're using the wrong kind of database. Perhaps a "document" database...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 24, 2020 at 3:48 am

#3764862

Viewing 15 posts - 6,856 through 6,870 (of 59,091 total)