There is nothing wrong with preparing yourself for an interview (you should be), but in my opinion, not knowing all the answers is not that bad.

If you can show the...

Well, this was an easy one 😀

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...