Forum Replies Created

Viewing 15 posts - 21,856 through 21,870 (of 26,490 total)

  • RE: T-Sql rant

    I just think a discussion of Dataphor should be separate and distinct from this rant which did start as a discussion regarding the shortcomings of T-SQL, but really were more...

    March 22, 2009 at 9:49 pm

    #964235

  • RE: T-Sql rant

    Bob Hovious (3/22/2009)

    Don't hijack it like you guys did with the "increment" discussion, Lynn? 😉

    I agree. In fact I think I may have even said that it too...

    March 22, 2009 at 9:42 pm

    #964234

  • RE: T-Sql rant

    steve dassin (3/22/2009)

    Steve Jones - Editor (3/15/2009)

    ...C#, VB, etc. are programming languages designed for working with a variables, of sets of variables in objects.

    How do you realize a result of...

    March 22, 2009 at 8:56 pm

    #964224

  • RE: T-Sql rant

    We also need the proper "business" scenario. Could be something based on our past experience or something similiar. I guess we should come up with some ideas.

    March 21, 2009 at 9:18 pm

    #964064

  • RE: T-Sql rant

    Jeff Moden (3/21/2009)

    Sure... well, maybe except for the article thing. I was thinking that the idea of using a sequence table correctly would make a good article right after...

    March 21, 2009 at 4:05 pm

    #964027

  • RE: T-Sql rant

    Jeff Moden (3/21/2009)

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    If you did it your way, which numbers would be reserved if you needed 100 numbers as the increment?

    You know, I was looking at...

    March 21, 2009 at 3:02 pm

    #964020

  • RE: T-Sql rant

    Jeff Moden (3/20/2009)

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something...

    March 20, 2009 at 10:18 pm

    #963915

  • RE: T-Sql rant

    Jeff Moden (3/20/2009)

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial...

    March 20, 2009 at 5:04 pm

    #963853

  • RE: T-Sql rant

    Jeff Moden (3/20/2009)

    Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

    UPDATE NextID

    ...

    March 20, 2009 at 3:47 pm

    #963827

  • RE: use of Curser to purge data+sql server 2005

    Richard Fryar (3/20/2009)

    Lynn,

    Beware the typo. You put 365 instead of -365.

    snehal.gamaji.career,

    Create a clustered index and go with Lynn's suggestion. Your WHERE clause is not SARGable, and will perform...

    March 20, 2009 at 1:56 pm

    #963768

  • RE: T-Sql rant

    foxjazz, I hope you leave this thread with more than just the knowledge we tried to impart. I hope you have also learned that there are quite a few...

    March 20, 2009 at 1:50 pm

    #963762

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/20/2009)

    Derek Dongray (3/20/2009)

    It looks like The Rant has run its course.

    And from his description of his setup (sync software + 3 application tools + 5 databases), I don't...

    March 20, 2009 at 1:41 pm

    #963757

  • RE: T-Sql rant

    From what I can tell the mistake is already made. The question is CAN they fix it up or would it require a rewrite of their software system. ...

    March 20, 2009 at 2:10 am

    #963356

  • RE: T-Sql rant

    Jeff Moden (3/19/2009)

    foxjazz (3/19/2009)

    I think this is the query I arrived at for getting the next PK value.

    select @currentval = max(Convert(int,substring(GenLevelAddFieldID,len(@@servername) + 1,10))) from tblLevelAddFieldRel where GenLevelAddFieldID like @@servername...

    March 19, 2009 at 8:21 pm

    #963280

  • RE: Are the posted questions getting worse?

    Derek Dongray (3/19/2009)

    Lynn Pettis (3/19/2009)

    Whoa! I think we had an epiphany!!! From The Rant:

    foxjazz (3/19/2009)

    Lynn, you have completely and utterly convinced me to look for a set based...

    March 19, 2009 at 8:12 pm

    #963278

Viewing 15 posts - 21,856 through 21,870 (of 26,490 total)