Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 1,473 total)

  • RE: Removing partially duplicate records in SQL

    And if you have something like:

    1 A B C

    2 A D...

    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]

    October 14, 2008 at 10:51 pm

    #885015

  • RE: Help needed in removing dynamic SQL

    FNS

    Personally I think on the whole it's done out of laziness and sloppy coding practices. I know that sometimes it's an invaluable tool but it shouldn't be used first...

    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]

    October 14, 2008 at 10:20 pm

    #885010

  • RE: Sending Advanced Mail in Sql Server 2005 Database Mail

    You'll need to use something like SSRS or Crystal Reports for that.

    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]

    October 14, 2008 at 9:58 am

    #884727

  • RE: Return all rows where one is a match

    I've prettymuch gotten nowhere with testing these different methods. They all show negligible differences

    in times, regardless of both the amount of data being used and the density 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]

    October 14, 2008 at 9:26 am

    #884704

  • RE: What does 2 periods after DB name mean?

    Yeah, all 3 of us assumed you did that =).

    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]

    October 14, 2008 at 7:42 am

    #884621

  • RE: What does 2 periods after DB name mean?

    Proper syntax is ServerName.Databasename.Owner.ObjectName. You are seeing DatabaseName..ObjectName and letting it automatically fill in the owner name, which either always attempts dbo, or attempts based on the current user...

    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]

    October 14, 2008 at 7:37 am

    #884613

  • RE: Convert rows into columns

    Please post the code that you attempted that did not work. Second, please post sample data / table inserts according to the link in my signature. Third, please...

    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]

    October 14, 2008 at 7:28 am

    #884604

  • RE: Stored Procedure to query many tables

    Is your end goal here to get the data into 1 table for the future, or simply to build a query that will read from these 44 (and ever growing)...

    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]

    October 13, 2008 at 7:02 pm

    #884382

  • RE: Help needed in removing dynamic SQL

    rbarryyoung (10/13/2008)

    Hmm, maybe I should write an article...:hehe:

    I was kinda hoping you'd come to that conclusion :P.

    We'll likely be generating a dynamic column list for the final select, as well...

    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]

    October 13, 2008 at 6:44 pm

    #884377

  • RE: Help needed in removing dynamic SQL

    rbarryyoung (10/13/2008)

    And injection is certainly a valid concern, but there are also ways protect yourself from it and still be able to use Dynamic SQL.

    I'm looking at having to use...

    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]

    October 13, 2008 at 1:24 pm

    #884314

  • RE: Return all rows where one is a match

    I've done some testing, not quite happy that I've covered it all yet, but I'll finish it up tonight when I get home. So far, a couple...

    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]

    October 13, 2008 at 12:09 pm

    #884290

  • RE: Nested SELECT

    This is a guess based on your above query. This may or may not return the correct results, as this is completely untested.

    [font="Courier New"]SELECT     Customers.CustomerName,

                   SalesOrders.SalesOrderId,

                   ProgressPayments.PaymentDate,

                   ProgressPayments.InvoiceValue AS...

    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]

    October 13, 2008 at 10:10 am

    #884254

  • RE: Return all rows where one is a match

    I wasn't really relying on the percentage of batch in this case, merely noting the differences. The thing that really makes no sense to me, and seems...

    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]

    October 13, 2008 at 9:24 am

    #884226

  • RE: Return all rows where one is a match

    Jeff Moden (10/13/2008)

    Garadin (10/12/2008)

    The execution plans are the same, but the percentages skew slightly. The join query has 235 reads as opposed to 156 for the IN. Unfortunately...

    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]

    October 13, 2008 at 8:28 am

    #884172

  • RE: Start and End Date Groupings

    Could you post some sample data / table defintions that we can run?(See the link in my signature for an example if you don't know what I mean by this)...

    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]

    October 13, 2008 at 5:59 am

    #884100

Viewing 15 posts - 1,381 through 1,395 (of 1,473 total)