sql server – Error in SQL 2018 Custom Map

Good day.
I am trying to create a stored procedure where the MEMBER ID is custom auto-incremented as follows

“AP202170001”
“AP202170002”
“AP202170003”

and so on as it goes by registering data in the affiliate table.

I have the following query that shows me what I want

SELECT 'AP' + DATENAME(YEAR,GETDATE())+ CONVERT(VARCHAR(2),MONTH(GETDATE()))+ RIGHT(CAST((POWER(10, 6) +
 CAST(ISNULL(MAX(IDAFILIADO), 0) + 1 AS VARCHAR(5))) AS VARCHAR(7)), 6)
AS IDAFILIADO
from AUT_AFILIADO_PUNTOS

enter image description here

But when I run the query again, it throws me the following error message

enter image description here

It is not adding the correlative or in which part I am making a mistake, the data type of the IDAFILIADO field is char (13)

graphics – Bizarre Viewport bug in Maya 2018

I can’t Google for this sort of thing because it’s a very difficult error to describe, so asking it here is my last resort. I have to use Autodesk Maya 2019 for the game I am working on, along with the legacy default viewport. I’m unable to use Viewport 2.0 because some of the graphics won’t properly display in that mode. (I also can’t use a different version of Maya in this scenario)

I am currently editing a wall (plane) in a larger area model. Here’s what my texture looks like:
Texture

I make a new Lambert material & load the texture as the file, and this happens:
Bug1
The image is in black and white w/ some rainbow lines making it look holographic when moving around the camera, and the UVs seem to be sheared.

This isn’t the first time that this has happened before, but I don’t have any older screenshots. I know that for some reason this just likes to happen a lot with square/plane-like geometry (Don’t know if that has any relation to the bug though) This bug happens once in a while & I haven’t found any possible pattern on what exactly triggers this.

As a troubleshoot attempt, I try and remove the material, make a new lambert material w/ the same texture, the same problem. Remove the material (again), use a Phong material instead, the same problem. Opened up the texture in Photoshop, re-exported the png, the same problem. Exported the texture as a jpg, the same problem, rinse and repeat. Thus, I’m not really sure if I can determine the problem sourcing from either the texture or setting up as a material.

Oddly enough, this problem goes away when I switch to Viewport 2.0. I made a new plane & applied a new material with the texture,

Here’s what that looks like in the legacy default viewport:
Legacy default viewport

Here’s what it looks like in viewport 2.0:
Viewport 2.0

Bottom line: Is there a name for this sort of distortion, bug, or artifact? And is there a way I can fix this without having to switch viewports or versions of Maya? I think the bug is possibly sourced from hardware rendering but I’m not 100% sure. I understand that this, of course, is the legacy viewport so problems can be expected to occur.

Yes, I’ve restarted Maya & my computer. I am using the most recent drivers for my graphics card.

Here are my technical specs:

  • GeForce RTX 2070
  • Intel i7-8700k @ 3.7 GHz
  • 32GB Ram
  • Windows 10

Thanks!

servidor – Como fazer uma chamada GET CURL no SQL Server Management Studio 2018 para retorno de um JSON?

Olá!

Não estou conseguindo carregar dados com curl no SQL Server Management Studio 2018.

A chamada que estou tentando fazer é:

curl -X GET -H 'Authorization: Bearer $ACCESS_TOKEN' https://api.mercadolibre.com/items/MLB1191972200

Fiz alguns testes no www.reqbin.com/curl e deu certinho me retorna um JSON.(Conforme imagem abaixo)

reqbin json return

Preciso desse JSON no SQL pois pretendo salvar os valores no BD.

Alguém tem alguma ideia de como eu posso fazer isso?

Aproveitando, alguém sabe se existe alguma ferramenta que já mapeia todos os atributos do JSON para salvar no BD?

Fonte de chamada curl: https://developers.mercadolivre.com.br/pt_br/publicacao-de-produtos#Campos-do-produto

game mechanics – “Acrobatic” and “fluid” combat system (i.e. Spider-Man 2018)

Like it says in the title, I like the way that Spider-Man Has a dynamic and fluid feeling combat system. I can’t exactly put my finger on a few key aspects, though, and I don’t have any way I can think of to recreate it in a game engine. Why does it feel good to play, and how could I apply that to my game?

