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:

😎

Here are two more queries, somewhat self explanatory, first one is

CATEGORY-TYPE-NAME-COLOUR-COUNT(COLOUR)

and the second is

CATEGORY-TYPE-NAME-COLOUR-SUBTYPE-COUNT(SUBTYPE)

With a small set of 2000000 records, these are returning in 0.1-0.2 sec on my mediocre...

thomashohner (5/10/2014)

---

Any solutions on using a Laptop with a dual setup? I cant use a docking station. I would like to use two 24" monitors and keep the laptop lid...

Have you looked at Phil Factor's article on string search[/url]?

😎

In my opinion it is not optimal to hard code the data hierarchy in this way. If an attribute is added, it would mean revisiting the code!

The window functions can...

Thanks David for...

This has nothing to do with the Connection MRU (Most Recently Used), the registry keys for 2012/2014...

This query is somewhat self explanatory and answers in most parts your question

😎

USE master;

GO

SELECT

*

FROM

(

SELECT

ROW_NUMBER() OVER

...

Same in slightly different flavor

😎

USE tempdb;

GO

DECLARE @SAMPLE TABLE

(

PERSON VARCHAR(25) NOT NULL

,VAL_1 INT NOT NULL

,VAL_2 INT...