Jeff Moden

Forum Replies Created

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

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
Reply To: Transfer SQL Table Data into Excel

Why not just create a stored procedure to produce the data and have Excel pull the data on demand? That way, you don't end up creating files for a bazillion...
--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 3:38 pm

#4079773
Reply To: Extended Events: using ATTENTION Event to log external apps timeouts.
VoldemarG wrote:
Jeff, why do you think deadlocks could be an issue?
It was a suggestion based on previous experience that was meant to prompt you into checking for them. That worked. ...
- This reply was modified 3 years, 12 months ago by Jeff Moden.
--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 1:56 am

#4079488
Reply To: Using LAG to return prior non null value

Awesome news about the Substring parameters. And, I've not run it but it looks like your @SmearStart will likely do the trick.
All of that and your previous column additions means...
--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 1:41 am

#4079484
Reply To: calculation for year month and quarter with date dimension table

jeannier175 wrote:
I was able to resolve the issue i just deleted the date filter in the where clause.
Have you taken a look at your execution plan since you've done 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 23, 2022 at 1:37 am

#4079482
Reply To: When Is Technology Good Enough?

daniel_jacob wrote:
But in a general sense, am more frustrated by the drive to add new 'Big' features, rather than perfect what we have.
That's one of my biggest frustrations with Microsoft.
[quote-1...
--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 1:29 am

#4079481
Reply To: Turning Col into Multiple Rows

Have a look at the following article to support such "Dynamic CrossTabs". Use MAX() instead of SUM() like Scott Pletcher did. With the understanding that I have little love for...
--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 22, 2022 at 5:03 pm

#4079377
Reply To: Help with Copying backup files and capture results in output file with details

SQLisAwe5oMe wrote:
Thanks Jeffrey, do you have a link you can refer me to?
It's part of the windows operating system. Just Google it.

--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 22, 2022 at 4:56 pm

#4079347
Reply To: When Is Technology Good Enough?

To be more specific, the "improvements" to TempDB, especially the one that adds TF1117 functionality (grow all files equally) and cannot be disabled even temporarily for TempDB because a bunch...
--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 22, 2022 at 4:52 pm

#4079346
Reply To: Reconcile employees with multiple IDs into Unique IDs

Hopefully, that's true. The last person that told me that was at a company the I worked at temporarily. They told me that AFTER I had already seen that it...
--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 22, 2022 at 3:09 am

#4079103
Reply To: Reconcile employees with multiple IDs into Unique IDs

masterelaichi wrote:
However, every employee has a unique SSN.
For the love of all that is holy in SQL Server, please tell me that your SSNs are NOT in plain, 9 digit...
--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 22, 2022 at 3:01 am

#4079100
Reply To: SQL Query

Ok... no interest from the OP. Unsubscribing.
--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 22, 2022 at 12:58 am

#4079086
Reply To: Using CONTINUE

It's a funny thing how things sometimes work out. I told myself that I'd spend a little time cruising the net after I was done with work today and then...
--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 22, 2022 at 12:53 am

#4079085

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