Forum Replies Created

Viewing 15 posts - 1 through 15 (of 51 total)

  • RE: What is the result ? (SQLServer 2005)

    Ian Elliott (9/11/2008)

    I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.

    I agree,...

  • RE: What is the result ? (SQLServer 2005)

    ALZDBA (9/10/2008)


    Keep in mind SSMS has some issues with e.g. char(13) resulting in a "syntax error near ...."

    And off course you'll need to have the default 'go' for batch...

  • RE: Simulating memory pressure

    Christian Buettner (9/1/2008)


    If I had known that Hugo is the author of the QOTD, I would have chosen the correct answer.

    So how about including the author in the QOTD description?...

  • RE: DB File Extension

    Michael Kipp (8/28/2008)


    Please don't confuse "database files" with "data files".

    A database is more than just a data file.

    According to the link provided with the QOD, .mdf, .ndf and .ldf all...

  • RE: Counts Puzzle

    dgvsbabu (8/28/2008)


    It should be 1,5,2,3,3,2

    I don't think it should be, can you explain why?

  • RE: Counts Puzzle

    Aleksandr Furman (8/27/2008)


    skyline666 (8/27/2008)


    Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).

    That's...

  • RE: Creating Databases

    I don't know if its just me or not, but the picture's aren't there. Good article by the way.

  • RE: Counts Puzzle

    Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).

  • RE: Counts Puzzle

    YeshuaAgapao (8/26/2008)


    You forgot to put drops for you temp tables (#data, #category) at the end of the code block.

    That doesn't affect the end result tho ;).

  • RE: allow varchar value to string and decimal parts

    Thats good saurabh.k.singh.

    May I suggest that if you changed the declaration @NumPart from int to float, and @AddNum from int to float, then you will be able to add decimal...

  • RE: Counts Puzzle

    Round yours at 6 then 😀

  • RE: Insert records into ADP Access 2003 ListView

    That points to vb.net, whereas im using vb6 :). I had solved it before, was really simple actually:

    Private Sub lstRiskDescription_Click()

    Me.RiskID = Me.lstRiskDescription.SelectedItem

    End Sub

    Ive come to...

  • RE: Counts Puzzle

    ian treasure (8/26/2008)


    Shouldnt this be

    SELECT C.CATID, COUNT(*)

    FROM #DATA DINNER

    JOIN #CATEGORY C ON (C.VAL1 = DINNER.VAL1) OR (C.VAL1 IS NULL)

    GROUP BY C.CATID

    (was ON C.VAL1 = D.VAL1)

    Nope, its this:

    SELECT C.CATID,...

  • RE: Insert records into ADP Access 2003 ListView

    Actually I do have one more query. I have an unbound text box on the form the listview is on, and when I click an item in the listview,...

  • RE: Insert records into ADP Access 2003 ListView

    Solved it. You need to have column headers set up, so that you can actually put data into that column, who'd of thought it :hehe:!. There is an...

Viewing 15 posts - 1 through 15 (of 51 total)