Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 6,036 total)

  • RE: T-Sql rant

    Bruce W Cassidy (3/22/2009)

    Sergiy (3/22/2009)

    And believe me, mapping of SourceSystem+OriginalID to InternalID works perfectly.

    No service required.

    [font="Verdana"]Heh. Not when you have an enterprise architect who insists that the appropriate...

    March 22, 2009 at 5:55 pm

    #964204

  • RE: T-Sql rant

    Bruce W Cassidy (3/22/2009)

    [font="Verdana"]For a real world scenario, can I suggest you consider world-wide logistics? Say you have sites around the world generating shipping bills (bills of lading?), but...

    March 22, 2009 at 2:40 pm

    #964174

  • RE: How to get top 10 records sum gropued by One colum (USERID)

    John, it's all so cool, but nothing's gonna work in SQL2000.

    Sorry.

    March 20, 2009 at 4:59 pm

    #963851

  • 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 4:14 pm

    #963843

  • RE: Format elapsed time

    Michael Valentine Jones (3/19/2009)

    You will have to decide what to do in cases where the elapsed time is more than 99 hours. This code will truncate the hours at...

    March 19, 2009 at 7:54 pm

    #963276

  • RE: T-Sql rant

    Bruce W Cassidy (3/19/2009)

    [font="Verdana"]Why did I recommend GUIDs?

    A few years back I was involved in a project that had to synchronise data from multiple sources into one source. The...

    March 19, 2009 at 7:50 pm

    #963274

  • RE: T-Sql rant

    J (3/19/2009)

    Also, you should use the GUID as a last resort. I saw something about that being more prone to index fragmentation requiring the comparison of 38 characters instead of...

    March 19, 2009 at 7:22 pm

    #963257

  • RE: T-Sql rant

    foxjazz (3/19/2009)

    Sergiy, as far as the bands. How could I use identity and keep with the rule of source bands.

    Where source 1 data must have pk numbers between 1...

    March 19, 2009 at 3:15 pm

    #963178

  • RE: T-Sql rant

    Bruce W Cassidy (3/19/2009)

    [font="Verdana"]One common business case for generating sequences is for invoice numbers. For some reason, customers like to see their invoice numbers being counted just for them....

    March 19, 2009 at 3:07 pm

    #963171

  • RE: T-Sql rant

    Greg Snidow (3/19/2009)

    Sergiy, the quote button is taking me to the wrong post, but you said

    Except varchar as PK adds extreme overhead for data processing.

    in your last post. Do...

    March 19, 2009 at 2:50 pm

    #963159

  • RE: T-Sql rant

    foxjazz (3/19/2009)

    When our users populate this data, they need to put it in a sequence.

    Why?

    We use the sequence to publish the data.

    I believe

    pipe1 1

    pipe1 2

    pipe1 3

    will be...

    March 19, 2009 at 2:26 pm

    #963130

  • RE: T-Sql rant

    foxjazz (3/19/2009)

    Business case for identity insert not being in a couple of my important tables. The reason is that I have used bands of identities, and certain types of data...

    March 19, 2009 at 2:09 pm

    #963108

  • RE: T-Sql rant

    And talking about syntax inprovements in SQL 2k5 and 2k8 I'd say it's not good at all.

    By introducing comfort of procedural programming in stored procedures MS invites developers to move...

    March 18, 2009 at 11:16 pm

    #962481

  • RE: Avoiding injection on stored procedure

    How about this:

    [dbo].[USPDeleteAnswers] 'xxx','1,3,5) or 1=1--'

    March 18, 2009 at 9:59 pm

    #962465

  • RE: T-Sql rant

    Bob Hovious (3/18/2009)

    Jeff, I warned Fox he would hear about triangular joins one day.

    Let us get the man weaned off cursors first !! 😉

    Guys, I'm...

    March 18, 2009 at 9:41 pm

    #962460

Viewing 15 posts - 2,581 through 2,595 (of 6,036 total)