Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 7,429 total)

  • RE: Threads/Fibers

    Yea, that is pretty much it. I at one time was curious on trying fibers in a C++ app I was playing with and when I got to reading I...

    August 5, 2003 at 8:52 am

    #468677

  • RE: Threads/Fibers

    Ok, first read this from SQL BOL (2000 Updated)

    quote:

    Thread Pooling

    The Microsoft® SQL Server™ error log may display the message:

    The working thread limit...

    August 5, 2003 at 6:50 am

    #468631

  • RE: QOD 8-4-2003 Disagree with answer...

    quote:

    quote:

    Antares, I think you just tested the limit of the text column we have...

    August 5, 2003 at 6:05 am

    #468612

  • RE: QOD 8-4-2003 Disagree with answer...

    quote:

    Throw the question out!

    Why?

    August 4, 2003 at 11:24 am

    #468473

  • RE: QOD 8-4-2003 Disagree with answer...

    Ok looks to me like you may have tripped over the version. SQL Server 2000 as the text posted looks like from SQL Server 7 BOL. As for how to...

    August 4, 2003 at 10:04 am

    #468458

  • RE: need help with COUNT

    quote:

    In addition to SQLBill's observation you are also grouping by mor columns than you are selecting. Try this

    August 1, 2003 at 7:23 am

    #468196

  • RE: QOD 1/8/03 (or is it 8/1/03?)

    I agree thou that the ISO format yyyymmdd should be used in questions as there are various reasons why this doesn't cause issues. I hadn't htought about it before myself...

    August 1, 2003 at 5:36 am

    #468175

  • RE: Hot Fix gotcha

    Figures they forgot to make that an error. hate hot fixes more than anything. These things happen so often in Hotfixes you think they would have a script to...

    August 1, 2003 at 5:02 am

    #468169

  • RE: cursor fetch into question

    No there (at this point) is nothing like it based on your statement.

    However, if you can post the code we might see an alternate solution. Also post the table DDL...

    August 1, 2003 at 4:59 am

    #468167

  • RE: Simple Math function

    quote:

    If col1 is key to table1 and it is in ascending order always then you can use construct similar to following

    SELECT a.COL1,(SELECT...

    August 1, 2003 at 4:54 am

    #468164

  • RE: Crystal Reports......

    Depends on your version of Crystal but yes you can set the query via code to any valid SQL syntax for the connection object you are using. I always make...

    August 1, 2003 at 4:41 am

    #468162

  • RE: Wrong Data

    The biggest problem is the complexity of the query you have to build and the fact we have no idea what your tables look like or the data in them....

    August 1, 2003 at 4:34 am

    #468161

  • RE: Getting a stored procedure output into VC++

    Can you post you C++ code so I have an idea what you have done so far? Thanks

    August 1, 2003 at 3:59 am

    #468155

  • RE: DATETIME datatype

    quote:

    Philip, I took some time and tested your function against DateDiff-DateAdd.

    CREATE FUNCTION dbo.fnDateOnlyBinary

    (@Date datetime)

    returns datetime

    AS

    BEGIN

    RETURN cast(substring(cast(@date as binary(8)),1,4) + 0x00000000 as...

    August 1, 2003 at 3:57 am

    #468154

  • RE: UDF in 7.0

    quote:

    ,

    some s/w he uses run on 7.0 and they have no plans to upgrade them.

    there goes my last hope...

    August 1, 2003 at 3:51 am

    #468153

Viewing 15 posts - 2,626 through 2,640 (of 7,429 total)