davidandrews13 (12/8/2009)

---

broadly...

htilburgs (12/8/2009)

---

What do you mean?

I just expand [1], [2] until [31] (for days of month)???

Because this was how we started, but I liked the [1] till [31] to be dynamic.

Or...

Erm...this is the result from the...

Hi David

This implies that you can only update one column, of one row, per statement - is this correct or am I missing the point somewhere? If it is the...

That's no good is it! How do you want it to look?

Is this different to your original output?

No problem - read this, it will show you how it's done.

They are, aren't they?

Britto (12/7/2009)

---

Hi Chris,

I am not an expert on Performance tuning. We are using so many views with JOINs in many places, irrespective of table size.

Application is too slow, even though...

jprabha.d (12/7/2009)

---

If i run your quey ,i get a constant values for the column MemoryPages_1

say for any dateTime ,the column values seems to be the same..

[MemoryPages MemoryAvailableBytes ProcessorTIme Datetime MemoryPages_1

9.948098824...

How many readings do you have per day?

Britto (12/7/2009)

---

Hi,

I am having a doubt regarding the appropriate use of SUB QUERY and JOIN.

Please tell me the usage of these techniques, exact place in SQL query which will give...

CASE WHEN datewritten IS NULL THEN getdate() ELSE @datewritten END

The pivot operator requires the new output columns to be described and mapped, but if they are not known at run-time the dynamic sql can be used to create the...

SELECT DISTINCT *

INTO #TABLEB

FROM #TABLEA

SELECT No, Name

INTO #TABLEB

FROM #TABLEA

GROUP BY No, Name