Forum Replies Created

Viewing 15 posts - 47,266 through 47,280 (of 59,064 total)

  • RE: Nested Transactions - Best Practice

    Adam, thanks for not only the explanation of what your trigger does and why DRI isn't going to do it for you, but also the trick you came up with...

    November 12, 2008 at 5:47 pm

    #897851

  • RE: Normalizing-Denormalized Tables

    Ed Klein (11/12/2008)

    Can we see the code for the function, Ed, or are you just saying that it would be nice to have one?

    --Jeff Moden

    I'm just saying it would be...

    November 12, 2008 at 5:33 pm

    #897848

  • RE: Fix the Little Things

    majorbloodnock (11/12/2008)

    Thing is, MS don't need to do this kind of stuff. If there's a market, someone will write a utility that does all these "little things". If there's sufficient...

    November 12, 2008 at 6:28 am

    #897463

  • RE: how find the missing value from a range of value

    Heh... mine too... I copied it from a gap detecter that I had in my library. It's some really ugly code with the correlated sub-query and all, but it's...

    November 12, 2008 at 6:19 am

    #897457

  • RE: Would pivot work here?

    Brandie Tarvin (11/12/2008)

    Jeff Moden

    Ggraber has the right idea

    Possibly, but his code is interupted by the forum turning part of it into a smiley face, which means I get a...

    November 12, 2008 at 6:15 am

    #897456

  • RE: Normalizing-Denormalized Tables

    Very cool... I didn't know about the product. Thanks.

    November 12, 2008 at 6:11 am

    #897454

  • RE: Normalizing-Denormalized Tables

    Mohit (11/11/2008)

    Hi Jeff,

    I was planning to create 5 databases, each with different number of records. One with the original 30, second with 300, 3rd with 1000,...

    November 11, 2008 at 11:48 pm

    #897352

  • RE: Storing Negative Numbers

    Lynn Pettis (11/11/2008)

    Jeff Moden (11/11/2008)

    Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. Seems like the last...

    November 11, 2008 at 11:46 pm

    #897351

  • RE: How To utilize log files

    Restoring part of the log will get the proc back?

    November 11, 2008 at 11:44 pm

    #897350

  • RE: Cannot convert nvarchar datatype to int error

    Lynn Pettis (11/11/2008)

    If it is an 'I' then 0 else 1.

    Jeff, been try to help him, but we can't even get him to help himself. I have pointed him...

    November 11, 2008 at 11:38 pm

    #897347

  • RE: Fix the Little Things

    Heh... you already know the answer to this, Steve... flash and time to market drive everything. No time to think about such useful things... there's a shedule to meet!...

    November 11, 2008 at 10:31 pm

    #897339

  • RE: how find the missing value from a range of value

    Actually, there's a faster method than the Tally table for this...

    SELECT TOP 1 (SELECT ISNULL(MAX(b.SerialNumber),0)+1

    ...

    November 11, 2008 at 10:02 pm

    #897327

  • RE: Cannot convert nvarchar datatype to int error

    paul.starr (11/11/2008)

    it works but error is:

    Conversion failed when converting the nvarchar value 'A' to data type int

    So... what do you think an 'A' should convert to when converting to an...

    November 11, 2008 at 9:46 pm

    #897320

  • RE: How To utilize log files

    Anu (11/11/2008)

    Hi Sql Server's,

    Here the scenario like this , i am using a stored proc that contains some functional business logic ,here i didn't took the backup script and start...

    November 11, 2008 at 9:44 pm

    #897319

  • RE: Need help with a while and cursor

    SQL DBA 808 (11/11/2008)

    Steve T: Yes. That's very close to what I need to do. Thank you.

    Garadin: I will read that and see if I can...

    November 11, 2008 at 9:42 pm

    #897318

Viewing 15 posts - 47,266 through 47,280 (of 59,064 total)