Forum Replies Created

Viewing 15 posts - 10,291 through 10,305 (of 11,676 total)

  • RE: $2M worth DW infrastructured set to be releases

    GilaMonster (1/29/2011)

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

    Yet this is posted in the SQL 11 forum 😀

    SQL 11 yes. Not SQL 2011.

    Ugh. Subtle difference 🙂

    I should get more sleep.

    Thanks for pointing it out.

    January 29, 2011 at 6:43 am

    #1280073

  • RE: $2M worth DW infrastructured set to be releases

    GilaMonster (1/19/2011)

    p.s. Denali has no official name yet, so you can't say it's SQL 2011. Currently it's just Denali

    Yet this is posted in the SQL 11 forum 😀

    January 29, 2011 at 6:11 am

    #1280067

  • RE: dynamic addition of new destination paths

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

    January 29, 2011 at 6:09 am

    #1280066

  • RE: ssis - error handling testing not working as i expected

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

    January 29, 2011 at 6:06 am

    #1280064

  • RE: Using BIDS 2008, export to flat file, can we give unique name for the file?

    mateusz.bazan (1/28/2011)

    Use sql script task to generate variable and then use it like a filename.

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

    But why make it difficult? The...

    January 29, 2011 at 6:00 am

    #1280063

  • RE: Difference between #temp temporary tables and @temp table variables

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

    January 29, 2011 at 5:50 am

    #1280062

  • RE: Get Most Recent One Table; JOIN and WHERE On Other Table

    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

    ...

    January 28, 2011 at 12:00 pm

    #1279870

  • RE: How to Deploy the SSIS Package

    Phil Parkin (1/28/2011)

    The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.

    The method Phil...

    January 28, 2011 at 7:24 am

    #1279703

  • RE: Doesn't security cascade down?

    Greg Edwards-268690 (1/28/2011)

    PITA

    Pain in the A$$

    Thanks for the clarification.

    But my version is much tastier 🙂

    January 28, 2011 at 7:21 am

    #1279700

  • RE: SSIS - Performance

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

    January 28, 2011 at 3:55 am

    #1279606

  • RE: Standard Deviation

    sharath.chalamgari (1/28/2011)

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

    Then why is the explanation confusing? I find it pretty clear...

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

    January 28, 2011 at 3:48 am

    #1279603

  • RE: Standard Deviation

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

    January 28, 2011 at 3:17 am

    #1279596

  • RE: Standard Deviation

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

    January 28, 2011 at 2:34 am

    #1279577

  • RE: Standard Deviation

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

    January 28, 2011 at 1:50 am

    #1279562

  • RE: Standard Deviation

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

    January 28, 2011 at 1:34 am

    #1279557

Viewing 15 posts - 10,291 through 10,305 (of 11,676 total)