Can you give some sample data and the CTE you are currently using.

CTEs should work for this scenario

Bhuvnesh (5/4/2012)

---

@aaron,

i have couple of questions ?

1) how much time does single run take(single execution) ?

2) Whats the frequency of single run ?

3) how much data single run handling?

4)...

@Gila,

I tend to agree, but I am coming to the conclusion that this application is the exception that proves the rule.

Data gets imported 3.8M records with the same update date...

Michael,

Part the project I am working on is to reduce the space used for a this database. We started off with 710M records in this table, never deleting any...

Thanks Gila,

Shop_code is just an example to make it use the RID lookup. I actually need to check against the other 37 fields as well, which would make the...

Grant Fritchey (5/1/2012)

---

You disabled indexes at the same time as the index defrag program was running and you started the copy anyway? All at the same time? Yeah, you're blocking...

Have you considered WITH ROLLUP and WITH CUBE on the Group by statement.

these will provide a summary at each level.

e.g. current results set looks like

Proj Item Desc...

David,

same question applies really - A clustered index will re-write the data on the disk so there will still be a huge overhead for creating the index. As I...

Ken at work (4/26/2012)

---

I have a table which I am trying to sum. Simple enough.

Field - Project

Field - Item Code

Field - Item Description

Sum(Hours)

The problem is that the Item Description...

dynamic SQL is the way to go with this.

this is the way I would approach the problem

You need to get the results set for the columns

(SELECT distinct name from...

computed columns on the source table?

user defined functions (UDFs) to simplify the casting

multiple views

my 2 cents worth - not knowing much about data mining..

Given that we would know the current location and vector of each player and the location of the ball (at...

I am sure that I have read somewhere that MSSQL 2012 (Denali) has the facility to do a query offset and return rows n to n+m. Which will allow...

Just a quick update.

I cancelled the original script after 19 hours because it still had not completed.

I made the modifications as suggested by Sean and re-ran it.

I took...

Thanks for the replies guys, I will take them on board.

I am not so concerned about the count being accurate, I understand why it is out, it was more...