ERROR 4819
SQL Server: 2019 ERROR (4819) -" Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow" We tested the exact same stored procedures on SQL2019 System A and everything worked as expected. But it gives errors when we test on the SQL SERVER 2019 System B. SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail. I’m not sure what to do next. Any thoughts/suggestions would be greatly appreciated. Thanks.
SQL Server Config Manager Error "MMC could not create the snap-in"
Hi, I have seen this error elsewhere online. I have gone to mmc to enable the snap in and I still have had no fix. My computer is running Windows Server 2022, SQL Server Express 2022, and SSMS. I have reinstalled, repaired, and all of the other tricks. Help!
Open reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's likehttps://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage athttps://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReportmight be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URLhttps://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?
Assi9stance in a Sql statement
Hi all I have a Table and I want to retrieve the record with the latest Sequence for each code. I need some help to write a query. Thanks to help me out. Code Name Sequence Title J001 John 1 Junior Administrator J001 John 2 Administrator J001 John 3 Senior Administrator S001 Sue 1 Accountant S001 Sue 2 Senior Accountant R001 Robert 1 Manager My desired output J001 John 3 Senior Administrator S001 Sue 2 Senior Accountant R001 Robert 1 ManagerHow to increase SQL query performance of a view?
Hi everyone, I am new to Microsoft community, so please let me know if this post is not in the right forum and if so which one would be the right one. issue: - Update & query (using Power BI) of my Sales Weekly View takes forever (>30min) and I would like to understand how I could improve this Current setup: - Sales Daily View: View containing aggregation and joins of two main sales tables and a date table - Sales Weekly View: View joining the "Sales Daily View", a sales table and two dimension tables and containing extensive logics (mainly aggregations) Please let me know if you have any idea how to streamline this and improve the performance of the view.
Forecasting with LAG() - NULL issue
Some Value Some Change Other Value ------------- --------------- -------------- x a% 41000 y b% 40750 z c% NULL m d% NULL k f% NULL I have data as shown. When the Other Value is NULL, I want to take the LAG value for Other Value and multiple it by the current rows Some Change Column. When I use LAG, it only populates the first NULL. When I get to the next row, LAG returns NULL but I want it to return what was previously calculated multiplied by the next percent in the Some Change column. For example: 1) 40750 x c% (This works with LAG but the rest do not) 2) (40750 x c%) x d% 3) ((40750 x c%) x d%) x f% Is there a way to do this inline without populating a table and looping over the NULLs? Sample code to work with: DROP TABLE IF EXISTS #LAGISSUE; CREATE TABLE #LAGISSUE( ROWID INT, SOMEVALUE INT, PercentChange FLOAT, OtherValue int ) INSERT INTO #LAGISSUE SELECT 1,40000, .98254, 41000; INSERT INTO #LAGISSUE SELECT 2,41000, .9654, 40750; INSERT INTO #LAGISSUE SELECT 3, 42000, .92012, NULL; INSERT INTO #LAGISSUE SELECT 4, 43000, .9357, NULL; INSERT INTO #LAGISSUE SELECT 5, 43000, .8976, NULL; SELECT SomeValue, PercentChange, OtherValue, CASE WHEN OtherValue IS NULL THEN ROUND(LAG(OtherValue) OVER(ORDER BY ROWID) * PercentChange,0) END AS ForecastedValue FROM #LAGISSUE; DROP TABLE IF EXISTS #LAGISSUE; SQL gives the following results. How can I get row 4 to be 37495 * .9357 and so on?