How to install Mojave on a 2018 Mac mini that came with Big Sur?

I recently bought an open-box 2018 Mac Mini to replace a much older one before it dies. I wanted something that would run Mojave since I have some important, orphaned 32-bit software I need to run. Unfortunately (or not) the mini came with Big Sur installed and Recovery won’t go back to anything earlier. My plan now was to install Mojave on a separate partition so Big Sur would still be around to fiddle with. I have been unable to do that.

I used softwareupdate —fetch-full-installer etc. to get a recent, clean copy of the Mojave installer. I then used —createinstallmedia (with and without —download assets) to make a bootable installer on a thumb drive. It actually took me several attempts before it didn’t give an error message (one or more of the BridgeOS packages couldn’t be downloaded.) The resulting installer-on-a-stick boots, the apple logo comes up, and a progress bar starts. Eventually (maybe as long as a half hour) the bar gets to the end and it just sits there. No error messages, no nothing. Note: I did NOT wipe the mac mini’s internal drive before trying to boot the installer. I’m willing to do that if necessary, but only if someone tells me they’ve successfully installed Mojave that way and couldn’t do so without doing the erase.

I took the fetched installer over to my 2012 MacBook Pro and it executed fine and I was able to install Mojave on a partition on an external drive and boot from it (on the MacBook Pro.) I also took the thumb drive bootable installer over to the MacBook and it booted fine; I quit before actually trying to install Mojave, but that at least showed that the installer on the thumb drive appeared to work. So, the installer’s good and the thumb drive is good.

I then tried making a Catalina installer the same way. That worked like a charm and I was able to install it on a separate partition on the mac mini so now I could dual boot into either Big Sur or Catalina.

Whether relevant or not, I tried disabling SIP and Gatekeeper (spctl) on the mini, but that didn’t help. Suggestions? It certainly should be doable since I understand that model Mac mini originally shipped with Mojave. I’m willing to completely wipe the Mac mini’s drive if that’s necessary, and guaranteed not to brick it, but I shouldn’t have to do that, you’d think. There are some possibly relevant threads here that I’ve skimmed, but I didn’t see any that described exactly this problem. I’m pretty Mac savvy, but when it comes to firmware updates and the T2 chip I’m afraid I get lost.

So, let’s restate the question. How do you install Mojave on a 2018 Mac Mini that came with Big Sur? (Either on a separate partition or replacing Big Sur.) You get extra credit if you can tell me why the installer hangs for me at the end of its boot. Has anyone else encountered this problem? I know you can “solve” it by using any of several Virtual Machine packages, such as Parallels, but that would be my last resort.

dnd 5e – As of the November 2018 core book updates, what changes were made in the latest printings of the PHB that aren’t noted in the errata document?

There are a few changes – some minor, some more significant – in the latest printing of the PHB that are not noted in the 2018 errata PDF:

  1. Action Surge
  2. Awakened Mind
  3. Climbing, Swimming and Crawling rules
  4. Clone

The fighter’s Action Surge feature previously read (PHB, p. 72; emphasis mine):

On your turn, you can take one additional action on top of your regular action and a possible bonus action.

The bolded phrase was removed in the latest printing as of November 2018, and the Action Surge feature description now reads:

Starting at 2nd level, you can push yourself beyond your normal limits for a moment. On your turn, you can take one additional action.

This change is confirmed in the January 2019 edition of the Sage Advice Compendium:

Does the fighter’s Action Surge feature let you take an extra bonus action, in addition to an extra action?

Action Surge gives you an extra action, not an extra bonus action. (Recent printings of the Player’s Handbook no longer include the wording that provoked this question.)

Rules designer Jeremy Crawford also confirmed the change in the November 27, 2018 edition of Dragon+ (in which he discussed the errata), describing it as “unhelpful helper text” that caused people to interpret it as saying the opposite of what it actually meant. (Thanks to CTWind’s answer here for the timestamped link!)

In previous printings of the PHB, the Great Old One warlock’s Awakened Mind feature read (PHB, p. 110; emphasis mine):

You can communicate telepathically with any creature you can see within 30 feet of you.

However, the description of the Awakened Mind feature in the latest printing of the PHB reads (emphasis mine):

You can telepathically speak to any creature you can see within 30 feet of you.

