Why would you create a table per user?

Add a column where you store the information what Portal User (or whatever you define as a unique connection) the data belong to.

But...

Sounds like an auditing task.

Assuming you're using SS2K5 (as indicated by the forum you posted in), you might want to consider a trigger concept using the data from the internal...

Since the CTE still contains the join to the views I wouldn't expect a major improvement.

As I stated before, one of the methods to improve the performance of such kind...

I strongly vote against just the shrinking of tempdb.

Tempdb didn't expand to that size without a reason. And, as long as the reason has not been found and taken care...

Here's what I would do:

Step 1: extract the columns belonging together (e.g. [LN 00005_RcvCo] and [LN 00005 CtrlStnFlag]) into a separate table with just the primary key of the original...

A view (assuming it's not an indexed view) usually just holds the definition of the query.

When referencing such a view in another query, SQL Server will use the underlying definition...

without seeing the actual execution plan it's almost impossible to tune it any further. Especially since there seem to be views involved (vw_categoryColsQuestionLORAll vw_surveyCategoryHierarchyFlat). Those views might contain code that's...

Steve Jones - SSC Editor (6/22/2011)

---

ALZDBA (6/22/2011)

---

Steve Jones - SSC Editor (6/21/2011)

---

Just an update, the horse looks good. Vet came today, said there will be a scar, but full recovery...

Following opc.three's line of thought:

Why don't you populate the "flag" together with the running total calculation?

Since the "flag" value depends on the previous "flag" value, it's just another running total...

Please read and follow the advice given in the first article referenced in my signature on how to post SQL code questions.

We'll need table def and sample data ina ready...

You might consider having a look at the related link in my signature (strong hint: the name is related to perform a "Cross Tab" task)...

There might be a confusion between indexed views and "ordered" views.

In SS2K it's possible to control the order of the rows returned via ORDER BY in the view definition.

SS2K8 will...

To be as precise as the question is: most probably an issue with the query. 😉

If you decide to post a more detailed question you might get a more detailed...

As you might have noticed, this is a MS SQL Server forum.

Maybe you'll find better answers on a Oracle forum... 😉

Here's an alternative that should "slightly" outperform the previous solution...

It's the rather classic CrossTab approach (see the link in my signature for details).

;WITH cte AS

(

...