Forum Replies Created

Viewing 15 posts - 796 through 810 (of 1,473 total)

  • RE: View became incorrect when fields added to table

    Bob Hovious (1/19/2009)

    I know I'm preaching to the choir, but select * is just bad practice.

    I agree. I was just considering re-writing this to manually list all of 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]

    January 19, 2009 at 2:01 pm

    #929374

  • RE: View became incorrect when fields added to table

    Thanks Matt. I've always known you could Schema Bind a view, but I've never needed to, so I didn't consider the reasons why you might do so. In...

    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 19, 2009 at 1:55 pm

    #929368

  • RE: View became incorrect when fields added to table

    If that's the case, then any time the definition for Table1 changes, that view will have to be altered, unless there is another option that I can set...

    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 19, 2009 at 1:35 pm

    #929364

  • RE: how do i summarise and transpose table data

    See the link in my signature for Jeff Moden's article on Cross-Tabs. Should solve this handily.

    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 19, 2009 at 10:28 am

    #929311

  • RE: Development Tips and Tricks

    I'll start it off with one that is fairly basic but many may not know about.

    Creating a temp / staging table that mirrors a real table for data selection.

    SELECT *

    INTO...

    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 18, 2009 at 1:53 pm

    #928964

  • RE: Connect to remote SQL server (transact SQL)

    Create your second server as a linked server on the first. (See http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx for more information)

    Then, you can reference the other server and the current one in the same query.

    For...

    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 18, 2009 at 1:40 pm

    #928963

  • RE: Why do people need to do this?

    GilaMonster (1/18/2009)

    That's actually not that hard, providing it's impossible to have two sequential in's or out's and the first entry is going in.

    Is that ever the case though? =).

    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 18, 2009 at 1:16 pm

    #928960

  • RE: Opening & Closing Stock Problem

    In addition to what Steve has requested, please see the article in my signature on how to provide sample data.

    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 18, 2009 at 11:57 am

    #928947

  • RE: How to display NULL value as zero value

    There's a mini debate of COALESCE vs. ISNULL going on in the concatenating NULL values thread. I believe the consensus is that ISNULL is in fact faster, but COALESCE...

    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 17, 2009 at 9:46 am

    #928694

  • RE: Need help to write sql statement

    He's just carrying forward the serial number whenever the DocumentID is 'H'. Easily solved by Running Totals.

    William, please observe the way I posted your sample data. Please duplicate...

    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 17, 2009 at 9:26 am

    #928690

  • RE: Common Mistakes in T-SQL

    PW (1/15/2009)

    I'll take a break from gnashing my teeth & swearing at the original coder to add my common mistake:

    Frequent use of DISTINCT to hide a fundamental design flaw and/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]

    January 15, 2009 at 3:13 pm

    #927758

  • RE: Common Mistakes in T-SQL

    Isn't the point of that whole debate that the optimizer can do what it wants? While the test code may demonstrate certain characteristics, is anyone certain that another query,...

    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 15, 2009 at 2:49 pm

    #927741

  • RE: Need to change type of result column.

    No problem Andy, glad we could help.

    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 15, 2009 at 2:19 pm

    #927715

  • RE: Common Mistakes in T-SQL

    It is my understanding that the only thing that it will hold true 100% of the time as far as that goes is a case statement. This issue has...

    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 15, 2009 at 1:29 pm

    #927684

  • RE: Need to change type of result column.

    What is the datatype of QuoteHrs.Item?

    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 15, 2009 at 1:25 pm

    #927677

Viewing 15 posts - 796 through 810 (of 1,473 total)