Anyone ???

This sort of changes i always do with T-SQL. The GUI s*cks and does things you don't want to do most of the time.....

(just my humble opinion ofcourse)

I thought autoshrink was off, but it seems to be on :ermm:

Edit: After turning...

Paul White (11/10/2009)

---

Why does no-one ever include an actual execution plan? Actual row counts and thread distribution data are so important! And why omit the fact that the...

I've executed the query again and included the actual executionplan. I also tried it with MAXDOP, but it failed with an "out of memory" exception, so therefore i inserted the...

Here is a query that took 5 minutes, it returns a little over 5 million records. I also included the execution plan and a screenshot of the activitymonitor. The average...

no offence taken 😉

Thanks for your advice here:-)

GilaMonster (11/8/2009)

---

Try create a new column, batch-update the values, then drop the old column. Might lessen the log impact. Run checkpoints between each (since you're in simple) to mark the...

Florian Reischl (3/25/2009)

---

Hi Sander

Try this:

SET NOCOUNT ON

DECLARE @History TABLE (

ID int identity(1,1)

, IDStatus int

, IDItem int

, DateCreated datetime)

INSERT INTO @History (IDStatus, IDItem, DateCreated)

...

Ramesh (2/19/2009)

---

Ok..., the below query is tested and it works...

SELECTi.Name, ISNULL(s.Date, k.Date), s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROM#items i

LEFT JOIN #Stats s

FULL JOIN #KPIs k ON k.ItemID = s.ItemID...

Ramesh (2/18/2009)

---

SELECTi.Name, s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROMItems i

INNER JOIN

(

SELECTISNULL( s.IDItem, k.IDItem ) AS IDItem,

s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROM[STATISTICS] s

FULL OUTER JOIN KPIs k ON s.IDItem =...

If have tested it.... and indeed: it doesn't work

The testcase :

create table #Stats (

ID int identity primary key,

ItemID int,

Date smalldatetime,

Stat1 float,

Stat2 float,

Stat3 float);

create table #KPIs (

ID int identity primary...

Ramesh (2/18/2009)

---

Will the below query is supported by your query builder? If not, can you tell us what queries are supported, 'cause I am out of ideas?:D

SELECTi.Name, s.stat1, s.stat2,...

Ramesh (2/18/2009)

---

SELECTi.Name, s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROMItems i

INNER JOIN

(

SELECTISNULL( s.IDItem, k.IDItem ) AS IDItem,

s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROM[STATISTICS] s

FULL OUTER JOIN KPIs k ON s.IDItem =...

The total calculation works now, but now i'm comming to the history screens and again i'm running into a problem (i'm feeling quite dumb that i can't figure this out...