Help in SQL Conversion query
How I can convert Total column from varchar to numeric to show result in numeric with two decimal using SELECT query. Create table #temp (Num1 numeric (6,2), Num2 numeric (6,2), Num3 numeric (6,2), Num4 numeric (6,2), Total varchar(200)) insert into…
Android app crash on Prod but working fine on debug and Qual
I got this error System.TypeLoadException: Could not resolve type with token 01000003 from typeref (expected class 'System.Reflection.AssemblyProductAttribute' in assembly 'mscorlib, Version=4.0.0.0, Any solution for this issue?
Azure OAI content filters removes City Name
My team uses gpt4o for one of our tax reporting app processes. The api calls to gpt4o refuses to provide a response to a city name in Georgia. The api call is made to correct the provided wrong address. When the city name of Cumming, GA is provided along…
Setting up two ISP links to one Azure VPN Gateway
Hi all, As the title says, I'm looking to setup two ISP links to my Azure VPN Gateway. We have two ISP links coming into our office, one being our primary, and other being backup incase primary goes down. At the moment our primary ISP link is connected…
In RAG AI headers are not returned with ## in MarkDown JSON call
We are trying to add documents to RAG AI index. For this we are analysing the document and them getting the markdown json from which we are creating chunks. But our markdown json is not returning # for headers. I am attaching the document and output from…
Maui .Net 8 iOS MediaPicker.CapturePhotoAsync issue returns null after user presses USE PHOTO on apple device
Hi, Maui .Net 8 iOS MediaPicker.CapturePhotoAsync returns null after user presses USE PHOTO on apple device. Works perfectly on Windows and Android. Please help. Thank you, Grant
My custom domain will not delete
Hello, I have tried deleting my custom domain twice now. It just remains there for hours on Deleting and never completes. What can I do to fix this? Thank you!
azure openai gpt-4o create message to a thread, "Invalid type for 'content': expected a string, but got an array instead."
Getting 400 as in title. swapping endpoint to openai, worked fine. looking at the doc. azure doc seems not updated https://learn.microsoft.com/en-us/azure/ai-services/openai/assistants-reference-messages?tabs=python#create-message compare to the…
I'm trying to add Document Automation in Ai Builder, but it says "Document automation isn’t available in your region. Contact your admin or create a new environment"
Hello, We are trying to use the Document Automation in Power Automate, however get a red error message stating: "Document automation isn’t available in your region. Contact your admin or create a new environment". We are in the Europe Region…
SQL : Stored Procedure variables if returning 0 or null values do not run next steps
Hi Team - If any of the 4 variables are returning 0 or NULL value do not run the next insert scripts. Could you please help how i can write a condition. TIA Create PROCEDURE [FIN].[Test] @PeriodToAllocate varchar(8) /* */ AS SET NOCOUNT ON DECLARE…
should i make as many datafiles for temdb as many cpus i have.
hi, q1 As people said if u ghave GAM conention then u can go for adding as many datafiles of equal size in temdb as many cpus u have is it correct in sqlserver 2019 vesion also. q2) right click on sqlserver instance then select…
Not able to see certification details after scheduling the AZ500 exam
Hello Team, Please help me, I am unable to see Certification tab after scheduling the exam in the pearsonVue portal 500. Please let me know how to check this.
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
SQL : Stored Procedure variables if returning 0 or null values do not run next steps
Hi Team - I have a below Procedure which is running fine but i have a requirement where if any of the 4 variables are returning 0 or NULL value do not run the next scripts/steps. I have highlighted the script not below. Could you please help on how…
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Installing Security Update for Microsoft ODBC Driver 17 and SQL OLE DB Driver
I've downloaded the SQL Driver and OLE DB driver 9th April 2024 and have attempt to install by running as admin and powershell command. Powershell command "Start-Process -FilePath "C:\Temp\security-package.exe" -Wait" I have…
Problem with registering the website as an application
Hello, I have written a simple web application and I would like to register it as an application in the Edge browser. The problem is that for a website that is run from disk, this option is inactive. Is there any other way I can register a local site as…
{"code":"DisallowedLocation","message":"The provided location 'jioindiawest' is not permitted for subscription. List of permitted regions is 'australiacentral,australiacentral2,australiaeast,australiasoutheast,brazilsouth,brazilsoutheast,canadacentral,can
{"code":"DisallowedLocation","message":"The provided location 'jioindiawest' is not permitted for subscription. List of permitted regions is…
How to fix: mx.google.com rejected your message to the following email addresses
I spent nearly two hours chatting with two different Microsoft agents trying to resolve this issue. Instead of providing a solution, they told me to look for alternatives and end the chat. This is highly unprofessional. Any kind souls who can help on…
How to update email address for Microsoft Learn and certification profile
How can I change the email address associated with my account for Microsoft Learn and certification activities from Gmail to Outlook? I would appreciate any guidance on the steps needed to update my account's email address.