Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 59,086 total)

Reply To: How many days of data do I have in the table?

VoldemarG wrote:
Neither answer will work, because on one date there may be 1000 records and five on another, etc. The datetime value is different up to milliseconds for each row. ...
--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 22, 2022 at 7:21 pm

#4090926
Reply To: Tsql batch script does not stop
Maybe this ...
```
AND TMP.IFSC <> '' OR TMP.IFSC IS NULL
```
... should be this ...
```
AND (TMP.IFSC <> '' OR TMP.IFSC IS NULL)
```
???
--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 22, 2022 at 1:30 am

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

jcelko212 32090 wrote:
I disagree. DATE, TIME and DATATIME2 match to the ANSI/ISO Standards. I do not have to play with PDP/11 clock ticks to fake a date, the temporal math is...
--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 10:10 pm

#4090525
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

Viewing 15 posts - 2,716 through 2,730 (of 59,086 total)