Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 59,067 total)

Reply To: Newbie question , get data from table

data victim wrote:
patrick chan, while Phil's answer is totally correct, if you are an absolute beginner, his reply might be too complicated for you to understand (you should take efforts to...
--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)

July 29, 2022 at 12:05 am

#4069732
Reply To: Execution Times vs Logical Reads/Scan Count

Brayan wrote:
Buenas tardes,
dependiendo el caso son importantes las lecturas lógicas ,
y en otros casos es importante el tiempo de ejecucion,
Lecturas Lógicas : Consumo
Tiempo de Ejecución: el tiempo es importante, por...
--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)

July 29, 2022 at 12:02 am

#4069730
Reply To: Newbie question

It's a funny thing. In the early days of PCs, me and a buddy of mine built over 3000 PCs and setup the network and many of the file servers...
--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)

July 28, 2022 at 11:58 pm

#4069729
Reply To: Substring charindex Mid - Get name within String

SQL_Kills wrote:
Hi,
I am trying to get the name inbetween the forward slash / for the column Full List
There are cases where there are no forward slashes so I will take...
--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)

July 28, 2022 at 11:43 pm

#4069727
Reply To: How to Find the Start and End Dates for the Current Week (and more)

hmbacon wrote:
Another excellent article. I am currently working on a budgeting application in Oracle and decided to use these concepts in Oracle. WARNING: For anyone else wanting to use these...
--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)

July 28, 2022 at 11:30 pm

#4069725
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
Thank you for your initial reply. I casted to CHAR. It fixed itself.
Thanks.
That would do it, for sure. I'm still amazed that someone would make the mistake of storing...
--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)

July 28, 2022 at 2:58 pm

#4069529
Reply To: Get Saturday from the week specified in column

You haven't answered my question... what is the datatype of your S1SDAT column? If it's an INT, BIGINT, DECIMIAL(X,0) or any other datatype that doesn't have the word DATE in...
--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)

July 28, 2022 at 4:57 am

#4069276
Reply To: Get Saturday from the week specified in column

Ok, Jeremy... the following code will do the same thing as above but without you having to install the Tally function. Again, you don't need all of this code. You...
--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)

July 28, 2022 at 4:23 am

#4069268
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
I am really sorry but I don't think I am allowed to install that in my database. Maybe there is a different way...
Who knows. They might have something similar...
--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)

July 28, 2022 at 4:13 am

#4069265
Reply To: Get Saturday from the week specified in column

Ok, Jeremy... If you look in my signature line just below the body of this post, you'll find a link with the word "(fnTally)" in it. Go to that article...
--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)

July 28, 2022 at 3:16 am

#4069244
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
Scott
I am getting an error "Arithmetic overflow error converting expression to data type datetime."
Almost there but you post above brings to question... what is the datatype for your S1SDAT...
--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)

July 28, 2022 at 2:43 am

#4069237
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
Hello everyone,
I have such an issue. I have a column S1SDAT that contains dates within the week period normally from what I see Mon - Fri and then I...
--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)

July 27, 2022 at 11:51 pm

#4069189
Reply To: How to get an SQL Statement that would clone a table with data?

Heh... lordy. That's a snoot full of code. Thanks, Jonathan.
--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)

July 27, 2022 at 8:50 pm

#4069121
Reply To: How to get an SQL Statement that would clone a table with data?

Yep... if they can make stuff like that clickable, why can't they make it codeable? The answer is, they can but haven't,
--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)

July 27, 2022 at 7:14 pm

#4069090
Reply To: How to get an SQL Statement that would clone a table with data?

Phil Parkin wrote:
This link shows you how to use SMO to generate the CREATE TABLE script.
I wish they'd build stuff like "GenTableScript" and "GenIndexScript" into SQL Server. It would make...
--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)

July 27, 2022 at 6:15 pm

#4069056

Viewing 15 posts - 3,091 through 3,105 (of 59,067 total)