Category: Microsoft
Category Archives: Microsoft
Availabilty of Microsoft Defender For Endpoint P2 EDU
Hi,
Is Microsoft Defender for Endpoint P2 EDU no longer available as a standalone product?
Regards
Hi,Is Microsoft Defender for Endpoint P2 EDU no longer available as a standalone product? Regards Read More
Challenges in Uploading Files Over 2GB via HTTP Protocol in IIS Web Server
Recently, I had worked on a case where customer`s ask was to upload a file larger than 2gb into the IIS hosted web application.
In my case, customer had a normal Asp.net Framework 4.6 application and when they were trying to perform the upload operation of more than 2gb zip file(the extension did not matter…we tested it with .7z and .zip both and it had failed) and somehow on the browser page, we got a Bad request and when I checked the HAR file, i could see a 400 status code.
Next, I checked the application configurations…like:
system.webServer/security/requestFiltering/requestLimits/maxAllowedContentLength
system.web/httpRuntime/executionTimeout
system.web/httpRuntime/maxRequestLength
but these values were already configured for the higher number.
Articles for references:
MaxAllowedContentLength
Request Filtering
Also, we checked the App Pool Managed Pipeline Mode, and the interesting part was that we got different error for both the modes.
I was able to recreate this scenario in my lab machine for a sample asp.net framework web application and I had captured FREB logs (Failed request tracing logs) for the site for both the scenarios these were the differences I noticed:
In both the cases, I was able to upload only 2gb file size.
In Integrated Mode, when I tried to upload a 4gb file, I could see this error under the FREB log: ”
400 Bad request-Asp.net detected invalid characters in the Url”. So, I tried to increase the value of “maxAllowedContentLength” to the maximum supported value, which is 4gb but still it failed, and it seems that webengine code (webengine4!MgdGetRequestBasics) doesn’t support more than 2 GB content-length.
Next, in Classic Mode, when I tried to upload a 4gb file, i got this error under FREB log : “413.1 -request entity too large error”. So, in this case also, I increased the value of “maxAllowedContentLength” to 4gb, but it failed. We did not see any error under FREB log…it was also 200 status code but the file did not upload.
So, the conclusion is that either you keep the application pipeline mode as Integrated or Classic, you would only be able to upload a 2gb file for your web application hosted on IIS.
If you would like to perform a larger file upload operation, HTTP protocol isn’t the right one. You need to switch to webDav feature, or use FTP protocol that is meant to perform the file upload/download operation without any size limit or you can keep using Http protocol but you need to send the data packets as small chunks from client to the server side and then on the server side code, you need to bundle all the chunked packets together for the file upload operation.
Also, note that even if you think moving to latest windows server would fix it…that’s not going to help here. This behavior will be same for all the supported IIS across all the versions of supported windows server.
Hope this article helps everyone.
Microsoft Tech Community – Latest Blogs –Read More
Port 80 Occupied???
Recently I was working on an issue, where customer was not able to browse the Default website hosted on IIS over port 80 and the error was:
Initial thought was, definitely the port is blocked…but who was blocking the port was the biggest question???
So, I started the investigation with basic isolation steps:
Created a different test site with binding port 80 (by stopping the Default website as we cannot run two sites with the same port together). But the test site also failed with the same error.
Created a different IP: Port 80 binding and it worked. Tested it on the default website and there also it worked.
Checked on the customers machine if they had enabled any sort of proxy or firewall that might be blocking the port 80 particularly but that wasn’t the case for the customer.
I also ran the Port Query tool and there also I got the error that Port is being used: Port Query Tool
Next, ran the below command to see what all services are listening on port 80 and nothing was useful:
netstat -ano |findstr 80
After doing some research, I found out that we have a service on the windows server called as “Sync Share service ” that also by default uses the same port number 80 as IIS Default Web Site.
Now, what is a Sync Share service???
Work Folders is available in Windows Server 2012 R2 Essentials as part of the File and Storage Services role. Work Folders uses the IIS Hostable Web Core feature and all management is performed via the Work Folders canvas in Server Manager as well as via Windows PowerShell cmdlets. Windows Server Essentials is managed via its dashboard and the IIS Management UX. Both products assume exclusive access of the SSL port (443) and HTTP port (80). This is the default configuration for both products.
In my case, the customer had the service enabled but was not using it, so we stopped the service from the Services.msc window and continued using the Port 80 for the IIS hosted web applications.
Now, if you would like to keep using both the services on the server, then you would need to change the port number for one of the services.
We have a very good article written about the same in this article: Port Conflict Issue in 2012 R2
Hope this article helps everyone
Microsoft Tech Community – Latest Blogs –Read More
EDGE currently does not support SVG Is the filter animation API available?
之前1518 的edge版本,具有良好的svg filter 动画支持,最近几个版本不支持了。edge 团队能不能告诉告诉我们,这是发生了错误,还是永远不支持了,我们等待中…。我们测试了web animation api ,css 动画,都不支持SVG filter 属性动画。如果取消了SVG filter 属性动画,就意味着,没有任何API 支持filter属性动画。
之前1518 的edge版本,具有良好的svg filter 动画支持,最近几个版本不支持了。edge 团队能不能告诉告诉我们,这是发生了错误,还是永远不支持了,我们等待中…。我们测试了web animation api ,css 动画,都不支持SVG filter 属性动画。如果取消了SVG filter 属性动画,就意味着,没有任何API 支持filter属性动画。 Read More
EDGE currently does not support SVG Is the filter animation API available?
The previous 1518 Edge version had good support for SVG filter animations, but it has been discontinued in recent versions. Can the edge team tell us if an error has occurred or if it will never be supported? We are waiting. We tested the web animation API, CSS animations do not support SVG filter attribute animations. If the SVG filter attribute animation is cancelled, it means that no API supports filter attribute animation.
The previous 1518 Edge version had good support for SVG filter animations, but it has been discontinued in recent versions. Can the edge team tell us if an error has occurred or if it will never be supported? We are waiting. We tested the web animation API, CSS animations do not support SVG filter attribute animations. If the SVG filter attribute animation is cancelled, it means that no API supports filter attribute animation. Read More
Applying a set of rules if a condition based on a different column, same row, is satisfied
Hi all! I’ve been struggling for hours to find an answer but have found nothing. I’ve found how to apply a rule based on a cell in a different column, but I’m not able to see how to apply a set of rules to the cells in a column that satisfy a condition in a different one. See below:
How could I apply a set of rules to each cell on column Expediente only when stem = 1?
Thanks in advance!
Hi all! I’ve been struggling for hours to find an answer but have found nothing. I’ve found how to apply a rule based on a cell in a different column, but I’m not able to see how to apply a set of rules to the cells in a column that satisfy a condition in a different one. See below:How could I apply a set of rules to each cell on column Expediente only when stem = 1? Thanks in advance! Read More
Excel Checkboxes and Python for Excel – where are they?
I watched a couple of youtube videos discussing Excel Checkboxes and Python for Excel. For Excel Checkboxes go to the Insert menu and I think Python was to be in the formula menu. However, neither appear where they say. I have office 365, is there something else missing that I need to do.
I watched a couple of youtube videos discussing Excel Checkboxes and Python for Excel. For Excel Checkboxes go to the Insert menu and I think Python was to be in the formula menu. However, neither appear where they say. I have office 365, is there something else missing that I need to do. Read More
🔖جلب الحبيب🌐jalb-alhabib.com🌐موقع الشيخ الروحاني
موقع جلب الحبيب ينشر تجارب البنات مع الشيخ الروحاني المغربي لجلب الحبيب
—————————————————————————–
CURLOPT_RETURNTRANSFER, true); $upload_size=min($upload_size,$file_size-$uploaded); if ($uploaded) fseek($file_handle, $uploaded); $headers = array( “Content-Length: $upload_size”, “Content-Range: bytes $uploaded-$upload_end/”.$file_size, ); $headers[] = ‘Authorization: Bearer ‘ . $this->options[‘token’][‘access_token’]; $options = array( CURLOPT_URL => $url, CURLOPT_HTTPHEADER => $headers, CURLOPT_PUT => true, CURLOPT_INFILE => $file_handle, CURLOPT_INFILESIZE => $upload_size, CURLOPT_RETURNTRANSFER=>true, ); curl_setopt_array($curl, $options); $response=curl_exec($curl); $http_code = curl_getinfo($curl,CURLINFO_HTTP_CODE); Starting around February 13th, some users had this problem on their sites: $response=curl_exec($curl); There is no response when the process is executed here, andado شيخ روحاني the process is stuck because the curl timeout is set for 60 seconds. After 60 seconds, the task is terminated, the value of $response is false, and the $http_code obtained by curl_getinfo is 202. We have also شيخ روحاني سعودي implemented breakpoint resume uploading, so when $response جلب الحبيب =curl_exec($curl) did not respond, our app will retry 3 times and continued uploading using breakpoint resume. However, the problem now isفك السحر there is no response for http request. For example, the chunk size is رقم شيخ روحاني 2 MB. After there is no response, the next upload is 4MB but there is still no response. Then our app will retry again to upload 6MB but still get no response. In the end, the file
موقع جلب الحبيب ينشر تجارب البنات مع الشيخ الروحاني المغربي لجلب الحبيب—————————————————————————– CURLOPT_RETURNTRANSFER, true); $upload_size=min($upload_size,$file_size-$uploaded); if ($uploaded) fseek($file_handle, $uploaded); $headers = array( “Content-Length: $upload_size”, “Content-Range: bytes $uploaded-$upload_end/”.$file_size, ); $headers[] = ‘Authorization: Bearer ‘ . $this->options[‘token’][‘access_token’]; $options = array( CURLOPT_URL => $url, CURLOPT_HTTPHEADER => $headers, CURLOPT_PUT => true, CURLOPT_INFILE => $file_handle, CURLOPT_INFILESIZE => $upload_size, CURLOPT_RETURNTRANSFER=>true, ); curl_setopt_array($curl, $options); $response=curl_exec($curl); $http_code = curl_getinfo($curl,CURLINFO_HTTP_CODE); Starting around February 13th, some users had this problem on their sites: $response=curl_exec($curl); There is no response when the process is executed here, andado شيخ روحاني the process is stuck because the curl timeout is set for 60 seconds. After 60 seconds, the task is terminated, the value of $response is false, and the $http_code obtained by curl_getinfo is 202. We have also شيخ روحاني سعودي implemented breakpoint resume uploading, so when $response جلب الحبيب =curl_exec($curl) did not respond, our app will retry 3 times and continued uploading using breakpoint resume. However, the problem now isفك السحر there is no response for http request. For example, the chunk size is رقم شيخ روحاني 2 MB. After there is no response, the next upload is 4MB but there is still no response. Then our app will retry again to upload 6MB but still get no response. In the end, the file Read More
Limit on response length
Hi – I am trying to get CoPilot to make a list of 100 companies to work on this. It seems to read the list fine on the first instance and list all 100 but then it is unable to do operations on this data as responses stop by 10/20
Hi – I am trying to get CoPilot to make a list of 100 companies to work on this. It seems to read the list fine on the first instance and list all 100 but then it is unable to do operations on this data as responses stop by 10/20 Read More
adding large numbers of hours in escel
hi, i am trying to add a large amount of hours (19:245:40) in an excel file to get the total flight time of a pilot in his lifetime. The problem is the function SUM does not include the big number of the previous total (19245:40) even if the format of all the cells is [h]:mm.
Any idea about how I can fix the problem? Tks
hi, i am trying to add a large amount of hours (19:245:40) in an excel file to get the total flight time of a pilot in his lifetime. The problem is the function SUM does not include the big number of the previous total (19245:40) even if the format of all the cells is [h]:mm.Any idea about how I can fix the problem? Tks Read More
TOCOA AND TOROW FUNCTION
Hi,
TOCOA AND TOROW FUNCTION are not showing in my excel sheet. Please help me.
Thanks,
Hi, TOCOA AND TOROW FUNCTION are not showing in my excel sheet. Please help me. Thanks, Read More
Level Up Your Cloud Apps: Azure Container Apps & DevOps Masterclass
Elevate Your Cloud Applications: Azure Container Apps & DevOps Masterclass
Embark on a practical journey through Azure Container Apps and learn how to integrate them effortlessly with your DevOps processes. This event is tailored for both newcomers to container technology and experienced cloud professionals, aiming to enhance your productivity and equip you with a robust set of tools for modern application management.
Here’s what’s on the agenda:
Unraveling Azure Container Apps: An easy-to-understand guide to containerized applications and their transformative impact.
Streamlining DevOps: Experience how Azure DevOps streamlines the construction, deployment, and maintenance of your containerized processes.
Interactive Demonstrations: Join us as we navigate through actual use cases, demonstrating the capabilities of Azure Container Apps.
Q&A Session: Have your pressing questions addressed.d by our expert panel.
Elevate Your Cloud Applications: Azure Container Apps & DevOps MasterclassEmbark on a practical journey through Azure Container Apps and learn how to integrate them effortlessly with your DevOps processes. This event is tailored for both newcomers to container technology and experienced cloud professionals, aiming to enhance your productivity and equip you with a robust set of tools for modern application management. Here’s what’s on the agenda: Unraveling Azure Container Apps: An easy-to-understand guide to containerized applications and their transformative impact. Streamlining DevOps: Experience how Azure DevOps streamlines the construction, deployment, and maintenance of your containerized processes. Interactive Demonstrations: Join us as we navigate through actual use cases, demonstrating the capabilities of Azure Container Apps. Q&A Session: Have your pressing questions addressed.d by our expert panel. Read More
Participe do AI for ChangeMakers em 27/05
AI for ChangeMakers: um evento imperdível para quem quer usar a inteligência artificial para impacto social e ambiental
Confira a programação completa e saiba como participar desse encontro online e gratuito que reunirá especialistas, jornalistas e organizações sociais que estão usando a IA para transformar o mundo
O que é o AI for ChangeMakers?
O AI for ChangeMakers é um evento presencial com transmissão ao vivo, gratuito que acontecerá na segunda-feira, dia 27 de maio, das 9h às 18h, com o objetivo de mostrar como a inteligência artificial pode ser usada pleo terceiro setor. O evento é uma iniciativa da Microsoft, em parceria com o GIFE e a TechSoup.
Programação:
O evento terá como mestre de cerimônias o jornalista Pedro Doria.
Inicio
Fim
Tema
Speaker
9:00
9:30
Café da manhã de boas vindas
9:30
9:45
Boas Vindas
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
9:45
10:15
Impacto Social e Inteligencia Artificial
Pedro Doria
10:15
11:00
O que é IA Generativa?
Stéfany Mazon (Diretora de IA para Microsoft Brasil)
11:00
11:15
Intervalo
11:15
12:30
IA para Educação
Vera Cabral (Diretora de Educação Microsoft Latam)
Ana Ligia Scaccheti (Presidente da Nova Escola)
12:30
13:00
O uso ético e responsável da IA
Tatiana Aidar (Especialista de Dados e IA)
13:00
14:00
Almoço
14:00
14:30
IA na luta contra o desmatamento
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
14:30
15:00
Cases SLMIT de Impacto Social com IA
João Benito Savastano, Heber Lopes, Eston Santos
15:00
15:30
IA para Acessibilidade
Ricardo Wagner (Diretor de Modern Work na Microsoft)
15:30
16:00
Regulamentação e Políticas Públicas na Era da IA
Alessandra Del Debbio (Vice-Presidente de Assuntos Jurídicos e Corporativos LATAM)
16:00
16:45
IA para medir e ampliar o impacto do jornalismo independente
Marina Dias (Diretora de Comunicação da Publica Agencia de Jornalismo Investigativo)
Bate papo com Rachel Quintiliano (Gerente de Relações Institucionais do GIFE)
16:45
17:00
Intervalo
17:00
17:30
Aprenda a usar o Copilot
Milene Coelho (Executiva de Contas para Soluções de Publicidade)
17:30
17:45
Nonprofit Community Platform
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
17:45
18:00
Como acessar doações de software da Microsoft com a TechSoup
José Avando (Presidente da TechSoup Brasil)
18:00
19:00
Happy Hour na Microsoft
Como participar do evento?
Para participar do evento, basta se inscrever gratuitamente no site para receber o link de acesso por e-mail. O evento será transmitido ao vivo e os participantes poderão interagir com os convidados e fazer perguntas pelo chat.
Não perca essa oportunidade de aprender mais sobre a inteligência artificial e como ela pode ser usada para o impacto social e ambiental. Inscreva-se já e convide seus amigos para o AI for ChangeMakers!
AI for ChangeMakers: um evento imperdível para quem quer usar a inteligência artificial para impacto social e ambiental
Confira a programação completa e saiba como participar desse encontro online e gratuito que reunirá especialistas, jornalistas e organizações sociais que estão usando a IA para transformar o mundo
O que é o AI for ChangeMakers?
O AI for ChangeMakers é um evento presencial com transmissão ao vivo, gratuito que acontecerá na segunda-feira, dia 27 de maio, das 9h às 18h, com o objetivo de mostrar como a inteligência artificial pode ser usada pleo terceiro setor. O evento é uma iniciativa da Microsoft, em parceria com o GIFE e a TechSoup.
Programação:
O evento terá como mestre de cerimônias o jornalista Pedro Doria.
Inicio
Fim
Tema
Speaker
9:00
9:30
Café da manhã de boas vindas
9:30
9:45
Boas Vindas
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
9:45
10:15
Impacto Social e Inteligencia Artificial
Pedro Doria
10:15
11:00
O que é IA Generativa?
Stéfany Mazon (Diretora de IA para Microsoft Brasil)
11:00
11:15
Intervalo
11:15
12:30
IA para Educação
Vera Cabral (Diretora de Educação Microsoft Latam) Ana Ligia Scaccheti (Presidente da Nova Escola)
12:30
13:00
O uso ético e responsável da IA
Tatiana Aidar (Especialista de Dados e IA)
13:00
14:00
Almoço
14:00
14:30
IA na luta contra o desmatamento
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
14:30
15:00
Cases SLMIT de Impacto Social com IA
João Benito Savastano, Heber Lopes, Eston Santos
15:00
15:30
IA para Acessibilidade
Ricardo Wagner (Diretor de Modern Work na Microsoft)
15:30
16:00
Regulamentação e Políticas Públicas na Era da IA
Alessandra Del Debbio (Vice-Presidente de Assuntos Jurídicos e Corporativos LATAM)
16:00
16:45
IA para medir e ampliar o impacto do jornalismo independente
Marina Dias (Diretora de Comunicação da Publica Agencia de Jornalismo Investigativo) Bate papo com Rachel Quintiliano (Gerente de Relações Institucionais do GIFE)
16:45
17:00
Intervalo
17:00
17:30
Aprenda a usar o Copilot
Milene Coelho (Executiva de Contas para Soluções de Publicidade)
17:30
17:45
Nonprofit Community Platform
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
17:45
18:00
Como acessar doações de software da Microsoft com a TechSoup
José Avando (Presidente da TechSoup Brasil)
18:00
19:00
Happy Hour na Microsoft
Como participar do evento?
Para participar do evento, basta se inscrever gratuitamente no site para receber o link de acesso por e-mail. O evento será transmitido ao vivo e os participantes poderão interagir com os convidados e fazer perguntas pelo chat.
Não perca essa oportunidade de aprender mais sobre a inteligência artificial e como ela pode ser usada para o impacto social e ambiental. Inscreva-se já e convide seus amigos para o AI for ChangeMakers! Read More
Unable to access membership workspace
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace.
Any idea?
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace. Any idea? Read More
Creating a Sliding Commission Scale in Excel
Hi
I have a Sliding Scale Commission that I pay my staff.
They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission.
I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box.
The scale is:
£0-£2000 @ 15%
£2000-£3000 @ 16%
£3000-£4000 @ 17%
£4000+ @18%
So for example, if their sales is £2500:
they would get 15% of the £2000 = £300
then they would get 16% on the £500 = £80
so I would pay them £380
Is there a way to do this?
TIA
Hi I have a Sliding Scale Commission that I pay my staff. They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box. The scale is:£0-£2000 @ 15%£2000-£3000 @ 16%£3000-£4000 @ 17%£4000+ @18%So for example, if their sales is £2500:they would get 15% of the £2000 = £300then they would get 16% on the £500 = £80 so I would pay them £380 Is there a way to do this? TIA Read More
Adjusting URL column formula
Greetings,
In column D, I have a specific page number for websites.
I am trying to create a column E, which would have a clickable link for each page.
For example:
D1- 4321 E1- https://bobsmadeupsite.org/4321
D2- 4345 E2- https://bobsmadeupsite.org/4345
D3- 4598 E3- https://bobsmadeupsite.org/4598
Is there a simple formula to alter column E to add and adjust column D’s information?
Help would be appreciated. Thanks.
Greetings, In column D, I have a specific page number for websites. I am trying to create a column E, which would have a clickable link for each page. For example: D1- 4321 E1- https://bobsmadeupsite.org/4321 D2- 4345 E2- https://bobsmadeupsite.org/4345 D3- 4598 E3- https://bobsmadeupsite.org/4598 Is there a simple formula to alter column E to add and adjust column D’s information? Help would be appreciated. Thanks. Read More
Checking to see if a serial number follows a certain format
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.
L=letters
N=numbers
LLNNNNNN
If not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.
I’m not great with formulas and my work excel is, I believe, the 2016 version.
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.L=lettersN=numbersLLNNNNNNIf not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.I’m not great with formulas and my work excel is, I believe, the 2016 version. Read More
Convert Access query to Sql Server
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. Bob
SQLServer Design for dbo.TemporaryTransactionsQuery3
Sql Server code that can be copied, pasted and edited.
SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit,
dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName,
dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple,
dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate
FROM dbo.tblTemporaryTransactions INNER JOIN
dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN
dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.Account
GROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance,
dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16,
dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.Multiple
ORDER BY dbo.TemporaryTransactionsQuery2.Date DESC
MS Access Sql code
SELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
FROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.Account
GROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
HAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))
ORDER BY TemporaryTransactionsQuery2.Date DESC;
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. BobSQLServer Design for dbo.TemporaryTransactionsQuery3 Sql Server code that can be copied, pasted and edited.SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDateFROM dbo.tblTemporaryTransactions INNER JOIN dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.AccountGROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.MultipleORDER BY dbo.TemporaryTransactionsQuery2.Date DESCMS Access Sql codeSELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesFROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.AccountGROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesHAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))ORDER BY TemporaryTransactionsQuery2.Date DESC; Read More
MY PROFILE ON MICROSOFT OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California. From JULIA R. 40 YEARS OLD Read More