I've no idea what you mean - "update the Amount_Flag for same" means do nothing in English. Please provide an example.

Thanks Mr Sommarskog, that question came in after hometime.

It's good to see an "old master" at work here on ssc. I've been using your website - and recommending it...

SELECT

e.EmployerName,

super_userCnt = ISNULL(x.super_userCnt, 0)

FROM dbo.mytableEmployer e

LEFT OUTER JOIN (

SELECT

employerName,

super_userCnt = COUNT(*)

FROM employerSuper_Users

WHERE [Role] = 'Super_User'

GROUP BY employerName

HAVING COUNT(*) > 1

) x ON e.EmployerName...

A method I've used in the past is to restore elsewhere, remove the unwanted data from the restore, refresh indexes then use the restore to update live. With the relatively...

Is this a...

Sean Lange (8/8/2013)

---

This whole English thing is the reason we American's don't know any other languages. All the others have actual rules that you follow all of the time. In...

berniesprouster (8/9/2013)

---

Point taken about restores if all the data is stored in one set of tables.

Regarding partitioning, I thought you were thinking of partition functions/schemes if all the data was...

dwain.c (8/9/2013)

---

ChrisM@Work (8/9/2013)

---

dwain.c (8/8/2013)

---

I've been hearing a lot of Tok Pisin for the last...

Ed Wagner (8/6/2013)

---

I looked at the stored procedure, but it doesn't look like it hits anything that hard. It looks to me like an upgrade or version management procedure...

T.Ashish (8/9/2013)

---

With large-value data types You can define variables that can store large amounts of data, up to 2^31-1 bytes of character, binary, and Unicode data. That was not possible...

venkyzrocks (8/7/2013)

---

hi erland,

I'm sorry if the requirement was not clear.

I'll rephrase it :

The data is divided by Scenario : Jun (0+12) forecast and Actual.

And every Scenario will have a...

pdanes (8/9/2013)

---

No, actually I'm...

You're welcome Mr Danes. Assuming you're a taxonomist first and a programmer second, this is a fairly standard method to identify cardinality issues in a query.

Care to share the code...

Read the tables only once. Shamelessly nicked from both Scott's and Stefan's code:

WITH Preagg AS (

SELECT

x.Period,

c.CustomerID,

c.CustomerName,

ii.PartNumber,

SumPrice= SUM(ii.qty*ii.price),

SumQty= SUM(ii.qty),

SumValue= SUM(ii.qty*ii.price) / SUM(ii.qty)

FROM Customers c

INNER JOIN Invoices i...

One of the items (table sources) in your FROM list has two rows per single row in table Podrobnosti. Since there's no aggregation and all of the other tables are...