Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • RE: Data conversion of linked sets

    Jonathan AC Roberts - Tuesday, November 13, 2018 5:13 AM

    Why doesn't it come up with: 
    45,27
    45,50
    45,45
    ?
    Can you provide your cursor solution so we...

  • RE: Data conversion of linked sets

    sgmunson - Monday, November 12, 2018 2:46 PM

    Why do this?  What's the bigger picture?

    We want to implement a master location and make...

  • RE: Checking a string for valid TSQL

    Thanks for the reply.

    Co-worker gave me this code so it seems that your solution or either of these work. Only problem is that they don't check for valid objects...

  • RE: Checking a string for valid TSQL

    Thanks for the reply.

    Sorry this is for 2008R2. 🙁

    That's new for 2012

  • RE: Request help with a query

    A) Its a single query (hardly long)

    B) This doesnt work for multiple vehicles

    C) What if there is a tie in duehours ?

    Just curious. Why do you say it doesn't...

  • RE: Find # of active days based on status records

    Very nice! It took me a while to get my head around using the row number functions to eliminate the consecutive 'same status' records.

    Thanks for the reply.

    andrewd.smith (4/30/2009)


    Here's an...

  • RE: Find # of active days based on status records

    Sorry about the confusion. Given the date range 1/1/2009 through 3/31/2009, how many days was each consumer active during that date range. Wayne's 'quirky update' technique above seems...

  • RE: Find # of active days based on status records

    Thanks for the reply. Wow, what an interesting article and technique. I can see how that might have a lot of uses. I never thought about the...

  • RE: Find # of active days based on status records

    Lynn Pettis (4/29/2009)


    Are you looking for the date range a customer was active, or are you asking how many days a customer was active given a specified data range?

    Number of...

  • RE: Database design and FK relationships

    Thanks all for the replies.

    It was an OLTP application. The DB was a bit unusual in that there were very few deletes. We (the DBAs) would...

  • RE: Database design and FK relationships

    Thanks for the reply. It's funny you would mention the application code handling it. That's exactly why I didn't add them in the first place. I had...

  • RE: Select Query problem

    TOP limits the number of rows returned by your query. Assuming there are less than 1000 rows returned by the first query without the TOP,then adding the TOP 1000...

  • RE: Trigger question

    Thanks. I was thinking only of the recursive trigger setting which only controls triggers calling themselves. I wasn't aware that the nested trigger setting could control this. ...

  • RE: Trigger question

    I'll see if I can fo this. Thanks

    RBarryYoung (3/28/2009)


    If you just merge the two triggers together, it will not trigger itself unless you have Recursive triggers enabled.

  • RE: Trigger question

    I'm not familiar with CONTEXT_INFO. I'll try it out. Thanks

    Florian Reischl (3/28/2009)


    Try to handle it with CONTEXT_INFO and a transaction.

    Within your DELETE trigger:

    -- ...

    BEGIN TRANSACTION

    SET CONTEXT_INFO 0x01

    -- do...

Viewing 15 posts - 1 through 15 (of 29 total)