You can do it with a cursor which can be faster if you a purchasing a large number of products:

IF OBJECT_ID (N'tempdb..#TEMP1', N'U') IS NOT NULL DROP...

;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N) RunningTotal, * 
      from #TEMP1 t
...

;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N asc) RunningTotal, * 
      from #TEMP1 t
 ...

Create two temporary tables which are copies of D and S but with the additional columns of [O_NAME_04_NOT_NULL], [O_NAME_05_NOT_NULL], [O_NAME_06_NOT_NULL] , then add a clustered index on the name columns.

e.g....

You can query SSAS...

I've found replacing...

Have you looked at the execution plan? Maybe you should paste all the code in this thread.

Jonathan,

There is no problem with the UPDATE. All indexes are created. Moreover, tables #SecuritiesClass and #SecuritiesClassRules only contain 3 records. By putting GETDATE() before and after the UPDATE, I...

If the MERGE statement is just updating or inserting then change it to be an update statement followed by an insert where not exists statement.

Hi Ken,

For your knowledge, this is the actual statement that triggers the problem:

UPDATE SC
SET 
  SC.QuickEffectiveDate = SCR.EffectiveDate,
  SC.QuickNominalValueChangeTypeID = SCR.NominalValueChangeTypeID,
  SC.QuickHasRightToVote =...

I've done the difficult bit for you (writing the function) I...

Create this function

CREATE FUNCTION dbo.TitleCase
(
    @String nvarchar(MAX)
)
RETURNS nvarchar(MAX)
AS
BEGIN
RETURN stuff(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
       replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
       lower(@String),' A','...

SELECT *
  FROM ParentTable p
 OUTER APPLY(SELECT TOP(1) *
               FROM ChildTable c
...

Just like to say congratulations to Jeff for reaching 1 million points:

I assume, therefore, that none of your reports aren't already in an SSRS project? If so, how are the existing reports maintained? What happens when someone asks for a...