Viewing 15 posts - 2,731 through 2,745 (of 59,067 total)
[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...
September 13, 2022 at 3:16 pm
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...
September 13, 2022 at 3:10 pm
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...
September 12, 2022 at 10:22 pm
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...
September 12, 2022 at 9:54 pm
...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...
September 12, 2022 at 9:53 pm
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...
September 12, 2022 at 5:26 pm
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...
September 12, 2022 at 1:00 am
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...
September 12, 2022 at 12:50 am
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...
September 11, 2022 at 10:58 pm
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 -...
September 11, 2022 at 10:51 pm
Unless you meant conversion at the datasource ?
As Jeffrey Williams is implying, that would be the best solution.
September 11, 2022 at 6:35 pm
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...
September 11, 2022 at 6:33 pm
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 ...
September 11, 2022 at 6:29 pm
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...
September 11, 2022 at 5:03 am
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...
September 11, 2022 at 4:47 am
Viewing 15 posts - 2,731 through 2,745 (of 59,067 total)