Of note, this change makes it so that Awakened Mind’s telepathy is more clearly one-way rather than two-way. This matches the rules intent as indicated in one of the earliest versions of the Sage Advice Compendium in 2015 (v1.01), and still listed there in the 2019 Sage Advice Compendium (v2.3):

Does the warlock’s Awakened Mind feature allow two-way telepathic communication?

The feature is intended to provide one-way communication. The warlock can use the feature to speak telepathically to a creature, but the feature doesn’t give that creature the ability to telepathically reply. In contrast, the telepathy ability that some monsters have (MM, 9) does make two-way communication possible.

The fact that the wording of the feature was changed from previous printings of the PHB, however, is not mentioned in the errata PDF or in the Sage Advice Compendium entry.

The rules on Climbing, Swimming, and Crawling (PHB, p. 162) originally said:

While climbing or swimming, each foot of movement costs 1 extra foot (2 extra feet in difficult terrain), unless a creature has a climbing or swimming speed. At the DM’s option, (…)

As this question by Daniel Zastoupil and its answers note, there was technically some ambiguity about whether this meant having a climb/swim speed was sufficient to ignore the extra movement costs, or whether the creature needed to use those speeds in order to not have to spend extra movement.

However, as of November 2018, the rules on Climbing, Swimming, and Crawling now state (emphasis mine):

Each foot of movement costs 1 extra foot (2 extra feet in difficult terrain) when you’re climbing, swimming, or crawling. You ignore this extra cost if you have a climbing speed and use it to climb or a swimming speed and use it to swim. At the DM’s option, (…)

This change to the PHB (and basic rules) is not mentioned in the errata.

The first sentence of the clone spell description (PHB, p. 222) originally read (emphasis mine):

This spell grows an inert duplicate of a living creature as a safeguard against death.

However, as of November 2018, the clone description now begins (emphasis mine):

This spell grows an inert duplicate of a living, Medium creature as a safeguard against death.

The fact that it simply says “Medium” instead of “Medium or smaller” means that it’s now impossible to use the spell to clone any Small creature. This seems like an oversight (presumably the intent was to prevent cloning Large or bigger monsters with it), in which case a future errata may fix it accordingly.

This added size specification is not mentioned in the errata PDF.


Special mentions

There are 2 “non-changes” in the 2018 PHB errata that actually misleadingly seemed like a change at first:

  1. Deflect Missiles initially looked like it was changed (but it
    wasn’t); the errata document notes a different phrasing from before
    but doesn’t mark the supposed change as “(NEW)”. However, the listed
    phrasing is slightly inaccurate, leading to some confusion.
  2. Martial Adept also seemed like it changed (but it didn’t
    actually), only because many people misinterpreted an earlier
    errata’s paraphrasing of the change – or because the errata’s
    paraphrasing itself was misleading/inaccurate.

Deflect Missiles

The last sentence of the monk’s Deflect Missiles feature (PHB, p. 78) originally read:

You make this attack with proficiency, regardless of your weapon proficiencies, and the missile counts as a monk weapon for the attack.

The first PHB errata in 2015 summarized the change as follows (and the same summary remained unchanged through the 2017 errata):

Deflect Missiles (p. 78). The range of the monk’s ranged attack is 20/60 feet.

Instead of summarizing the change, the 2018 errata states the exact phrasing to be used – which oddly leaves out the information about the range of this attack that was added in previous errata:

Deflect Missiles (p. 78). The final sentence now ends as follows: “… regardless of your weapon proficiencies, and the missile counts as a monk weapon for the attack.”

This leaves out the information about range added in previous errata.

However, the last sentence of the monk’s Deflect Missiles feature actually currently reads (emphasis mine):

You make this attack with proficiency, regardless of your weapon proficiencies, and the missile counts as a monk weapon for the attack, which has a normal range of 20 feet and a long range of 60 feet.

This wording is seemingly unchanged from when the range of the attack was initially added in the 2015 errata. It appears that the 2018 errata simply incorrectly quotes the end of the final sentence of the feature, matching the version in the first printing of the PHB rather than the latest printing.

Martial Adept

The Martial Adept feat (PHB, p. 168) originally read, in the first printing of the PHB:

If you already have superiority dice, you gain one more; otherwise, you have one superiority die, which is a d6.

