Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,196 through 6,210 (of 59,089 total)

Reply To: Need help to form query to get missing month data

jcelko212 32090 wrote:
>>But you display only vague dates not associated with any year. I'm going to make a suggestion that you use the MySQL convention four months. It is based on...
--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)

October 26, 2020 at 8:47 pm

#3801476
Reply To: Need help to form query to get missing month data

anuxps wrote:
I want to know what are the customers having missing month data based on the following data pattern. My data is present in table in below format. Please help...
--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)

October 26, 2020 at 8:24 pm

#3801464
Reply To: ROWLOCK UPDLOCK - Locks whole table

Why do you think you need the locking hints at all?
Like Paul White said in the thread referenced by Brian...
As documented in Books Online, UPDLOCK takes update locks and holds...
--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)

October 26, 2020 at 7:49 pm

#3801460
Reply To: Index scan

People don't understand that a CTE is NOT executed first and then the rest of the query works against that as if it were a table with the possible exception...
--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)

October 26, 2020 at 7:42 pm

#3801458
Reply To: Having trouble with a BCP statement

frederico_fonseca wrote:
itmasterw 60042 wrote:
@jeff - Server is optional - if not supplied it run on the local machine where bcp is executed and connects to its default instance.
But doing this 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)

October 26, 2020 at 2:12 pm

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

Heh... some would say that you got "Lucky", Lynn. I would say that it's where years of preparation and hard work have finally met a good opportunity (my definition 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)

October 26, 2020 at 2:06 pm

#3801319
Reply To: A Strange Comparison

Bob Razumich wrote:
Wolfram Kraus wrote:
What is the difference between the second and the third answer?
Well, nothing reading the text for both answers. The fact that both answers were used is probably interesting...
--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)

October 26, 2020 at 2:00 pm

#3801315
Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
Okay, I felt this would be more efficient and extensible ti done in SQL server, and I guess I thought it would be easier, but thanks I will do...
--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)

October 26, 2020 at 1:56 pm

#3801311
Reply To: How to get these description from XML into the table?
DesNorton wrote:
You can take this further and split the rows into columns like this
```
DECLARE @XMLData xml;

SET @XMLData = '<PlaceDescriptions>
<descriptions>0|Home</descriptions>
<descriptions>1|Office|False</descriptions>
<descriptions>2|Play Ground</descriptions>
<descriptions>3|School|True</descriptions>
<descriptions>4|Movie Hall</descriptions>
</PlaceDescriptions>';

WITH cteXML AS (
  SELECT ...
```
--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)
October 26, 2020 at 2:38 am

#3801113
Reply To: How to reduce physical size of database

Jeffrey Williams wrote:
Cebisa wrote:
You deleted,/truncated a large amount of data, your database physical size does not autoshrink. Many suggest pre growing your data files. If you are certain that your database...
--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)

October 26, 2020 at 2:24 am

#3801103
Reply To: A Strange Comparison

Heh... you're such a "NOTty" boy! 😀 I haven't seen syntax like that in a very long time. Lot's of bloody != but incredibly little !< 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)

October 26, 2020 at 2:14 am

#3801102
Reply To: SQL Server Phone Home

Sorry. I don't care if I'm not the actual owner of their software even if I've bought a license for it... they need to make turning such monitoring off 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)

October 26, 2020 at 2:01 am

#3801101
Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
I am running it in the edit window. I have done BCP here before but it was a long time ago. Do I need to rewrite this or some...
--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)

October 26, 2020 at 1:40 am

#3801099
Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
I am running it in SSMS. the site I got this form seems to be doing it here, but I could be wrong.
If you're running the command from an...
--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)

October 25, 2020 at 6:43 pm

#3801040
Reply To: Having trouble with a BCP statement

PhilPacha wrote:
The double quote at the end of the SQL query ism't matched by a double quote at the beginning of the query. It isn't needed, anyway.
Actually, it is matched. ...
--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)

October 25, 2020 at 6:41 pm

#3801038

Viewing 15 posts - 6,196 through 6,210 (of 59,089 total)