Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Convert Julian date to Gregorian date

    I was trying to solve the same problem this morning. Being very much a rookie, I searched for help and came across this thread. In my case, my...

  • RE: SSIS FTP Task Variable Remote Path

    Thanks, Steve, your second example helps some more. I agree, the switch would be helpful.

    Since it is Friday, I'm probably not going to think about this project again until...

  • RE: SSIS FTP Task Variable Remote Path

    Thanks for the reply, stevefromOZ.

    The "poor man's way", lol. That is probably the direction I'm headed in, but struggling through all the "if's" when there's no "else" operator.

    You can...

  • RE: Left Outer Join Calculation

    Thanks, piotr. Once Jack showed me the errors of my ways it made perfect sense how my results were as they were, exactly as you outlined. That was...

  • RE: Left Outer Join Calculation

    Thanks for the advice; I'll look into that. As you can probably tell, I'm pretty new at this stuff, learning as I go. I'm sure that studying the...

  • RE: Left Outer Join Calculation

    Thanks, Jack. That worked beautifully. I get it now. I had seen examples of moving the select criteria to the "On" statement but is amazing how much...

  • RE: Local Variable Question

    Yep, that worked, Matt. I appreciate your patience helping me learn through this. 😉

  • RE: Local Variable Question

    Thanks, rjv. That was it.

  • RE: Local Variable Question

    No worries, and thanks for the additional input.

    I'm still doing something wrong, and researching the resolution via BOL and other sources, but the error I'm getting now in messages when...

  • RE: Local Variable Question

    Thanks for the tip, Matt. Its almost there...just have to figure out the "incorrect syntax near 'sp_executesql'" message. The good news is that if I remove that line,...

  • RE: Help w/my Update Logic

    Matt Wilhoite (9/2/2009)


    No problem, glad it worked. Have fun with the remaining logic in your process. Sounds like it should be fun.

    Yeah, I don't think it will be...

  • RE: Help w/my Update Logic

    drew.allen (9/2/2009)


    Here is what I believe is happening. Your FROM statement is doing an implicit join on the two tables. It is then calculating the original value for...

  • RE: Help w/my Update Logic

    Matt, thanks. That worked very well. My background is more on Access where the Crosstab Wizard simply does it for you, and I'm still learning the SQL Pivot...

  • RE: Three Table Query Including One Left Join

    Thank for your insight, too, Flo.

  • RE: Three Table Query Including One Left Join

    J-F Bergeron (8/27/2009)


    SparTodd (8/27/2009)


    Hi,

    Even with my limited experience, I should be able to figure this out, but I'm stumped.

    In SQL Server 2005 I have a DB2 Database on a linked...

Viewing 15 posts - 1 through 15 (of 16 total)