Ugh. Subtle difference 🙂

I should get more sleep.

Thanks for pointing it out.

Yet this is posted in the SQL 11 forum 😀

scottichrosaviakosmos (1/26/2011)

---

I have one database source server and two destination server so i used multicast and data is flowing good from source to these parallel destination.

now i want something different...

robinrai3 (1/28/2011)

---

...

i then set the properties back to "SetFailPackageOnFailure" to false on the script task

and then in the control flow created a another script task that pops up a message...

Do you mean a Script Task, or an Execute SQL Task?

But why make it difficult? The...

GilaMonster (1/29/2011)

---

jerry-621596 (1/28/2011)

---

One person in the office claims 'insider' knowledge and is indicating that these are both exactly the same and that both always get physically written to tempdb. ...

d.potter (1/28/2011)

---

I've found a solution that works:

select eo.ID, eo.EventDate, gc.Grade

from #EventOccurrence eo

inner join #GradeChange gc

...

The method Phil...

Thanks for the clarification.

But my version is much tastier 🙂

frank_suijkerbuijk (1/28/2011)

---

Well, that is as design decision.

If it is heavily used, certainly use SQL command to extract to a local table and then do the transformations in a SQL...

sharath.chalamgari (1/28/2011)

---

It is Confusing because in his Query the parameter 1 does not mean that Number of samples.if...

mdv 9731 (1/28/2011)

---

I'm not really going to comment on that answer.

Just happy you are not creating any kind of BI og reporting in our company 🙂

I might be wrong but...

mdv 9731 (1/28/2011)

---

I do not agree that the answer is right.

Think it is supposed to be 0.

the standard deviation s (sigma) is the square root of the average value...

sharath.chalamgari (1/28/2011)

---

Koen (da-zero) (1/28/2011)

---

sharath.chalamgari (1/28/2011)

---

but if i cange the Query with some where condition,where i will get only one Row (sample) then the stdevp will results the null value

select stdev(pa_Rates)...

sharath.chalamgari (1/28/2011)

---

but if i cange the Query with some where condition,where i will get only one Row (sample) then the stdevp will results the null value

select stdev(pa_Rates) From Package where...