Forum Replies Created

Viewing 15 posts - 511 through 525 (of 1,473 total)

  • RE: Rowcount for subset of data in temp table

    Definitely worth including. No need to be embarrassed that your code isn't perfect; we all start somewhere. We may need sample data as well (see the article 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]

    October 16, 2009 at 10:34 am

    #1067040

  • RE: SELECTing values on different records based on rules

    Jonathan Melo (10/16/2009)

    I despise cursors myself. When I'm really, really stuck to go row by row, I use a WHILE construct with a key instead. Somewhere, in my head, 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]

    October 16, 2009 at 10:29 am

    #1067038

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    Are you saying that they are going to delete single values from those columns or they are literally deleting the entire column so that it won't exist in the table...

    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 16, 2009 at 9:01 am

    #1066969

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    We need a delete trigger

    This indicates to me that your original concept of a delete trigger was correct. You don't need an 'update' trigger which is what you'd need...

    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 16, 2009 at 8:52 am

    #1066955

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    You didn't answer the question. What is the end goal? What are you using the schema2 table for? What purpose is it intended to serve? What...

    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 16, 2009 at 8:39 am

    #1066940

  • RE: Query: Joining a record chronoligical with the next record from the table

    The new column(s) do not need to be added to the index, they just allow you to use this method without creating a temporary table. I've given you two...

    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 16, 2009 at 8:30 am

    #1066932

  • RE: Top queries

    Take a look at the article in my signature on cross tabs. If you need more help writing the code, please post table definitions and sample data according 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]

    October 16, 2009 at 8:08 am

    #1066907

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    That's not a little change.

    What is the real goal here? It seems like auditing to me. You want to track historical values in your table. There are...

    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 16, 2009 at 8:06 am

    #1066903

  • RE: SELECTing values on different records based on rules

    Jonathan Melo (10/16/2009)

    First, Garadin, I'd like to thank you a lot for the effort you're putting in this problem. It looks like you went through a lot of trouble 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]

    October 16, 2009 at 8:00 am

    #1066892

  • RE: Query: Joining a record chronoligical with the next record from the table

    Excellent, thanks Tim, I'll whip something up for you in the morning. Is adding a field to the table an issue? Ordinarily, I'd do without, but it looks...

    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 16, 2009 at 12:15 am

    #1066692

  • RE: Query: Joining a record chronoligical with the next record from the table

    Thanks for providing what you've already tried. Take a look at the article in my signature on Running Totals. I believe this to be the perfect method 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]

    October 15, 2009 at 6:44 pm

    #1066648

  • RE: SELECTing values on different records based on rules

    So I thought about it for a while, this is what I came up with. I'll state up front that I can already see half a dozen ways 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]

    October 15, 2009 at 4:03 pm

    #1066613

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    Yes.

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

    #1066467

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    rahulsony111 (10/15/2009)

    I am not inserting those 4 rows cause they are already in the Schema2.DIMCNAM

    I am just leaving them as it is. I dont have to bother about future 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]

    October 15, 2009 at 1:04 pm

    #1066456

  • RE: SQL SERVER 2000 EQUIVALENT OF SQL SERVER 2008 TIME DATATYPE

    There is no direct equivalent. Which way you should go is determined by what you need to do with it. Pass the date along with it from 2008...

    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 15, 2009 at 12:35 pm

    #1066440

Viewing 15 posts - 511 through 525 (of 1,473 total)