Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,316 through 6,330 (of 59,089 total)

Reply To: I passed the Microsoft Exam 98-364: Database Fundamentals

Congratulations, Michael! Well deserved. You really did put your shoulder to the wheel from what I've seen of your posts on this forum.
--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)

September 30, 2020 at 8:19 pm

#3792092
Reply To: 'sa' impersonation

SZ wrote:
Would WITH EXECUTE AS OWNER make any difference ???
or
Can I just add this stored procedure to the list of securables their role can execute ?
Would not then this 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)

September 30, 2020 at 7:55 pm

#3792080
Reply To: Add a Time column and a Date column together?

jcelko212 32090 wrote:
DATE and TIME are available data types that can be combined into the newer DATETIME2(n) data type. Just use the CAST() function and simple math. The use of an...
--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)

September 30, 2020 at 5:06 pm

#3792034
Reply To: Add a Time column and a Date column together?

rkelly58 wrote:
Hi Jeff,
Here is the result of your code:
Date ...
--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)

September 30, 2020 at 4:58 pm

#3792017
Reply To: How to use PIPES in T-SQL to bring two number based on user entry

Heh... "The OP has left the building". 😀
--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)

September 30, 2020 at 4:49 pm

#3792015
Reply To: trigger on a Large 5 billion row table

Siten0308 wrote:
Hello,
So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been...
--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)

September 30, 2020 at 4:12 pm

#3792010
Reply To: 'sa' impersonation

SZ wrote:
To give a user the ability to execute a stored procedure (EXECUTE AS) I must first grant him the ability to impersonate the 'sa'.
(that procedure creates new login 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)

September 30, 2020 at 4:06 pm

#3792008
Reply To: Add a Time column and a Date column together?
Sorry about the previous post... I had an extra "60" in it instead of a 100.
Anyway, using the integer math suggestion and the test table setup that Phil posted along...
- This reply was modified 5 years, 11 months ago by Jeff Moden. Reason: Made fix to change "ss" to "mi" in the code
--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)
September 30, 2020 at 3:59 pm

#3792003
Reply To: Add a Time column and a Date column together?

Sorry... Dropped the post... I'll be back...
--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)

September 30, 2020 at 3:39 pm

#3791994
Reply To: In search of Database scripts version control strategy or process

Do you have a DBA review process that occurs sometime before testing? I can't speak for anyone else and probably have a different experience but, unless you have a DBA...
--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)

September 29, 2020 at 6:58 pm

#3791745
Reply To: Auto generate AlphaNumeric with defined letters and numbers (e.g. A1-A6)
Sergiy wrote:
All you need is to convert normal numerical sequence to desired codes.
Something like this:
```
declare @a tinyint, @b tinyint, @t smallint 
select @a = 6, @b =...
```
--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)
September 29, 2020 at 3:08 pm

#3791673
Reply To: Tempdb version store related question

I don't even know how to spell "read_committed_snapshot" but we recently had a 3rd party vendor create a database that uses it and your problem does have a concern 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)

September 29, 2020 at 2:10 pm

#3791645
Reply To: Auto generate AlphaNumeric with defined letters and numbers (e.g. A1-A6)

What is the max? Z6? I ask because that will mean that you have a total capacity of 26*6 or 156 unique values before you run out.
--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)

September 29, 2020 at 2:04 pm

#3791643
Reply To: showing result of query in Pivot table

If you'd provide your example data in a "Readily Consumable Format" (please see the article at the first link in my signature line below for one way to do 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)

September 29, 2020 at 2:00 pm

#3791634

Reply To: convert scalar function to table valued function

tanehome wrote:

FINALLY IT WORKS 🙂

the issue was in how to call the function not in the mentioned above modified function

it works fine when i used this to call 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)

September 29, 2020 at 1:46 pm

#3791631

Viewing 15 posts - 6,316 through 6,330 (of 59,089 total)