Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 3,232 total)

  • RE: Using Replace Function

    Right on Chris. I'll give my vote for the first option as well. We have a SP here that relies heavily on using a table valued function (along...

    John Rowan

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

    January 19, 2009 at 9:18 pm

    #929477

  • RE: Capturing results messages

    I'm a bit skeptical that you'll find a way to read the "meta" responses as QA or SSMS does via SSIS. This type of stuff is usually best represented...

    John Rowan

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

    January 19, 2009 at 9:11 pm

    #929476

  • RE: Loop thorugh variable in ssis

    1. Create the following in SSIS:

    a. User::FileName of type string

    b. ForEach Loop Container

    c. Any task you need done...

    John Rowan

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

    January 19, 2009 at 9:01 pm

    #929472

  • RE: Page Life versus Buffer Cache

    Keep in mind also that the buffer cache hit rate is cummulative from the last restart of the SQL service. PLE consistantly less than 300 is a sign of...

    John Rowan

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

    January 16, 2009 at 4:32 pm

    #928585

  • RE: Trying to update rows in table-B based on values in table-A, but only works if value already exists in table-B

    You're looking for an upsert. Here's a good thread on the topic. I'm in favor of the UPDATE....if @@rowcount = 0 INSERT method.

    http://www.sqlservercentral.com/Forums/Topic638136-65-1.aspx

    John Rowan

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

    January 16, 2009 at 3:28 pm

    #928568

  • RE: Indexed View ... Slow !?!?

    Lynn Pettis (1/16/2009)

    I'd still use the datetime data type in my date dimension in my data warehouse. I'd just be sure the time portion was 00:00:00.000. If using...

    John Rowan

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

    January 16, 2009 at 3:21 pm

    #928562

  • RE: Indexed View ... Slow !?!?

    True. Looking back at the static dates table in this example, I see that this would be the case. What we do (for our DW) is use the...

    John Rowan

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

    January 16, 2009 at 1:50 pm

    #928505

  • RE: Indexed View ... Slow !?!?

    Jeffrey Williams (1/16/2009)

    We need to see the execution plan to verify, but here are a couple of things:

    1) cDate in StaticDates should be stored as a datetime instead of char(8).

    2)...

    John Rowan

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

    January 16, 2009 at 1:36 pm

    #928499

  • RE: writing function

    DECLARE @SomeDate datetime,

    @Today datetime

    SELECT @Today = GETDATE(),

    @SomeDate = DATEADD(dd,-30,@Today)

    --example with AsofDate 30 days ago

    IF MONTH(@SomeDate) =...

    John Rowan

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

    January 16, 2009 at 1:23 pm

    #928492

  • RE: How to use openrowset query

    You posted this in the SSIS forum, are you trying to do this in SSIS? If so, is this in a ExecuteSQL task or where have you done this?...

    John Rowan

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

    January 16, 2009 at 12:08 pm

    #928421

  • RE: How to display NULL value as zero value

    COALESCE() works as well.

    John Rowan

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

    January 16, 2009 at 11:54 am

    #928403

  • RE: Indexed View ... Slow !?!?

    Why the CROSS JOIN on your dates table? How many rows are in each of the tables?

    John Rowan

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

    January 16, 2009 at 11:51 am

    #928402

  • RE: writing function

    OK, now try to write this in T-SQL and post your first stab. We'll take it from there and help you out. Hint...a calendar or dates table would...

    John Rowan

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

    January 16, 2009 at 11:42 am

    #928395

  • RE: How to make a CASE STATEMENT (Case when ....then...) in SSIS

    Funny. I didn't see Eric's post for the same refresh reason. I did see Michael's but I just wanted to second the Conditional Split transform.

    John Rowan

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

    January 16, 2009 at 11:40 am

    #928391

  • RE: How to make a CASE STATEMENT (Case when ....then...) in SSIS

    Conditional Split is way to go here. It is SSIS's CASE statement.

    John Rowan

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

    January 16, 2009 at 11:28 am

    #928381

Viewing 15 posts - 1,486 through 1,500 (of 3,232 total)