New answers tagged

2

Another workaround for this problem is to use set based logic, replacing the CASE expression with a left join (or outer apply) to a reference table (ref in code below), which can be either permanent, temporary or a derived table / CTE. If this is needed in multiple queries and procedures, I'd prefer to have this as permanent table: SELECT ref.result_column ...


-4

one way to get around this is to include the test in the when clause i.e. case when SUBSTRING(p.Name, 1, 1) = 'a' THEN '1' ...


-3

You need to add more memory to this server and increase you max memory.


1

I'm suspecting/assuming that some data file had a lot of free space inside it, and the new index simply occupied that already allocated space. Is this likely to be what has happened? Based on your description of events yes this must have been the case. The free space might have arisen either due to the initial size of the database files leaving more ...


1

Any uninstall of SQL Server will not delete the data or log directories used by the particular version. The reason your data and log files stayed in the same spot is because you did an inplace upgrade. It will not move the databases to the "new" folders SQL Server 2012 would create (eg. "..\MSSQL11.MSSQLSERVER\DATA"). The only issue you could hit when ...


4

I suspect the issue appears because you are referencing the view twice in the UPDATE statement, once in UPDATE [dbo].[vwMP_VOL] clause and then in FROM clause and the second time you are giving it an alias. But you are not using the alias in the SET clause, only the first reference. The result is that the the two references are unrelated and the rows are ...


1

Change your update to UPDATE [dbo].[vwMP_VOL] SET [vwMP_VOL].[id_batch] = inserted.id_batch ,[vwMP_VOL].[id_invoice] = inserted.id_invoice ,[vwMP_VOL].[text_vchr] = inserted.text_vchr ,[vwMP_VOL].[amt_frt_tcur] = inserted.amt_frt_tcur ,[vwMP_VOL].[amt_line_hcur] = inserted.amt_line_hcur ,[vwMP_VOL].[line_total_hcur] = ...



Top 50 recent answers are included