Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 59,098 total)

Reply To: Getting the rolling weekly average based on the preceding 12 months

jcelko212 32090 wrote:
I think you need to start over. Google why we never use MONEY. Normalize this mess. neither table has a key at all. A calendar has an obvious key...
--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 21, 2022 at 8:13 pm

#4090488
Reply To: Selecting State from table based on a Begin and End Date

jcelko212 32090 wrote:
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/state-transition-constraints/
We have DATE data types, souse them and not the old Sybase datetime from UNIX. Does the status have to be contained in the temporal interval, or can 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 21, 2022 at 6:21 pm

#4090437
Reply To: Quick License question - Urgent

Won't the application still work if you install 2017 and simply set the compatibility level to 2016?
--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 21, 2022 at 6:14 pm

#4090435
Reply To: select rows with same id and some other value in another column for that id

DesNorton wrote:
wrote:
That is battling. I was stunned by your affiliation. I'm happy to see a particularly subject. Altruisticly go to my blog and read it.
Spam incoming .....
Someone is running...
--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 21, 2022 at 5:05 am

#4090148
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

Thomas Franz wrote:
@Eirikur: of course it is possible to do the calculation with bit shifting, reversing, converting to binary etc., but WHY? Just because it is possible and makes some old...
--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 20, 2022 at 11:21 pm

#4090081
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

Eirikur Eiriksson wrote:
Good point Jeff, never used the functions for negative timestamps...
Unfortunately and as identified in point #2 of the Prolog of the article...
2. Many solutions don’t account for negative...
--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 20, 2022 at 10:13 pm

#4090055
Reply To: T-SQL Language Changes in SQL Server 2022

Jeff Moden wrote:
paul.hermeneutic wrote:
Jeff Moden wrote:
paul.hermeneutic wrote:
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for 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)

September 20, 2022 at 10:03 pm

#4090054
Reply To: Need some expert help from the masters

@igaytwanb,
With so little claimed knowledge on your part, I'm going to direct you to a tool that has help many both with and without experience. It's not a magic fix......
--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 20, 2022 at 8:46 pm

#4090020
Reply To: Need some expert help from the masters

igaytwanb wrote:
Hello everyone!
I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the company 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)

September 20, 2022 at 2:34 pm

#4089855
Reply To: How to export 20 milion rows to only one file ?

ahmed_elbarbary.2010 wrote:
I work on sql server 2019 i have table have 20 milion rows .
i need to export data Exist on table to only one file by using sql server...
--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 20, 2022 at 2:05 pm

#4089841
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

Just a few more tests on the function you posted. Haven't done a deep dive on your code but, at first blush, it would appear that it doesn't like working...
--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 20, 2022 at 1:53 pm

#4089817
Reply To: script to find all jobs that invokes xp_cmdshell and the step scheduled time

lan2022nguyen wrote:
i found a script. this can be close
You do realize that's not going to find any job that executes a stored procedure that executes xp_CmdShell, correct?
This sounds a bit...
--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 20, 2022 at 1:23 am

#4089598
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
Thank you for the kind feedback and the functions, Eirikur.
Perhaps I'm using the function incorrectly but try the following (and, if so, please let me know)...
```
 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)
September 19, 2022 at 11:22 pm

#4089586
Reply To: Find replace using regular expressions

wrote:
Jonathan AC Roberts wrote:
I would use an SSMS add-in like ApexSQL Refactor.
There is a free version of it here https://en.free downloadmanager.org/Windows-PC/ApexSQL-Refactor-FREE.html
I think you only get a trial period 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)

September 19, 2022 at 2:54 am

#4089168
Reply To: how to remove schemabinding from all functions and view in one go.

Jason A. Long wrote:
Jeff Moden wrote:
2. That kinda makes me want to build a query that recursively uses sys.sql_expression_dependencies joined sys.sql_modules to find all schema binding objects that are binding an object 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 19, 2022 at 2:38 am

#4089165

Viewing 15 posts - 2,731 through 2,745 (of 59,098 total)