Forum Replies Created

Viewing 15 posts - 856 through 870 (of 962 total)

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/2/2013)


    SQLRNNR (4/2/2013)


    jasona.work (4/2/2013)


    You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

    I've got two logins, one for "normal"...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/13/2013)


    Dave Ballantyne (2/13/2013)


    rodjkidd (2/13/2013) Remember stitting there with a bad, bad hangover, just hoping I didn't throw up πŸ™‚

    That sums up the sqlbits experience πŸ˜‰

    God I hope not....

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/13/2013)


    Cadavre (2/13/2013)


    So, the SQL Bits agenda has been released, anyone going? I'm planning on grabbing a Friday ticket tomorrow morning, but unsure about the Saturday.

    I'm presenting on Saturday....

  • RE: Transactions in T-SQL

    Godd Question.

    I did a big oops though, missed the first insert before the loop, so my second count was always out. Must rememeber to drink cofee before QOD...

    Rodders...

  • RE: Adding record to db using stored procedure and identity counter.

    Just noticed you said you test environment is 2005

    You have to split up the declare and assign of the @newlVal variable.

    So

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

    BEGIN TRANSACTION;

    DECLARE @NewVal BIGINT;

    SELECT @NewVal =...

  • RE: Fantasy football 2012

    Oh wow!

    I was a bit busy last week and away for the weekend...

    And I got a win! By the narrowest of margins!

    I don't fancy my chances this week though πŸ™

    Rodders...

  • RE: Fantasy football 2012

    roryp 96873 (9/13/2012)


    Make sure your lineups are set, there is a game tonight at 8 ET.

    Well I guess I can't get any worse based on that...

    Rodders...

  • RE: Fantasy football 2012

    Okay.

    I can't do the live draft tonight due to being at a gig. I've saved my picks but I don't really know what happens now as I can't be there...

  • RE: Fantasy football 2012

    Ray K (8/31/2012)


    rodjkidd (8/30/2012)


    I'm at a gig so will no doubt be on the road driving back at that time.

    You a musician? What do you play?

    I play keyboards and...

  • RE: Fantasy football 2012

    Yep looks like a midnight start for "us Brits"

    I'm at a gig so will no doubt be on the road driving back at that time.

    My guess is I'll be back...

  • RE: Fantasy football 2012

    Righto,

    I have no idea what happened on Saturday. I did everything I needed to. !!

    Just repeated the steps, picked the same team name etc. Looks as though it worked this...

  • RE: Fantasy football 2012

    Is it me by any chance?

    I thought I sorted this on Saturday, sorted out a team etc. Put in the league code.

    I'll check tonight and make sure I've been added...

  • RE: Basic of T-SQL

    Gazareth (8/20/2012)


    Toreador (8/20/2012)


    Currently 15% of people think that Count(columnname) on a 7-row table will return a value of 10 πŸ˜‰

    In fairness to them, it is Monday morning... πŸ˜€

    As it was...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/14/2012)


    L' Eomot InversΓ© (8/14/2012)


    Off to Sri Lanka tomorrow, to attend eldest son's wedding. The evil child has insisted I be kilted for the event, and I can...

  • RE: BIT Conversions

    Doh!

    Good question, my bad for missing the as True/ 1 part. I knew they would all insert correctly...

    Must remember to read question after having coffee!

    Rodders...

Viewing 15 posts - 856 through 870 (of 962 total)