Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 1,473 total)

  • RE: Need help with modifying a free text "condition" column.

    You mentioned that hardcoding string replacement wasn't an option... why is that? My first thought with something like this would be to make a lookup table of what 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]

    November 18, 2008 at 5:59 pm

    #900230

  • RE: Need help with modifying a free text "condition" column.

    To clarify:

    Are you looking for something to clean up all existing data that would run on a scheduled basis... or something that corrects the entries as they go into the...

    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]

    November 18, 2008 at 5:17 pm

    #900223

  • RE: Overlapping query help

    Getting closer. The data you provided has 2 problems.

    1. There is only 1 line. Whenever providing sample data, you should provide a minimum of 3-5 lines,...

    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]

    November 18, 2008 at 3:23 pm

    #900208

  • RE: SQL Table Variable Issue

    Jack Corbett (11/18/2008)

    Man, I hate it when someone else not only beats me with an answer, but has a better one 😉

    Nice job Seth.

    I wasn't going to complain about the...

    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]

    November 18, 2008 at 3:15 pm

    #900198

  • RE: SQL Table Variable Issue

    Glad we could help. One other word of caution. You are selecting the Top 1 in that update clause, but you aren't ordering by anything. This could...

    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]

    November 18, 2008 at 2:09 pm

    #900172

  • RE: SQL Table Variable Issue

    Paul, please keep questions on one issue in one thread in the future. The issue is still the aliasing. When you get that error in Query Analyzer or...

    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]

    November 18, 2008 at 1:50 pm

    #900164

  • RE: The flow of an UPDATE STATEMENT with a FROM CLAUSE

    Chris Morris (11/18/2008)

    Is it just me or are the edit windows getting wider and wider today?

    Heh, yeah, John is a bit tab happy. I usually use the prettifier 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]

    November 18, 2008 at 11:51 am

    #900115

  • RE: SQL Table Variables

    Right, and you need to alias the Select part of the query, as Chris keeps telling you =).

    IF EXISTS(SELECT T1.ObjectID FROM @tmp_subjects t1

    ...

    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]

    November 18, 2008 at 10:50 am

    #900081

  • RE: The flow of an UPDATE STATEMENT with a FROM CLAUSE

    john.steinbeck (11/18/2008)

    Ok, so it's top down... thanks for that...

    I try to avoid Correlated Query's... That is why the previous Update Example I posted for this question is done... its used...

    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]

    November 18, 2008 at 10:40 am

    #900075

  • RE: The flow of an UPDATE STATEMENT with a FROM CLAUSE

    To specifically address the original question, so far as I've been able to tell, it's top down... with exceptions. Subqueries will NOT correlate. They will be evaluated pre-update...

    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]

    November 18, 2008 at 9:45 am

    #900021

  • RE: Help writing function to get decimal from string

    Rogue Dead Guy Ale is actually my favorite beer... I almost said as much in the last post, but got busy and just submitted it. Two Hearted Ale is...

    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]

    November 18, 2008 at 8:44 am

    #899978

  • RE: Help writing function to get decimal from string

    I have a feeling getting ahold of the Dr. Hexter's may prove difficult here in the states, but at least I know to snag them if I ever do come...

    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]

    November 18, 2008 at 7:22 am

    #899908

  • RE: Help writing function to get decimal from string

    I try not to torture myself with thoughts of good beer during the day. That said, any particular bitters worth trying out? I'm a hophead myself, but most...

    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]

    November 18, 2008 at 6:53 am

    #899877

  • RE: Help writing function to get decimal from string

    Actually, the answer was coffee. Keep practicing!

    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]

    November 18, 2008 at 6:06 am

    #899852

  • RE: Math Formula in a Variable

    You can say it as many times as you want, it doesn't make any more sense with repetition ;). Please provide sample data and an example explaining what you...

    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]

    November 18, 2008 at 6:04 am

    #899849

Viewing 15 posts - 1,081 through 1,095 (of 1,473 total)