Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 5,590 total)

  • RE: Discarding records whith date gaps

    Does this do it?

    WITH CTE AS

    (

    SELECT ID, clientID, enrolldate, exitDate, branchID,

    RN = ROW_NUMBER() OVER (PARTITION BY clientID ORDER BY exitDate DESC)

    FROM...

    November 2, 2010 at 2:48 pm

    #1245754

  • RE: testing value of a subquery in the SELECT clause

    buddy__a (11/2/2010)

    I think the derived table would create an even more complicated query since the query in the derived table would require and additional join to create a key field...

    November 2, 2010 at 1:55 pm

    #1245712

  • RE: 2 SELECT statements from one CTE

    SeanLange (11/2/2010)

    ... There are tons of people here willing to help.

    Are you looking at my picture and extrapolating? :-D;-):w00t:

    November 2, 2010 at 1:50 pm

    #1245706

  • RE: 2 SELECT statements from one CTE

    Learner1 (11/2/2010)

    Thanks but, I cannot use it in a subquery as I have to store the Level value in a variable and then have to add a LOOP to...

    November 2, 2010 at 1:49 pm

    #1245704

  • RE: Life Without a Net

    blandry (11/2/2010)

    So, when you want to know a veteran techie, just ask "Whats a BBS?" I wonder how many SQL Central devotees can answer that question!

    This is aging me,...

    November 2, 2010 at 1:09 pm

    #1245673

  • RE: Life Without a Net

    roger.plowman (11/2/2010)

    Face it, in the days before the internet systems were far less complex, it was *possible* to know just about everything there was to know about a system.

    Today? Not...

    November 2, 2010 at 1:07 pm

    #1245670

  • RE: testing value of a subquery in the SELECT clause

    How about moving the correlated subquery into a derived table that you join against (as already specified). If you use an INNER JOIN, if there are no matches then the...

    November 2, 2010 at 12:53 pm

    #1245660

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/2/2010)

    Roy Ernest (11/2/2010)

    Tail of Tropical Storm Tomas hit Curacao (My island) leaving 3 people dead, lots material damage, 280 mm of rain and lightning. We are expecting more...

    November 2, 2010 at 12:44 pm

    #1245656

  • RE: Are the posted questions getting worse?

    Roy Ernest (11/2/2010)

    Thanks for the wishes. So far it is ok. We are doing Ok. But if it rains tonight like it yesterday night, then we are all in deep...

    November 2, 2010 at 12:42 pm

    #1245651

  • RE: table variable inside a cursor

    Ninja's_RGR'us (11/2/2010)

    Craig Farrell (11/2/2010)

    Ninja's_RGR'us (11/2/2010)

    Even if it makes no difference here, it should read : IF Object_id('tempdb..#tmp') IS NOT NULL

    With tempdb.. missing you'll never have a hit on that id.

    Hmmmm....

    CREATE...

    November 2, 2010 at 12:26 pm

    #1245631

  • RE: Incorrect Row Delimiters

    Okay, then how about this. Don't worry about the delimiters yet... first load the file into a staging table. Go through this, counting the number of delimiters. If it's less...

    November 2, 2010 at 12:22 pm

    #1245628

  • RE: Daylight Savings Time

    george sibbald (11/2/2010)

    Gawd, there's always one. I did say I had never had any problems, which is true :-), and also true for the vast majority

    running every 10 seconds is...

    November 2, 2010 at 11:54 am

    #1245607

  • RE: Need a Help in Importing CSV file into DB

    David Burrows (11/2/2010)

    Ooops!

    Thanks Wayne, forgot about that in my haste. :blush:

    Actually, with the OP having close to 200 points, I would have assumed (s)he would have known what one...

    November 2, 2010 at 11:30 am

    #1245577

  • RE: Are the posted questions getting worse?

    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    November 2, 2010 at 11:21 am

    #1245570

  • RE: Query does not return data

    Are you sure that the dates are stored that way?

    Could they be 01/01/2000? (zero padded days/months)

    Or 01-01-2000? (zero padded days/months & different separator)

    or 01.01.2000? (zero padded days/months & different separator)

    or...

    November 2, 2010 at 11:16 am

    #1245567

Viewing 15 posts - 2,581 through 2,595 (of 5,590 total)