Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 5,685 total)

  • RE: AdHoc Reporting without giving too much control to the user – Is this possible?

    Jon MM (2/2/2012)

    If you know of a better approach I would love to hear about it!

    Thank you for your help 😀

    I don't know of a better approach but I've thought...

    February 2, 2012 at 12:10 pm

    #1442005

  • RE: I am trying to avoid cursors, what other option can I use?

    Out of curiousity, what's the problem with doing it this way:

    Update t1

    set status = 5

    FROm

    table1 AS t1

    JOIn

    table2 AS t2

    ON

    t1.DOC_CD = t2.DOC_CD

    AND t1.DEPT_CD = t2.DEPT_CD

    AND t1.DOC_ID = t2.DOC_ID

    AND t1.VERS_NO = t2.VERS_NO

    AND...

    February 2, 2012 at 12:06 pm

    #1442003

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

    Koen Verbeeck (2/2/2012)

    Sri8143 (2/2/2012)

    Phil,

    I am doing it thru transfer sql server objects tasks which was recomended initially in this conversation so going with it as i am unable to do...

    February 2, 2012 at 11:23 am

    #1441983

  • RE: Today's Random Word!

    JAZZ Master (2/1/2012)

    Springer

    Crying mothers in broken households who want to sue their ex husband and will have their five current boyfriends to show him all the reasons why!

    February 1, 2012 at 2:51 pm

    #1441451

  • RE: Join performance

    Star Trek (2/1/2012)

    how can I get it for a particular query?

    Do I need to write a query for that?

    The SPID itself needs to be reviewed during operations. You need...

    February 1, 2012 at 2:34 pm

    #1441442

  • RE: Best practices for File groups in OLTP Database?

    SQLKnowItAll (2/1/2012)

    Awesome... So for the test, it is what it is. In practice, as always, it depends 🙂 Can you give an example of a situation where you...

    February 1, 2012 at 2:24 pm

    #1441438

  • RE: Need Help with Query

    sartis (2/1/2012)

    Hey Craig, So i moved my where statement into my join statement and I got it to work correctly, thanks for trying to help.

    :blink: I'm glad that made...

    February 1, 2012 at 1:48 pm

    #1441424

  • RE: Best practices for File groups in OLTP Database?

    SQLKnowItAll (2/1/2012)

    According to Microsoft (I am studying for 70-432) you should always create at least 3 files and 2 filegroups. 1 file being the t-log, and 2 datafiles. ...

    February 1, 2012 at 1:47 pm

    #1441423

  • RE: Solid State drisk

    Rem70Rem (2/1/2012)

    This is for a data warehouse. My concern is the lifespan of the SSDs disks. As of now we don't have any SSDs in house, but it...

    February 1, 2012 at 12:05 pm

    #1441370

  • RE: Are the posted questions getting worse?

    Calling for backup here, if you could. Guy's got data that apparently is inconstently left out of his query in what he swears is a static system. I'm...

    February 1, 2012 at 10:40 am

    #1441333

  • RE: Help With Select Statement

    drew.allen (2/1/2012)

    Take a look at EXCEPT which performs a set difference, which is what you are looking for. It makes it much clearer that you are doing a set...

    February 1, 2012 at 10:35 am

    #1441331

  • RE: SSIS SCENARIO

    johnitech.itech (2/1/2012)

    :w00t:

    Hello ,Why not found ,If you install excel 2007 ,You will found automatically

    thanks

    That's incorrect. You need to install Excel 2k7 or 2012, then still perform those tasks....

    February 1, 2012 at 10:34 am

    #1441330

  • RE: Running Excel VBA through SSIS 2008

    Not from SSIS, once it's handed off the VBA command. You'll have to log into the machine and directly stop the process via Task Manager. Stopping the process...

    February 1, 2012 at 10:29 am

    #1441326

  • RE: Server side tracing

    sqlzealot-81 (2/1/2012)

    Okei, After I took the trace script from the production, Is there any way to specify the server name to be traced. So that I can run the job...

    February 1, 2012 at 1:09 am

    #1441067

  • RE: SSIS SCENARIO

    You have to go through a couple of hoops to hook SSIS to the new office documents (2k7+).

    This walkthrough is a good place to get started:

    http://dataintegrity.wordpress.com/2009/10/16/xlsx/

    February 1, 2012 at 1:06 am

    #1441063

Viewing 15 posts - 1,831 through 1,845 (of 5,685 total)