Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,766 through 6,780 (of 59,072 total)

Reply To: Cursors, i completed a group by query with help and sent it along to requestor..

Steve Collins wrote:
Jeff Moden wrote:
Nah... it's easier than that. Create a stored procedure that does the work, give the spreadsheet user privs to execute it, and have them execute the stored procedure...
--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 16, 2020 at 2:28 pm

#3770545
Reply To: more effecient query

Erased my post... I found an exception to the code I was going to post.
--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 16, 2020 at 6:46 am

#3770463
Reply To: Trying to Make combinations in SQL

This is a triplicated post and multiple solutions have been provided. Please... no posts here. Instead, see the following post where all the other answers are...
https://www.sqlservercentral.com/forums/topic/trying-to-make-combinations-within-a-bracket-in-ssms-column

--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 16, 2020 at 6:39 am

#3770461
Reply To: The transaction log for database 'mydb' is full due to 'LOG_BACKUP'

sqlfriend wrote:
Thanks, this is ECM Opentext software database server, I did not manage it until today I found the alerts. Asked their team they said some contractors are loading some...
--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 16, 2020 at 6:36 am

#3770460
Reply To: Cursor within sql query

p.s. SQL <> SQL so always identify which RDBMS engine you're using.
--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 16, 2020 at 6:30 am

#3770455
Reply To: Cursors, i completed a group by query with help and sent it along to requestor..

Nah... it's easier than that. Create a stored procedure that does the work, give the spreadsheet user privs to execute it, and have them execute the stored procedure from their...
--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 16, 2020 at 6:28 am

#3770454
Reply To: Trying to Make combinations within a bracket in SSMS column
Mr. Brian Gale wrote:
My recommendation is to do this application side still, but if database side is the solution you need, this query should do it:
```
DECLARE @tmp TABLE
(
[Letters] VARCHAR(25)
);
INSERT...
```
--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 16, 2020 at 6:22 am

#3770453
Reply To: Trying to Make combinations within a bracket in SSMS column

Shifting gears a bit, please read the first link in my signature line below for how to post example data in future posts to help us help you faster 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 16, 2020 at 6:16 am

#3770452
Reply To: Trying to Make combinations within a bracket in SSMS column
Just to throw my hat into the ring, here's my humble version... It uses the fnTally function that Steve posted.
First, here's the test data I used...
```
DROP TABLE...
```
--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 16, 2020 at 6:06 am

#3770451
Reply To: Trying to Make combinations within a bracket in SSMS column

riddhi10 wrote:
I am denied the permission to create the function here
Submit the fnTally function to the resident DBA for review and deployment. Be sure to include the header so they...
--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 16, 2020 at 4:48 am

#3770445
Reply To: Trying to Make combinations within a bracket in SSMS column

riddhi10 wrote:
What application would you suggest using for this, If i were to run row operations on the application side?
None. As you've seen by Phil's and Steve's solutions, T-SQL solutions...
--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 16, 2020 at 4:30 am

#3770443
Reply To: Carefully Giving Normal Users Security Permissions

This is what I use stored procedures for. The store procedures are each crafted to do one an only one thing, to do it well, and to do it with...
--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 16, 2020 at 4:02 am

#3770439
Reply To: Returning data from table based on date ranges

Ah... understood on the offsets. Thanks, Jeff.
--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 14, 2020 at 1:57 am

#3769616
Reply To: Returning data from table based on date ranges
@Jeffrey Williams...
I think you're on the right track but...
1. Due to your hard-coded offsets for the start of each quarter, what's going to happen on a Leap Year?
2. Although probably...
--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 13, 2020 at 11:57 pm

#3769598
Reply To: What do you like for third party database backup/restore for SQL server & Azure

To be honest, I've tried several and I prefer the homegrown native backup methods.
--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 13, 2020 at 10:10 pm

#3769578

Viewing 15 posts - 6,766 through 6,780 (of 59,072 total)