Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 1,182 total)

  • RE: Joins giving bogus result set

    This works and it's easier on the eyes (and head)

    SELECT

      e.employeeID

      ,StartDate

      ,VacDays = SUM(CASE WHEN OffDayType = 'V' AND YEAR(DateEarned) = 2007 THEN DaysEarned...

    February 1, 2007 at 5:37 pm

    #687274

  • RE: Change of Address View

    This hasn't been tested, but should give you what you need.

    SELECT

    sp.pubcode

    ,sp.name

    ,a2.addressline1

    February 1, 2007 at 5:11 pm

    #687269

  • RE: INSERT using EXEC problem

    I'm not the DBA, but I would have been consulted/notified if there were any. This particular server is "mine" and no one touches it but me. The linked server is...

    February 1, 2007 at 4:52 pm

    #687268

  • RE: INSERT using EXEC problem

    Man you're good.

    The procedure does a select from a linked server into a temp table. I then do another select, joining on the that table.

    I think I'm seeing it now....

    February 1, 2007 at 4:24 pm

    #687262

  • RE: INSERT using EXEC problem

    INSERT #agingData EXEC dbo.populateAging

    February 1, 2007 at 3:22 pm

    #687242

  • RE: INSERT using EXEC problem

    Sergiy,

    That did not make a difference?

    February 1, 2007 at 7:27 am

    #687094

  • RE: INSERT using EXEC problem

    Thanks for the info! I REALLY do appreciate it.

    Just a note though, ABSOLUTELY nothing has changed with this proc. or table in (at least) three months and it runs weekly,...

    January 31, 2007 at 9:04 pm

    #687031

  • RE: INSERT using EXEC problem

    Oh, and do you have any idea what would cause this to "suddenly" start happening?

    Could this be one of those intermittent bugs that MS hasn't seen/resolved?

    January 31, 2007 at 8:23 pm

    #687025

  • RE: INSERT using EXEC problem

    I was wondering when Sergiy would chime in.....

    Thanks, I'll try it tomorrow.

    But still one question. Why would moving the insert into the proc work.

    January 31, 2007 at 8:19 pm

    #687024

  • RE: Data Driven Subscriptions

    Hi all,

    The new article won't be published until early March. But until then you can go here http://www.sqlservercentral.com/columnists/jselburg/2824.asp

    Just remember to vote when the article comes out in the...

    January 31, 2007 at 6:04 pm

    #686994

  • RE: INSERT using EXEC problem

    I could/can try that. This is a server used mainly for report subscriptions that run in the early AM, and only limited use during the day.

    So you're saying that a...

    January 31, 2007 at 5:04 pm

    #686989

  • RE: INSERT using EXEC problem

    I'm still not convinced the plan had anything to do with it.

    In my humble understanding, the fact that I could run the procedure by itself fine tells me that...

    January 31, 2007 at 4:31 pm

    #686986

  • RE: INSERT using EXEC problem

    OK, this is just too $%@$& weird!!!

     

     

    Originally I was calling...

    January 31, 2007 at 3:16 pm

    #686973

  • RE: INSERT using EXEC problem

    No noticable differences in the plans.

     

    Here's an interesting note. I can run the procedure with "Results to File" then import the data into my table just fine. This is a...

    January 31, 2007 at 2:36 pm

    #686967

  • RE: INSERT using EXEC problem

    Nope.

     

    How would that make a difference? I can run the proc alone, then with insert, then alone and the "alone" executions always work fine. Doesn't recompile just for the proc...

    January 31, 2007 at 11:08 am

    #686911

Viewing 15 posts - 1,051 through 1,065 (of 1,182 total)