Forum Replies Created

Viewing 15 posts - 121 through 135 (of 322 total)

  • RE: Just For Fun: An Impossible Delete

    Friday fun...:-)

    RBarryYoung (8/5/2008)

    Antares686 (8/5/2008)

    But my first impression was the first example for the contact numbers. I noticed you made 4 passes over the data instead of just the one. And...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 30, 2009 at 10:13 am

    #1073257

  • RE: Just For Fun: An Impossible Delete

    Thanks for the thought provoking article R, and 5 stars for a good read!

    I've used the Temp In-Place method in the past. Sometimes to fix my own mistakes. I...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 30, 2009 at 7:46 am

    #1073131

  • RE: Methods For Converting a Stored Procedure

    That explains a lot. Like

    linked server "(null)"

    It sounds like your OPENROWSET statement within the procedure isn't passing suitable credentials.

    Check BOL for Linked Server Security and Delegates regarding double hops.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 11:30 am

    #1072682

  • RE: Methods For Converting a Stored Procedure

    Ramon,

    I told you I was confusing myself.

    USE TEST

    GO

    CREATE PROCEDURE dbo.sp_ControlStock AS SELECT 'ONE', 'TWO', 'THREE'

    GO

    SELECT *

    FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

    'exec TEST.dbo.sp_ControlStock');

    GO

    That works fine for me. Maybe you...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 11:07 am

    #1072654

  • RE: Methods For Converting a Stored Procedure

    Ramon-218872 (10/29/2009)

    Yes I can exec sp_ControlStock without problems...

    I make some tests:

    exec SGANPS.dbo.sp_ControlStock

    It works

    SELECT *

    FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

    'SELECT *

    FROM SGANPS.dbo.ARTICULOS');

    It works

    SELECT...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 10:32 am

    #1072623

  • RE: Methods For Converting a Stored Procedure

    Do you get my point .... or have I missed yours?

    Regards,

    David.

    Maybe both Dave. I thought the article was real good and gave it a good rating. The UDF would...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 9:13 am

    #1072526

  • RE: Methods For Converting a Stored Procedure

    David McKinney (10/29/2009)

    ruedifuchs (10/29/2009)

    I agree, the code for using OPENROWSET is very interesting.

    But since the stored procedure has to return a result set, what is the advantage over using a...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 8:37 am

    #1072486

  • RE: Sharepoint Growth is Good

    Paul Hunter (10/29/2009)

    ... You end up with database bloat because everything is stored in the database (storage makers love that) unless you use a product like...

    The SP application...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 29, 2009 at 7:57 am

    #1072452

  • RE: Sharepoint Growth is Good

    We use MOSS 2007 for a Team site. 2 of our consultants set it up a couple of years ago with a minimum amount of pain. Neither had ever worked...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 28, 2009 at 12:47 pm

    #1071994

  • RE: Ceiling, Floor and Round!

    cengland0 (10/28/2009)

    Also, if I'm rounding a number, I'm trying to reduce the number of digits after the decimal. If it keeps the same number of digits, why round it?

    Good...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 28, 2009 at 12:13 pm

    #1071969

  • RE: DateTime Trick

    dmoldovan (10/27/2009)

    Bob, Tom - please see http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/19/sql-tip-keep-your-presentation-logic-in-your-presentation-layer.aspx...

    Both articles make good points, but note that I did say with some reporting applications. For instance it would be wasted time with a...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 27, 2009 at 8:29 am

    #1071243

  • RE: DateTime Trick

    Toreador (10/27/2009)

    Surely date formatting should normally be part of the presentation layer? I always return the whole datetime value and format it on the client, using their regional settings etc.

    I...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 27, 2009 at 6:47 am

    #1071159

  • RE: DateTime Trick

    SanjayAttray (10/26/2009)

    Does any one uses mixed datetime styles in a single query like the above one ?

    I haven't seen any.

    Probably not, but some readers no doubt will benefit from...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 26, 2009 at 1:54 pm

    #1070905

  • RE: Varchar or Char?

    Fatal Exception Error (10/19/2009)

    How efficient will char be if you have throw an rtrim() in the where clause?

    Not as efficient, but why would you want to use RTRIM in a...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 19, 2009 at 7:14 am

    #1067603

  • RE: Varchar or Char?

    If no special criteria other than length is specified I usually select varchar (yes, I'm a programmer). However given the fact that the data was to be used as "identifiers",...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 16, 2009 at 12:29 pm

    #1067103

Viewing 15 posts - 121 through 135 (of 322 total)