Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 59,098 total)

Reply To: Create week numbers starting from Monday to Sunday

Nomvula wrote:
I need to create a query where the first of March will be Week 1 starting from Monday to Sunday from the date. If the first of the month...
--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)

August 25, 2022 at 6:54 pm

#4080634
Reply To: SSMS access and code formatting

In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...
"Oops". 😀
--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)

August 25, 2022 at 4:47 pm

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

I know... I'm weird... I couldn't stop laughing as I read the following article about AI and on-prem. I mean who knew that computationally intense processes on the cloud might...
--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)

August 25, 2022 at 4:42 pm

#4080591
Reply To: Execution plan help

The Seek is probably a Seek followed by a range scan of the full table, which probably has little if any advantage over the scan. I only use the Execution...
--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)

August 25, 2022 at 2:26 am

#4080330
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Martin, your solution worked.
Thanks,
So I can learn a bit, which one of Martin's replies does that cover?
--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)

August 25, 2022 at 2:02 am

#4080327
Reply To: SSMS access and code formatting

On the formatting thing, you could try a free website such as PoorSQL.com with the understanding that there is no support if something goes awry. There are other sites 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)

August 24, 2022 at 7:28 pm

#4080274
Reply To: how to remove 18 milion bookid from table without using delete ?are there are an

And, no... I wouldn't do a delete in batches. You end up blowing out the log file even with that and you end up with no temporary backup if something...
--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)

August 24, 2022 at 7:15 pm

#4080273
Reply To: how to remove 18 milion bookid from table without using delete ?are there are an

I just want to make sure we get this right. You're saying that you want to eliminate all book details for books that DO exist in the books table?
I just...
--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)

August 24, 2022 at 7:14 pm

#4080272
Reply To: How to get records for the first 15 days of the month

Smash125 wrote:
How to get records for the first 15 days of the month. please suggest
WHERE OrderDate<=DATEADD(day, 15, GetDate())
Phil's code works perfectly if you can guarantee that the OrderDate column does...
--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)

August 24, 2022 at 6:20 pm

#4080242
Reply To: MS Visual Basic OR MS Visual C# ??

Jobs90312 wrote:
For now my goal is to fix my SSIS projects which are not giving the desired result.
I have no quantitative numbers on what I'm about to say but... I've...
--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)

August 24, 2022 at 5:29 pm

#4080235
Reply To: How to get records for the first 15 days of the month
MarkP wrote:
To get the Orders where the OrderDate is in the first 15 days of a month:
WHERE DAY(OrderDate) <=15
MarkP wrote:
Ant-Green wrote:
MarkP wrote:
To get the Orders where 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)
August 24, 2022 at 5:17 pm

#4080232
Reply To: SSMS access and code formatting

Also, check with the other Developers in the company. You should be checking your code into some form of source control. They should also have a "onboarding" process that lets...
--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)

August 24, 2022 at 5:01 pm

#4080222
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Jeff, format date is not the issue.
If you are willing to waste your time, do it on the real problem, the variable is the issue.
DECLARE @todays AS VARCHAR(20) SELECT...
--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)

August 24, 2022 at 2:55 am

#4079940
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Hi, this is what I am trying to do,
DECLARE @todays AS VARCHAR(20) SELECT @todays = format(cast(getdate() as date),'yyyyMMdd')
EXEC xp_cmdshell 'copy C:\Test\@todays\ *.* C:\Newtest\';
But, I can figure out the syntax...
--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)

August 23, 2022 at 8:09 pm

#4079871
Reply To: SQL convert Rows to columns

wburke 85918 wrote:
Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if...
--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)

August 23, 2022 at 8:04 pm

#4079870

Viewing 15 posts - 2,926 through 2,940 (of 59,098 total)