Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 59,086 total)

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
Reply To: Sql Server security updates on

jayoub wrote:
I have a quick questions
If I installed Cumulative Update 16 for SQL Server 2019 and then installed GDR 16 for SQL Server 2019 - will I be able 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 27, 2022 at 6:13 pm

#4069055
Reply To: Cloud path for beginners
I can't speak for others but relational databases aren't going away. I also love the fact that I don't actually have to write loops in it do to the same...
- This reply was modified 4 years ago by Jeff Moden. Reason: Change "are going away" to "aren't going away". Man, talk about phat phingering
--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:11 pm

#4069054
Reply To: Update variable inside foreach loop

LearnSQL wrote:
Sure I will correct from next by typing the content here and code in code area.
Hi Jeff -I am using third party component which will connect to another third...
--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 5:48 pm

#4069052
Reply To: Update variable inside foreach loop

LearnSQL wrote:
Hi All,
I have a requirement to update set of records to an external environtment which is connected via ADO .net
There are set of records in my table which 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 26, 2022 at 6:49 pm

#4068543
Reply To: SQL and Feature Flag Use in Software Development

I don't know what you mean by "Feature Flag". On the SQL side, knowing that is super important. Databases are the proverbial "Center of the Universe". If you don't think...
--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 26, 2022 at 6:45 pm

#4068541
Reply To: The step was retried the requested number of times (5) without succeeding.

Was the backup it was trying to copy actually finished? If it wasn't, there's your "sharing violation".
If you try to rename a file to what the current name is and...
--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 26, 2022 at 6:28 pm

#4068523

Viewing 15 posts - 3,121 through 3,135 (of 59,086 total)