Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,746 through 2,760 (of 59,067 total)

Reply To: world map and errors loading map for VS 2022

Jason Wilks wrote:
Jeff,
oh sorry I mistakenly took that link out when I edited it for the error message. Which makes this thread no longer makes sense. And I should have created...
--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)

September 13, 2022 at 5:13 pm

#4087211
Reply To: world map and errors loading map for VS 2022

Jason Wilks wrote:
[Updated 9/6/22]
What is the easiest way to get a world map into the map gallery so that I can embed into my report?
Also, Using Visual Studio 2022. Any map...
--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)

September 13, 2022 at 3:16 pm

#4087157
Reply To: Waits on temp db

astrid 69000 wrote:
Thanks to everyone but the input.
No new code, nor report was released. I also don't get any blocks.
We found yesterday that we had we had the tempdb and 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)

September 13, 2022 at 3:10 pm

#4087152
Reply To: Waits on temp db

astrid 69000 wrote:
Hello,
I would like some input and ideas on my issue.
I have two virtual servers. Prod and Test.
A couple of weeks ago, out of the blue without any deployment 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)

September 12, 2022 at 10:22 pm

#4086831
Reply To: get column names and values in each row in SQL Server

dhanekulakalyan wrote:
The Answer is that is how our vendor asked us to send our weekly files going forward. I think they are using SAS programming and their system accepts 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)

September 12, 2022 at 9:54 pm

#4086824
Reply To: Pivot columns to get 0 /1 flag columns

Jeffrey Williams wrote:
...but you actually get a mix of DMY and MDY the insert will fail. If you use TRY_CONVERT however, the insert will be successful and those values that cannot...
--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)

September 12, 2022 at 9:53 pm

#4086823
Reply To: query take long time when execute it so how to solve issue ?

The "pre-aggreation" I spoke of earlier is identical to what you're suggesting. I'm just trying to get the OP to provide some extra information.
I'll also tell you there is no...
--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)

September 12, 2022 at 5:26 pm

#4086753
Reply To: query take long time when execute it so how to solve issue ?

In a very real "get real" moment, I have to ask... how many times per day will this be used and how often will the underlying data be modified.
What I'm...
--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)

September 12, 2022 at 1:00 am

#4086446
Reply To: query take long time when execute it so how to solve issue ?

In the ExtractReports.dbo.TechnologyPlPartsFeaturValuesOrg table, what does the FeatureValue column contain in reference to the PartId? Also, is FeatureValue a unique value by FeatureID or does it change with each part...
--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)

September 12, 2022 at 12:50 am

#4086445
Reply To: Pivot columns to get 0 /1 flag columns

To get the nice-warm-fuzzies on that, though, start a new session and run the following code... It should run just fine in the new session where you haven't set 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)

September 11, 2022 at 10:58 pm

#4086432
Reply To: Pivot columns to get 0 /1 flag columns

masterelaichi wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
Phil Parkin wrote:
IF you add the statement
SET DATEFORMAT DMY;
before you attempt the INSERT, the error will go away and the INSERT runs successfully.
Although this is an option -...
--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)

September 11, 2022 at 10:51 pm

#4086431
Reply To: Pivot columns to get 0 /1 flag columns

masterelaichi wrote:
Unless you meant conversion at the datasource ?
As Jeffrey Williams is implying, that would be the best solution.
--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)

September 11, 2022 at 6:35 pm

#4086410
Reply To: Pivot columns to get 0 /1 flag columns

Jeffrey Williams wrote:
Phil Parkin wrote:
IF you add the statement
SET DATEFORMAT DMY;
before you attempt the INSERT, the error will go away and the INSERT runs successfully.
Although this is an option - don't 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)

September 11, 2022 at 6:33 pm

#4086409
Reply To: query take long time when execute it so how to solve issue ?
ahmed_elbarbary.2010 wrote:
```
SELECT f1_AllCount = COUNT(f1.PartId)
,f1_UnqCount = COUNT(DISTINCT f1.PartID)
FROM Technology.Receipe ft
JOIN ExtractReports.dbo.TechnologyPlPartsFeaturValuesOrg f1 ON ft.featureid = f1.featureid
WHERE ft.operatorid = 1;
```
result is
```
f1_AllCount         f1_UnqCount
124140 ...
```
--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)
September 11, 2022 at 6:29 pm

#4086400
Reply To: Pivot columns to get 0 /1 flag columns

masterelaichi wrote:
jcelko212's post got me thinking
I tried to change the datatype of the paydate column to date by using the alter command but ended up getting this error "Conversion failed...
--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)

September 11, 2022 at 5:03 am

#4086295

Viewing 15 posts - 2,746 through 2,760 (of 59,067 total)