Brandie Tarvin (12/7/2010)

---

Alvin Ramard (12/7/2010)

---

Roy Ernest (12/7/2010)

---

I am trying to keep my word that I gave to Jeff. I am writing an article on how to have successful net meetings....

Better late than never. Last I heard, dkrumholtz was growing organic root crops on a plot outside Seattle.

Looks about right to me too.

Table aliases throughout would be ideal.

Hi James

Firstly, ISNUMERIC() has limitations - it returns true (1) if the value can be converted into a number. SSC has a recent article covering its limitations.

Secondly, the filters in...

Are you saying the column holds a...

alecio (12/6/2010)

---

What I need is a sum of values, taking the previous value and adding to the next.

RANK () OVER (PARTITION BY ORDER BY DATE ASC CODIGO_PESSOA, SUM (VALUE)) THE...

Arsenic

Can we have a few more sample...

SELECT Col1, Col2, Col3, Dense_Rank_Column, COUNT(*)

FROM (

Col1 Col2 Col3 Dense_Rank_Column = [Dense_Rank]

.. .. .. 1

.. .. .. 2

.. .. .. 2

.. .. .. 1

) d

GROUP BY Dense_Rank_Column

HAVING COUNT(*) >...

It's an example of implicit conversion

SELECT CAST('' AS INT)

Fix the obvious syntax error, then use table aliases throughout the CASE construct.

UPDATE TEST SET

B = CASE

WHEN (CASE WHEN ISNULL(S,0) <> 0 THEN G * H END) = 0 THEN NULL

ELSE (G + K END)

END

FROM TEST T

INNER JOIN #L TP

ON

T.A1...

GSquared (12/3/2010)

---

Chris Morris-439714 (12/3/2010)

---

Hey Gus,...

I'm sorry but it's impossible to understand the requirement here. It's not the language barrier between English and Portuguese, it's the lack of clarity and information. Would you be able...

Brandie Tarvin (12/3/2010)

---

I've actually used a Tally Table to do...