Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 5,590 total)

  • RE: How to Calculate Total Monthly time worked

    autoexcrement (12/9/2010)


    Wayne, yes, thank you. That explains it completely. So, using your example of a time "80101", the code would (working from the inside out) transform it thusly:

    80101 (original)

    10108 (reversed)

    10:108...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/30/2010)


    For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].

    Bummer... user group was locked out of their meeting place.

  • RE: Build date table

    kevin.l.williams (12/9/2010)


    Nils Gustav Stråbø (12/9/2010)


    64% got it right. Yeah, right!! How many cheated and ran the T-SQL code?

    I cheated and got it right!

    By the way, how many of you read...

  • RE: How to Calculate Total Monthly time worked

    autoexcrement (12/9/2010)


    1. Craig, can I have an autographed photo of your brain for Chistmas?

    2. This is totally cool. I'm trying to figure it all out. I think I'm doing pretty...

  • RE: Build date table

    While reading through this, I kept asking myself "What is the author trying to teach?". Unfortunately, I never did get a good answer to my question...

  • RE: Which data type don't accept "Blank Value"

    I have to admit - I had stopped watching this thread because of how obvious the answer was, and after seeing all the responses decided to peek in again. I...

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/8/2010)


    Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long.

    Okay, I've submitted it. It took so long...

  • RE: Convert Existing Live to Secondary in Log Shipping

    disable all connections on the (current) primary.

    perform a tail log backup.

    restore the tail-log backup on the primary with "no recovery"

    restore the tail-log backup on the secondary with "recovery"

    as previously mentioned,...

  • RE: Date Ranges

    How's this?

    DECLARE @RoomBookings TABLE(

    RoomType varchar(6),

    ArrDate DateTime,

    DepDate...

  • RE: Date Ranges

    ngreene (12/7/2010)


    DECLARE @RoomBookings TABLE(

    RoomType varchar(6),

    ArrDate DateTime,

    DepDate...

  • RE: join - on problem

    Like this?

    select nr_praktijk,

    naam_praktijk,

    jaar_k,

    kwartaal_k,

    ...

  • RE: Create index in table variable

    adonetok (12/6/2010)


    Once create a table variable, I need to insert huge data into it. I want to create index after inserting.

    You cannot run DDL statements on a table variable after...

  • RE: help me create UNIQUE Constraints

    To all posters: please read the original thread before responding, so that you get the whole picture.

    Edit: but I see the OP deleted the original post over there, and replaced...

  • RE: Job Scheduling

    Stefan Krzywicki (12/6/2010)


    I was worried that the more steps in a job, the shorter the stored job history.

    You could always increase the amount of saved rows in the job history.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/6/2010)


    I hate to make a special plea for help in The Thread, but could someone give me some advice here?

    Done.

    BTW, no harm in posting here for help in...

Viewing 15 posts - 2,176 through 2,190 (of 5,590 total)