[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...

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...

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...

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...

...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...

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...

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...

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...

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...

Although this is an option -...

As Jeffrey Williams is implying, that would be the best solution.

Although this is an option - don't do...

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 ...

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...

so how to use cross apply as you write below

The optimizer attempts to SORT 65 million rows after a merge join.  Yeeeesh.   One way to re-write the query would...