Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,371 through 8,385 (of 59,098 total)

Reply To: I am new to SQL world

Kabina wrote:
can we use procedure in our query to retrieve data ?
Yes. Contrary to popular belief, you CAN call a stored procedure in a SELECT query using things 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)

November 18, 2019 at 1:59 pm

#3698504
Reply To: Integer convert to varchar but keep a lenth

sterling3721 wrote:
thank you for the data. Theoretically, it's slower; based on my software development experience, web application does not fetch 1,000,000 or even 10,000 rows to the front end. 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)

November 18, 2019 at 1:44 pm

#3698502
Reply To: Round at specific decimal point

I wonder why people think that everything that uses SQL uses the same 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)

November 18, 2019 at 6:02 am

#3698421
Reply To: Help with determining formulas/processes for solving a problem?

Interesting... what constitutes a lower cost provider? In other words, why would they possibly be a lower cost on one route but not another? I might see a difference depending...
--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)

November 18, 2019 at 5:59 am

#3698420
Reply To: Collections

I have to admit that this is a very interesting exercise but I'm not seeing anything especially practical here, especially if thousands of integers were needed in a collection.
Considering 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)

November 18, 2019 at 5:31 am

#3698418
Reply To: Learn from the Troubles of Others
I think it's freakin' hilarious when I see Microsoft Engineers write code like the following...
```
SELECT  getdate() 'runtime', ...
```
It doesn't hurt anything but wow...
--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)
November 18, 2019 at 5:08 am

#3698416
Reply To: Integer convert to varchar but keep a lenth

In the same vein as Jonathan, I like to test these type of things out. I do like to take an average of 5 runs. This is on my new...
--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)

November 18, 2019 at 4:41 am

#3698414
Reply To: Get month days

I know this post is serveral years old now but wanted to say nice post on the following... definitely the right idea.
kaj wrote:
Igor,
I really think you're overcomplicating it. From my...
--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)

November 17, 2019 at 8:58 pm

#3698364
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

SGT_squeequal wrote:
Fantastic article, do you have any links to using the % to return value. never seen the use of % like this (T.N-1)%3 +1
Thank you for the feedback... much...
--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)

November 16, 2019 at 10:19 pm

#3698303
Reply To: Identity column as Primary Key - good or bad?

jcelko212 32090 wrote:
I always follow ANSI/ISO standards, the metadata committee standards, and basic data modeling principles.
BWAAAA-HAAAA-HAAAAA!!!! THIS coming from the person that says he likes the MySQL "standard" of using YYYY-00-00...
--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)

November 16, 2019 at 3:03 pm

#3698272
Reply To: Diskallignment questions ?

It is an alleged non-problem any more. I say "alleged" because I trust no one on such things (too many times burnt in the past). There is a simple test...
--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)

November 16, 2019 at 2:43 pm

#3698271
Reply To: One table or two?

below86 wrote:
I'll be using this data to add entries to our data warehouse tables. After using this data to fill in our data warehouse tables most of the time 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)

November 15, 2019 at 3:12 pm

#3698069
Reply To: Using Java script to import word and pdf into SQL server

pcq0125 wrote:
Thanks for your response. The purpose of the word document import into SQL server is to parse the data into a table and export into excel. The current framework...
--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)

November 15, 2019 at 2:54 pm

#3698062
Reply To: Agile Job Descriptions

I got hired and then I wrote the job description. 😉
--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)

November 15, 2019 at 5:18 am

#3697936
Reply To: Any SQL developer volunteers needed?

To add to both what I and Jonathan suggested that will help a whole lot, both for the reader and the self-edification of the author, always remember this simple rule...
--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)

November 14, 2019 at 4:18 pm

#3697717

Viewing 15 posts - 8,371 through 8,385 (of 59,098 total)