Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Identity reused problem

    If I move the database into another server, also the identity wont be reused???

  • RE: RECURSIVE PROCEDURE help!

    I did the level number.

    But the indexing is still a problem cause it depends on index of parent in case it's a first child and depends on index of previous...

  • RE: RECURSIVE PROCEDURE help!

    i modified my procedure to do it without recursion as follows.But now how do i set the level,index numbers?

    parent 1 : level= 1, index=1

    child of parent 1(C1) :...

  • RE: Help master detail trigger

    NO join is not a solution. join might give wrong records. The same order id 10 might be updated several times...

  • RE: help trigger

    And if i need all data from deleted, then what???

  • RE: help trigger

    I would've liked to use For Delete trigger but i can't since there are text columns in the table. And i...
  • RE: help text query

     It's ok. ISNULL function has all the solution for me. I had forgotton all about it. ISNULL works great in my...
  • RE: help text query

    what do i do if my text goes over 8000? which will probably do. ???????////

  • RE: help query

    Well basicly this is my query but it isn't working. It is arriving to sender 2, 4 and 1 while it...

  • RE: help query

    Well basicly this is my query but it isn't working. It is arriving to sender 2, 4 and...

  • RE: help query

    What i mean by 10 times consecutively is that a certain controller shouldn't be sent to the same region 10 times...
  • RE: help query

    First, controller ID is the primary key so the join must be on controller ID.

    Suppose that is done, what about the...

  • RE: Which better?

    well it is definite that no attributes other than filePath and fileID will be added. That's why i was wondering if...

Viewing 13 posts - 1 through 13 (of 13 total)