Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 59,098 total)

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, 1 months 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
Reply To: Implicit conversion of varchar value to varchar cannot be performed

carlton 84646 wrote:
I just figured out what line I was getting the error on:
Msg 468, Level 16, State 9, Line 244 Cannot resolve the collation conflict between "Latin1_General_100_BIN2_UTF8" and "SQL_Latin1_General_CP1_CI_AS" 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 26, 2022 at 6:23 pm

#4068520
Reply To: How to give unique number to every different group of numbers ?

I agree... that's a great simplification. But it doesn't return all the rows with the unique number.
--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 3:12 pm

#4068429
Reply To: Implicit conversion of varchar value to varchar cannot be performed

carlton 84646 wrote:
I tried this but I got the following err
FUNCTION 'OBJECT_SCHEMA_NAME' is not supported.
You basically said that you were using "Synapse SQL Serverless Pool". There are a lot of things...
--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 3:04 pm

#4068427

Viewing 15 posts - 3,136 through 3,150 (of 59,098 total)