Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,473 total)

  • RE: Stored Procedure accessing LINKED SQL2K

    Seems pretty straightforward. Gathers data from the other server and stores it on yours. There's nothing glaring about this that is inefficient or wrong. There are some...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 27, 2009 at 12:27 pm

    #933446

  • RE: Trying to rewrite RBAR Function

    Jeff mentioned on another thread yesterday that he's been really busy. There's a few he hasn't had time to reply to yet. Give it time :P.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 27, 2009 at 8:43 am

    #933241

  • RE: SQL Book Recommendation

    Read this forum. Look at the problems and the solutions. When you see something you don't understand, Google more information on it, or look and see if there's...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 26, 2009 at 11:12 pm

    #933001

  • RE: Passing number of rows to be returned as a SP parameter

    And that you're using 2005 or above. (Different error message if you're on 2K, but figured it was worth mentioning for anyone else who might read this and try to...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 26, 2009 at 7:34 pm

    #932959

  • RE: Trying to rewrite RBAR Function

    Unfortunately, not right away, no. I know that normally doing any kind of data access in an inline function is a "bad idea", in the same respect that playing...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 26, 2009 at 1:18 pm

    #932799

  • RE: Trying to rewrite RBAR Function

    How about this?

    [font="Courier New"]

    CREATE FUNCTION dbo.fnGICSPFParseGICCatalog_Test(

       @string  VARCHAR(8000),

        @TrimAll BIT)

    RETURNS VARCHAR(8000)

    AS

    BEGIN

    DECLARE @b-2 VARCHAR(8000)

    SET @b-2 = '' -- Initialize @b-2

    IF @TrimAll = 1

       SELECT @b-2 = @b-2 + SUBSTRING(@String,N,1)

       FROM Tally

       WHERE N...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 26, 2009 at 12:54 pm

    #932790

  • RE: when a query return nothing

    I actually run into this issue a lot with Crystal. If you run the report with parameters that return no data, the whole thing blows up. As Gus...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 26, 2009 at 12:35 pm

    #932781

  • RE: How to replace a cell value with a cell value in previous row

    This is basically gap finding, and it seems like you should be able to use a variation of Jeff's identity gap finding technique for this. I've been trying to...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 25, 2009 at 7:12 pm

    #932449

  • RE: How to replace a cell value with a cell value in previous row

    I get it now. Great explanation. So you've also found that it's quicker to dump repeatedly into the slightly bigger varbinary's than just dumping into one big one...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 25, 2009 at 3:27 pm

    #932437

  • RE: How to replace a cell value with a cell value in previous row

    RBarryYoung (1/24/2009)

    So here's my code using the SELECT pseudocursor hot-wired to act like an UPDATE pseudocursor, plus every trick I could think of to remedy the problem of SQL string...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 25, 2009 at 9:47 am

    #932381

  • RE: Help - Report Query

    The article in my signature describes how to set this up, but let's say you have tableA with one column Aval.

    Your table / sample data script would look like this:

    DECLARE...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 24, 2009 at 10:54 am

    #932244

  • RE: Correct use of @variables and uniqueidentifiers

    Jeff Moden (1/23/2009)

    Man, I blew another pork chop out my nose when I saw the trigger and the cursor.

    WAIT WAIT WAIT.

    Blew a pork chop out of your nose?

    So.......

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 24, 2009 at 9:55 am

    #932235

  • RE: Help - Report Query

    Phil,

    Your providing of sample data is much appreciated, as are the expected results from your requests. However, if you find that you're not getting a lot of...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 24, 2009 at 9:49 am

    #932234

  • RE: How to replace a cell value with a cell value in previous row

    Jeff Moden (1/24/2009)

    Garadin (1/23/2009)

    He wrote an article on it actually. See the Running Totals link in my signature.

    Heh... I'm getting closer... normally, you beat me to this on providing...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 24, 2009 at 9:43 am

    #932233

  • RE: What is RBAR? How can I avoid it?

    Loops, cursors, complex correlated subqueries, inline functions with data access, functions in the where clause (I believe, don't see this one much)... all are examples of RBAR. In other...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 24, 2009 at 9:35 am

    #932232

Viewing 15 posts - 766 through 780 (of 1,473 total)