Forum Replies Created

Viewing 15 posts - 106 through 120 (of 3,232 total)

  • RE: Update Rolling Date Flags In a Table

    Thanks Ron. You stated your mail problem in the first sentence in your first post. "The Analysts I work with created tables...". Let me guess, they added...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2016 at 10:16 am

    #1870575

  • RE: Update Rolling Date Flags In a Table

    Hey Ron, it looks like you've had quite a few reads on your post but no one has ventured to answer your question yet. It may help everyone if...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2016 at 9:32 am

    #1870552

  • RE: new line \n not causing new line in email task

    I don't see where you are adding in a carriage return/new line into the variable. I think you're missing something. I do quite a bit of email message...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2016 at 9:30 am

    #1870550

  • RE: include results from table not found in another table

    It's hard to tell without knowing how your two tables are related. Can you post the table DDL and also mock up the sample data that matches your desired...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2016 at 8:31 am

    #1870519

  • RE: Calculate Lead Time / Process Time

    I totally agree Martin, in fact, I thought I had put it into my last post. When possible, adding/embellishing the facts/dimension in ETL would be the best approach.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2016 at 9:50 am

    #1870235

  • RE: Calculate Lead Time / Process Time

    It really depends on whether the OP needs it as a measure or a dimension member. The original post made it sound like an extension on the dimension. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2016 at 9:31 am

    #1870223

  • RE: Calculate Lead Time / Process Time

    These date values are in your dimension? I'm assuming you are OK with the Lead Time value being a dimension attribute? If so, replace your table in the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2016 at 8:37 am

    #1870191

  • RE: COMMA WITHIN NAME FIELD CAUSING COMMA-DELIMITED FILE IMPORT ERROR

    I prefer changing the delimiter also. Adding quoted identifiers is nice, but then you have similar issues when you have commas and quotes inside your strings. I've see...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 5, 2016 at 11:37 am

    #1869935

  • RE: SSIS connectivity logging into a SQL table

    Jez-448386 (4/4/2016)

    As Jeff said, SSIS might not be the best tool for this but you can achieve this using SSIS and without a script task.

    1. Create a new SSIS...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 4, 2016 at 5:19 pm

    #1869676

  • RE: Selecting data in a table that are not in the other table

    Couple of things I see you're missing. Your join to Selection needs to limit by user and also, your check for non-existence for selection needed tweaked. Also, the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 4, 2016 at 4:23 pm

    #1869666

  • RE: Add Role Members via SQL Agent Job

    Thanks Colin. I may have to try elevating my service account's permissions to sa, but I'd rather not as I'm pretty sure my hand will get slapped. Besides...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 4, 2016 at 8:47 am

    #1869535

  • RE: Creating table from 3 diffrent tables with conditions

    Are you trying to create a temp table? The #prefix in front of your table names makes them temp tables...

    Anyways, if you need to create a table from a...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    March 29, 2016 at 4:43 pm

    #1868437

  • RE: How to group SQL agent jobs

    You can use Job Categories to group them. They will not appear grouped in SSMS, but when you view the jobs via the Activity Monitor, you can sort them...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    March 29, 2016 at 4:00 pm

    #1868434

  • RE: Creating table from 3 diffrent tables with conditions

    Can you post what you've attempted already? How about sample rows of data to go along with it? Is there a specific problem that you've encountered while trying...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    March 29, 2016 at 3:58 pm

    #1868433

  • RE: Import data from Oracle

    We had issues when we began importing from Oracle while using the Attunity drivers. You have to have both the 32 and 64 bit drivers installed on your machines....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    March 29, 2016 at 3:04 pm

    #1868418

Viewing 15 posts - 106 through 120 (of 3,232 total)