Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 59,101 total)

Reply To: GoTo Looping

David.Poole wrote:
Thank God there's no GOSUB in SQL.
There's a school of thought that gets sniffy at overuse of if statements in OO languages.
Such constructs feel like a vestigal organ like...
--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 20, 2021 at 12:26 am

#3911877
Reply To: Calculate # days between TODAY and a DATETIME column value

Express12 wrote:
thx for the quick replies.. My table has several thousand rows, so I cannot hard code dates as list in the example above. This SQL gets me kind of...
--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 19, 2021 at 11:28 pm

#3911875
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

Steve Jones - SSC Editor wrote:
I completely understand poorly formatted CSVs or varying structures, like ragged right, causing issues.
These were simple, consistently formatted files. I can't believe this was hard.
No they weren't... at least...
--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 19, 2021 at 7:28 pm

#3911780
Reply To: GoTo Looping

Joe Bonomo wrote:
@JeffModen,
Thanks for the detailed response. Agreed, could have made this example more performant following some of the guidance you mention.
Regarding why there is no index, the row set in...
--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 19, 2021 at 7:20 pm

#3911778
Reply To: GoTo Looping

I agree that you sometimes need to do the loop in one of it's many forms. I have no qualms and fairly minor shivers from things like that. 😀
However... your...
--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 19, 2021 at 3:17 am

#3911518
Reply To: Load folder full of csv files

Thanks for the feedback, Bruin...
Heh... you DO have to pay attention to the resolution of the data. 😀
--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 19, 2021 at 2:29 am

#3911512
Reply To: Load folder full of csv files
Probably not the operating system. Have you checked the files in the two different places for things like...
1. Are the both using the same thing when it comes to Unicode...
--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 17, 2021 at 2:15 pm

#3911213
Reply To: How can I check that SP3 is really installed?

Mr. Brian Gale wrote:
Did you click on the text 'Failed"? That should explain what is wrong.
If I had to guess - you have a 64-bit version of SQL Server installed and are...
--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, 2021 at 12:25 am

#3910460
Reply To: How can I check that SP3 is really installed?

eager2learn wrote:
The result of the query SELECT @@VERSION is: "Microsoft SQL Server 2014 - 12.0.2269.0 (X64)"
I don't understand that (X64) because this query is executed in: C:\Program Files (x86)\Microsoft SQL...
--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, 2021 at 12:23 am

#3910459
Reply To: Load folder full of csv files

Bruin wrote:
@jeff
Had a strange error processing file from server...
It was the first file that had data...
StartDT: 15 Jul 2021 08:44:42:777 Working on file 25 of 89 files: G:\line_speed\F303-Line10.csv... Msg 2627,...
--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, 2021 at 12:14 am

#3910457
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

Dawesi wrote:
Jeff Moden wrote:
On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as...
--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 15, 2021 at 10:15 pm

#3910423
Reply To: How to get total only for today's date for some columns in reslut set
gaurav wrote:
```
 FROM tblRecievedQuantity TRQLEFT JOIN tblOrderQuantity AS TOQ ON TOQ.order_id = TRQ.order_idLEFT JOIN tblIssuedQuantity AS TIQ ON TOQ.order_id = TIQ.order_idLEFT JOIN tblReceivedTrack AS TRT ON TOQ.order_id...
```
--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 15, 2021 at 10:12 pm

#3910422
Reply To: Using an Integer parameter in a WHERE clause

Actually, both OR and ISNULL are horrible for performance and should be avoided... when I say "should be avoided", I'm very close to saying "must be avoided at all costs"...
--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 15, 2021 at 3:12 am

#3908094
Reply To: ETL in 2021 ?

My previous experience with SSIS was to determine a method to make table-to-table transfers like this work much more quickly. The way I did that was I stopped using SSIS...
--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 15, 2021 at 1:51 am

#3908069
Reply To: Comparing every row in one table

Now that you have a couple of answers, I have to ask... why do you need to do this? What will it be used for? What business purpose does 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)

July 15, 2021 at 1:49 am

#3908068

Viewing 15 posts - 4,951 through 4,965 (of 59,101 total)