And its also a better one:ermm:, probably 20% quicker than my code! Nice!

😎

Here is a quick "translation" to play around with

😎

USE tempdb

Go

DECLARE @CHEST_COUNT INT = 1000;

/* Seed for the Inline Tally */

;WITH TN(N) AS (SELECT N FROM (VALUES...

KGJ-Dev (5/11/2014)

---

yes the hierarchy is fixed. I believe your words. I will start working with the real time data and will post back.

Once again thank you so much for...

KGJ-Dev (5/11/2014)

---

Hi Eirik,

I am sorry for the error data and Thank you for the reply and query. I understand how to split. Have a question about i have 100*1000...

If this is a fixed hierarchy, then it is straight forward. First get all distinct parent entries and the append the children. There is one error in the data, the...

Hi David and Lynn,

thank you both for the input, I appreciate it.

Firstly, this is a valuable discussion and would merit a thread on its own.

Thanks to columnar editing in...

Jeff Moden (5/10/2014)

---

If you want real performance, I'd recommend that you stop counting altogether. Indexed views have an overhead on inserts in that they have to recalculate the totals...

Too bad my ESP (Extrasensory perception) connection is down:-P The create table statements for both tables and the update statement sql code...

David Burrows (5/11/2014)

---

In that case use Eirikur's trigger although you could simplify it to

CREATE TRIGGER trg_LastSaleDate ON dbo.Transheaders

AFTER INSERT, UPDATE

AS

IF UPDATE(TradingDate)

BEGIN

UPDATE c

SET c.ZLastDate = i.TradingDate

FROM inserted i

JOIN dbo.Customers c ON...

jeremy 64107 (5/11/2014)

---

Wow, that looks complicated!

I didn't write my script I had it provided to me.

I am new to Triggers, so that script really means nothing to me.

Are you able...

You might be slightly over complicating a simple thing, look through this example

😎

USE tempdb;

GO

/*

Sample Schema, Client and Transactions

*/

/* Drop the tables if they exist in the...

Views are helpful but no a panacea, with or without index. Other options include filtered indexes, column store indexes, partitioning and compression to name few. And as with (almost :-D...

jnsosnowski (5/10/2014)

---

hello ,

can anybody help me with the problem:

when I tried to run package from SQL Server management studio I get the error:

the connection type "MSORA" specified for connection manager...

Nilesh-788004 (5/10/2014)

---

I am using SSIS 2012, SQL Server 2012 both for source and destination.This is in regards loading a fact table.

I am using a Lookup and that Lookup table has...

Then you don't have to worry:w00t:

😎