Forum Replies Created

Viewing 15 posts - 226 through 240 (of 1,473 total)

  • RE: What SQL or Stored Procedure is Running? SS2K

    dbcc inputbuffer should not be returning trigger code. fn_get_sql will, but DBCC Inputbuffer should not.

    Are you sure you're seeing that function's result and not the other one?

    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]

    March 31, 2010 at 8:08 am

    #1143100

  • RE: Help with a T-SQL Script

    Reposted to SS2K5 Forum, no more replies here please.

    New Thread

    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]

    March 30, 2010 at 12:40 pm

    #1142574

  • RE: What SQL or Stored Procedure is Running? SS2K

    Not a problem at all Tom. Does DBCC INPUTBUFFER not return the data you are looking for? If you're looking for the statement right before the trigger 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]

    March 30, 2010 at 11:36 am

    #1142499

  • RE: Removing Blank Fields

    Spoke too soon, yes it does, my fault:

    DECLARE @Example

    TABLE (

    field1 VARCHAR(30) NULL,

    ...

    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]

    March 30, 2010 at 9:02 am

    #1142311

  • RE: Removing Blank Fields

    It doesn't when I run Paul's Code:

    DECLARE @Example

    TABLE (

    field1 VARCHAR(30) NULL,

    field2...

    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]

    March 30, 2010 at 9:00 am

    #1142308

  • RE: STORED PROCEDURE ERROR

    Sometimes it's the little things ;-).

    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]

    March 30, 2010 at 8:49 am

    #1142292

  • RE: STORED PROCEDURE ERROR

    Get rid of the 'GO' after the table creation.

    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]

    March 30, 2010 at 8:42 am

    #1142281

  • RE: Insert - Exec Select statements

    Are you aware you're selecting out of a different table than you're dropping/creating/populating?

    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]

    March 30, 2010 at 8:18 am

    #1142249

  • RE: Order By IsNull

    Thanks for solving that mystery Sergiy. That woulda bugged me for weeks.

    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]

    March 29, 2010 at 10:39 pm

    #1141946

  • RE: equivalent of DateSerial() in T-SQL? (SQL2000)

    Ian Yates (12/9/2005)

    3ms is the smallest unit of time a datetime field can capture. So by subtracting 3ms from midnight, you get the latest possible time that could be captured...

    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]

    March 29, 2010 at 10:38 pm

    #1141945

  • RE: What SQL or Stored Procedure is Running? SS2K

    Heh, ok, I don't know what I was thinking when I linked that. I guess I should have actually tested that first. That code was all wrong, I...

    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]

    March 29, 2010 at 4:40 pm

    #1141813

  • RE: Is there a better way.

    douglas.allison-1136597 (3/29/2010)

    Hi Greg

    Thanks for that the formatting is not the messy part as when I see it on Manager ets it's all tastefully indented etc.

    Will have a look laters at...

    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]

    March 29, 2010 at 10:59 am

    #1141579

  • RE: Cross database execution

    Ordinarily, I'd have said that Dynamic SQL would likely have fixed the issue, but you can't use that within your function. I think you're on the right track with...

    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]

    March 29, 2010 at 9:49 am

    #1141526

  • RE: Order By IsNull

    It's an order of operations thing. If you look at the execution plans, the sort doesn't come until after the compute scalar. Removing the order by, removing 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]

    March 29, 2010 at 9:43 am

    #1141521

  • RE: What SQL or Stored Procedure is Running? SS2K

    My pleasure Tom, glad I 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]

    March 28, 2010 at 1:12 pm

    #1141127

Viewing 15 posts - 226 through 240 (of 1,473 total)