Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 59,091 total)

Reply To: Need help with generating random pass for 100s of certificates

Why not just generate GUIDs? With the dashes, they're 36 bytes in length when converted to CHAR. Without the dashes, they're 32.
--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)

January 7, 2020 at 3:11 pm

#3713215
Reply To: Validating meta data of xls file

Charmer wrote:
Finally, issue is fixed which was a silly and it's done. 🙂
OK, so what was the "silly" fix you employed?
I'll also state that it's a shame that you're resorting...
--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)

January 7, 2020 at 2:55 pm

#3713203
Reply To: Not an 8 to 5 employee

Sharpen up your resume, find a trustworthy "jobber" type of recruiter (they'll want to interview you to ensure you're worth your salt in SQL and/or DataAnalysis), and then let them...
--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)

January 7, 2020 at 4:30 am

#3713040
Reply To: Validating meta data of xls file

Charmer wrote:
Hi Team,
We get xls file every day with so many sheets in it. I need to validate only the sheet named with current year. In this case, it 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)

January 7, 2020 at 3:39 am

#3713036
Reply To: BCP
IMary wrote:
Hi,
I have below requirement. Please advise how to achieve that with BCP or any other tool
1. Have Table A with 5 million records
--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)
January 7, 2020 at 2:49 am

#3713025
Reply To: Learn to Change

Steve Jones - SSC Editor wrote:
Change is change. Whether its better or not is something we have to evaluate, test, experiment with, and decide. I worry about people getting caught up in thinking we...
--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)

January 7, 2020 at 2:30 am

#3713024
Reply To: Fifi Calculation

jcelko212 32090 wrote:
And I also recommend normalizing databases ..Wow! Seriously, I do not like using a data model that is hundreds of years old and based on Roman numerals. O probably...
--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)

January 7, 2020 at 1:27 am

#3713018
Reply To: func_GetInvoiceNumberByDocumentNumber

Consider the following article while you're at it. 😉
https://www.sqlservercentral.com/editorials/the-art-of-commenting
--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)

January 6, 2020 at 3:57 pm

#3712702
Reply To: Dmvs to show missing indexes

To Grant's point, I wouldn't even call them "suggestions". They're a "clue" that some code somewhere might (strong emphasis in "might") benefit from an index. I don't know about lately...
--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)

January 6, 2020 at 3:41 pm

#3712695
Reply To: Are the posted questions getting worse?

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone 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)

January 6, 2020 at 3:24 pm

#3712674
Reply To: difference between numeric and decimal

samirca007 wrote:
Hello, beginner in Tsql
I need help: here in one of the tables that I use, one of the fields is declared in decimal (10.5).
I understand that the field 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)

January 6, 2020 at 3:16 pm

#3712673
Reply To: SQL server License

I'm thinking that you're going to need to do a reinstall but I'm not sure. Your best bet would be to contact MS on this problem.
--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)

January 6, 2020 at 3:07 pm

#3712670
Reply To: CHOOSing a value

Saurabh.D wrote:
Very useful function for "Status" column.
thanks Nakul Vachhrajani for return type testing.
I would think that an actual join with a lookup table would be better so that you don't...
--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)

January 6, 2020 at 3:02 pm

#3712668
Reply To: Fifi Calculation
jsshivalik wrote:
Hi
I have below Data and i want Balance Invoices on accoun of Fifo .
In case of C00220 it should return 54575 entry
In case of C00575 it should return 1593...
- This reply was modified 6 years, 8 months ago by Jeff Moden. Reason: Comment about possible misread of the OP
--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)
January 6, 2020 at 2:44 pm

#3712659
Reply To: Quick Security Mistakes

I love the "Conclusion" in the PDF I came across on the subject. Basically, they pat themselves on the back for doing a good job of recovery (which took several...
--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)

January 6, 2020 at 1:24 am

#3712512

Viewing 15 posts - 7,966 through 7,980 (of 59,091 total)