Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,473 total)

  • RE: Retrieving Bulk of Records using Select Keyword

    RBarryYoung (12/24/2008)

    Yes, like Seth, I suspect the transmission time. It's either your network or your Client that is too slow for that much data, not your SQL Server.

    I was...

    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]

    December 24, 2008 at 8:55 am

    #917440

  • RE: After INSERT/UPDATE Trigger - Getting old values?

    Thanks for the mapping, and well done on anticipating it =)

    This is more or less what your trigger should look like. Keep in mind that triggers like this should...

    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]

    December 24, 2008 at 8:42 am

    #917433

  • RE: After INSERT/UPDATE Trigger - Getting old values?

    Looking into it.

    First few questions:

    Is the ScheduleID *changing* on an update to ptSchedule?

    What is the primary key on ptSchedule?

    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]

    December 24, 2008 at 7:58 am

    #917401

  • RE: After INSERT/UPDATE Trigger - Getting old values?

    Whatever, Hax Corbett.

    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]

    December 24, 2008 at 7:42 am

    #917393

  • RE: After INSERT/UPDATE Trigger - Getting old values?

    Whoa... we tied... and it still put yours first. Hax.

    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]

    December 24, 2008 at 7:29 am

    #917383

  • RE: After INSERT/UPDATE Trigger - Getting old values?

    Variables in a trigger are something that should be avoided as much as possible. Your trigger will only work for 1 row. Triggers are fired once per operation,...

    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]

    December 24, 2008 at 7:28 am

    #917381

  • RE: Retrieving Bulk of Records using Select Keyword

    Why would you need to display 300,000 rows in a crystal report? Who is going to go through that much data? This is starting to seem like a...

    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]

    December 24, 2008 at 6:38 am

    #917350

  • RE: Retrieving Bulk of Records using Select Keyword

    Seems to me that most of that time is just the client trying to display that much data. Why would you need to return 300,000 rows of data 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]

    December 23, 2008 at 10:27 pm

    #917221

  • RE: SQL Help in populating a table

    Vladan (12/23/2008)

    SELECT 'Happy ' + h.holiday_name + ' !'

    FROM holidays h

    WHERE h.culture_id = @yourculture

    AND h.start_date BETWEEN '20081223' AND '20090101'

    ORDER BY h.date

    LOL, that's awesome. Geek Humor rocks. :hehe:

    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]

    December 23, 2008 at 7:56 am

    #916762

  • RE: call stored procedure from trigger

    Hmmm. in that case SP will be fired only for first row. if firing an sp is absolutely required for each inserted row, cursor will be needed. Any alternative 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]

    December 23, 2008 at 7:15 am

    #916746

  • RE: How to Merge the data from different table into one table

    You're going to have to be a lot more specific on your setup... and your reasons for wanting to do this. Do all the tables hold the same 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]

    December 23, 2008 at 7:08 am

    #916743

  • RE: Stopping Loop when Using tally table loop for date ranges in stored procedure

    This thread is a continuation of : http://www.sqlservercentral.com/Forums/Topic616449-338-1.aspx

    Sorry Akzsurtep, I missed your last reply.

    So, you have your table of Start and End Dates. I don't understand why you've turned...

    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]

    December 22, 2008 at 12:09 pm

    #916306

  • RE: SQL Help in populating a table

    Depending on what you're going to do with that column, you could do it in many ways.

    Here are a couple:

    Trigger on the table with criteria on when to restart 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]

    December 22, 2008 at 9:18 am

    #916219

  • RE: Temp Table Existance

    hefterr (12/22/2008)

    Hi,

    I a a newbie so please so I appologize if this is an obvious question.

    How does one define the length or scope that a temp table (#mytemp) will exist....

    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]

    December 22, 2008 at 9:06 am

    #916210

  • RE: CASE Statement in WHERE Clause

    That makes a bit more sense. Just use something like this instead of an overly complicated case statement:

    WHERE

    ...

    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]

    December 22, 2008 at 8:57 am

    #916205

Viewing 15 posts - 856 through 870 (of 1,473 total)