Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,971 through 5,985 (of 59,089 total)

Reply To: Inflow / outflow report per day

This problem is an interesting problem and so I built two tables each containing more than 102 Million rows spread across 5 years (60 months) with each month containing more...
--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)

December 5, 2020 at 3:30 pm

#3817293
Reply To: Inflow / outflow report per day

milo1981 wrote:
I don't have the column 'Cashflow' in may tables, is what I want to calculate. As ScottPletcher said, I need a running total.
So tell me where in pietlinden's script...
--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)

December 4, 2020 at 4:56 pm

#3817002
Reply To: conversion of excel formula to case statement in tsql

Abhas wrote:
Hi all,
need your help on conversion of excel formula into case statement. i tried but missing only one case. below is excel formula:
=IF(AND(Q141="EndOfDay", AD141="EndOfDay",V141=""),8, MIN(8, IF(OR(Q141="EndOfDay"), 0, IF( 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)

December 4, 2020 at 4:51 pm

#3817001
Reply To: Index Column Order – Be Happy!

The link for Jonathan's script, once you find it on SQLSkills, is broken. Do you have another source for the script that makes the two sales tables larger?
--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)

December 4, 2020 at 4:44 am

#3816797
Reply To: Configure Replication Between an On-premises SQL Server and AWS RDS

Jonathan1453 wrote:
Yeah, I later resolved it using the hosts file following a tutorial I found on another website.
Thanks for the concern.
Can you post the link, please?
--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)

December 4, 2020 at 12:30 am

#3816760
Reply To: Ordering with NULL

jcelko212 32090 wrote:
The ANSI/ISO standards specify an extra clause that goes after the order of the sort (ASC | DESC) which will let you decide the order of the nulls within...
--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)

December 4, 2020 at 12:17 am

#3816759
Reply To: Error

ramyours2003 wrote:
we are not sure the query as it is getting my tool , may i know what are the reasons of getting this error and any idea to resolve...
--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)

December 3, 2020 at 6:39 pm

#3816651
Reply To: How can I exclude records from this table?

Based on my previous misgivings about the problem definition, here's one that returns "Appointments" that are returned if they immediately precede or are followed by a "Discharge". It returns all...
--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)

December 3, 2020 at 6:28 pm

#3816637
Reply To: How can I exclude records from this table?
I may be getting this wrong... This only finds the last appointment before a discharge and all discharges. Please mark your sample data for what is expected in the return...
- This reply was modified 5 years, 8 months ago by Jeff Moden. Reason: Added "PARTITION BY MTMRN" to handle more than one MTMRN
- This reply was modified 5 years, 8 months ago by Jeff Moden. Reason: Ask for clarification on the requirements
--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)
December 3, 2020 at 5:53 pm

#3816597
Reply To: Inflow / outflow report per day

You should at least post what the datatype are for the columns. You'll also find that most people want to see what you've tried in the form of code. We're...
--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)

December 3, 2020 at 5:28 pm

#3816581
Reply To: Bulk Insert - An unexpected end of file was encountered in the data file.

I'm not a PowerShell affection ado but it seems like the script at the following URL would be of help rather than using Option #2 above. I recommend making a...
--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)

December 3, 2020 at 5:18 pm

#3816580
Reply To: Ordering with NULL

At first, I thought this was more of a "did you actually read the code question" than anything else. I no longer think that because at least one person said...
--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)

December 3, 2020 at 4:32 am

#3816345
Reply To: Bulk Insert - An unexpected end of file was encountered in the data file.

Check the resulting table. You may find that all but that last row has been bulk loaded. Both BCP and BULK INSERT default to allowing up to 10 errors without...
--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)

December 3, 2020 at 4:14 am

#3816341
Reply To: How to mantain index in SQL and size of Database

andre1992 wrote:
The heaviest clustered index is around 8 Gb while the database weighs 17 Gb.
Thanks Jeff.
I should have asked the same question that Michael asked about total disk size 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)

December 3, 2020 at 3:56 am

#3816339
Reply To: How to mantain index in SQL and size of Database

Evgeny Garaev wrote:
I use this index maintenance solution - https://ola.hallengren.com/.
That's nice but it won't help solve the problem the OP posted. Also, while OLA's good scripts are the "gold standard"...
--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)

December 2, 2020 at 10:07 pm

#3816258

Viewing 15 posts - 5,971 through 5,985 (of 59,089 total)