(Thanks to Mindwin’s question here for the quote.)

Naturally, people interpreted this as meaning that the feat was better for Battle Master fighters (PHB, p. 73-74) than for others, since Battle Masters gained an extra superiority die of the same size as their existing superiority dice (all of which scale with their level).

The very first errata to the PHB (in 2015) summarized its change to the feat as follows (and this summary remained unchanged through the 2017 errata):

Martial Adept (p. 168). The superiority die is added to any others you have, no matter when you gain them.

Some people took this to mean that the superiority die from Martial Adept still scaled with a Battle Master’s regular superiority dice, with the only perceived change being that the superiority die scaled with Battle Master levels whether they were taken before or after taking the feat.

However, the wording of the feat in all printings since that 2015 errata is actually identical to the current (2018) version of the Martial Adept feat (this Reddit thread shows the same wording as below); the 2018 errata simply includes an exact quote of the change now.

The relevant portion of the Martial Adept feat now says (emphasis mine):

You gain one superiority die, which is a d6 (this die is added to any superiority dice you have from another source).

What this actually means is that Martial Adept’s additional superiority die doesn’t scale with Battle Master levels; the character with the feat simply has a separate d6 superiority die. (Battle Masters with the feat can expend either their regular superiority dice or their extra superiority die from the feat to use their maneuvers.)

It’s arguable whether people were just misinterpreting how the errata previously paraphrased the change or whether the 2015-2017 errata misleadingly paraphrased it. (Mike Mearls’ incorrect tweet supporting the misconception certainly didn’t help.) Either way, it’s now clear because the errata PDF quotes the exact wording of the change instead.

In the old Google Feeds (June 2018), was it possible to place an interest/feed of selecting specific Photos of a webpage?

Back in June/July 2018 there was a daily Feed in the Google Feeds activity of a Google account for 24 consecutive days that read:

“Selected ‘Photos’ at ******” (see photo attached below)

All other Feeds were the usual, everyday Feeds. The Feed in question at random times of the day and was not in every Google Feed. I have kept the website anonymous (hence the asterisks) but this was the name of a business and not their url. The site had no link or affiliation to any other entries in the same Google Feeds list, and was a website in its own right. How was it possible to add a Google Feed such as this? Why would such an entry even show up in Google Feeds? I have never seen entries like this come up in Google Feeds before, or in the now Google Discover. Can anyone explain how/why this happened and how can I replicate it to prove/disprove the argument?
enter image description here

In the old Google Feeds (circa June 2018), was it possible to place a specific interest/feed regarding looking at selected Photos?

Back in June and July of 2018 there were daily feeds in the Google Feeds activity of a Google account for 24 consecutive days that read:

Selected ‘Photos’ at *********** (see photo)

All Feeds before and since these entries were the usual everyday feeds. These “Selected ‘Photos’ at *****” feeds were at random times of the day and were not in every Google Feed. How was it possible to add a Google Feed such as this? I have never seen “Selected ‘Photos’ at…..” come up in Google Feeds before, or in Google Discover. Can anyone explain how/why this happened and how I can replicate it to prove/disprove the argument?enter image description here

SUPER SU – Huawei P Smart 2018 FIG-LX1

I have rooted phone and installed TWRP ,magisk installed without problems,
but i want install SUPERSU every time get:

  • Decompressing ramdisk
    failed
    — Failure, aborting

I tryed a lot of zips but unable to install supersu.zip

audio – Can’t control monitor volume with keyboard on 2018 Mac mini

I just decommissioned my 2011 iMac and replaced it with a 2018 Mac mini and a new 27″ monitor. The iMac is where I used to play audio and controlling from the keyboard (F10 – F12) was never a problem. I am now connecting to the new monitor via HDMI (v1.4). It will play audio, but I can’t control it from the keyboard – I get this instead:

enter image description here

When I go to the Sound in System Preferences, this is what I see for output:
enter image description here

This leads me to believe that connecting via display port might possibly give me the ability to control via keyboard? I can’t seem to get a USB-C to mDP cable to send a signal, so I’m guessing I need Thunderbolt 3 to mDP. Does anyone know if that will work before go and buy the cable?

Any other tips that may work for getting control of the audio on the keyboard when connected via HDMI v1.4?