Forum Replies Created

Viewing 15 posts - 16 through 30 (of 46 total)

  • RE: Data Driven Subscriptions Updated

    Did you look at my delay mechanism for file-delivery subscriptions in this same forum?

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    March 5, 2010 at 8:29 am

    #1129210

  • RE: Is sort order important in index?

    Jeff Moden (2/5/2010)

    David McKinney (2/5/2010)

    Often I will put a descending sort order on a clustered index, so that when I do a select I generally see the latest rows inserted...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    February 10, 2010 at 9:27 am

    #1116944

  • RE: Data Driven Subscriptions Updated

    Randy-574768 (11/2/2009)

    Okay, got it! Instead of worrying about username/password for the extensionsettings, you're just editing a pre-existing subscription. Guess I was working too hard at it! 😛

    Thanks for the assistance...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    November 2, 2009 at 11:09 am

    #1073917

  • RE: Data Driven Subscriptions Updated

    Here's some additional sample code. This is the SQL to execute the stored procedure. You use it from the database where the physical data resides, NOT the ReportServer DB.

    USE [DBToRetrieveDataFrom]

    --...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    November 2, 2009 at 9:32 am

    #1073874

  • RE: Data Driven Subscriptions Updated

    Maybe this will help. Here's the SP I have. I took the SP from the aforementioned website and created a new delay mechanism for file share delivery that did seem...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    November 2, 2009 at 9:15 am

    #1073859

  • RE: Data Driven Subscriptions Updated

    Randy-574768 (11/2/2009)

    Are you referring to the following: http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html?

    This is the one that I cannot open. I imagine its just the one I need, so I was hoping someone could give...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    November 2, 2009 at 9:03 am

    #1073846

  • RE: Data Driven Subscriptions Updated

    Are you using the code from http://www.sqlservercentral.com/Forums/FindPost683529.aspx?

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    November 2, 2009 at 8:35 am

    #1073829

  • RE: Data Driven Subscriptions Updated

    Refer to the article at http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html to use more than one parameter.

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    July 21, 2009 at 8:01 am

    #1027624

  • RE: Data Driven Subscriptions Updated

    Actually, nevermind that last post. Assuming you want the date range to be from one day to the next (without regards to any time constraints), you may be better off...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    May 22, 2009 at 9:48 am

    #998954

  • RE: Data Driven Subscriptions Updated

    You could change the query to say something along the lines of:

    EndDate < DATEADD(d,1,@enddate).

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    May 22, 2009 at 9:00 am

    #998914

  • RE: Data Driven Subscriptions Updated

    Yep, privileges would definitely cause a problem too, lol. Glad you were able to fix the problem!

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    May 21, 2009 at 11:16 am

    #998418

  • RE: Data Driven Subscriptions Updated

    I could only suggest that you re-create the initial subscription by hand and schedule it for the past. Then just update the query to use the newly created Subscription and...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    May 21, 2009 at 8:12 am

    #998284

  • RE: Different Methods of JOINing to table with 6.4 Million Records

    I haven't had much more time to work on it late last week, but what I have right now is the same as a couple posts prior, with the exception...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    April 27, 2009 at 7:39 am

    #984344

  • RE: Different Methods of JOINing to table with 6.4 Million Records

    Thanks for the parsename trick. I do recall reading about that (probably on here) quite some time ago. For the amount of IPs that had to be converted using the...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    April 23, 2009 at 3:21 pm

    #983295

  • RE: Different Methods of JOINing to table with 6.4 Million Records

    I'll try your latest version and let you know. The previous version actually ran SLOWER than using the original version using a temporary table, believe it or not. Nice touch...

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]

    April 23, 2009 at 8:04 am

    #982928

Viewing 15 posts - 16 through 30 (of 46 total)