Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 3,544 total)

  • RE: Loose the pagination

    For Active Topics, I agree.

    Far away is close at hand in the images of elsewhere.
    Anon.

    January 5, 2004 at 6:14 am

    #488646

  • RE: .

    ..-. --- - ..-. .-..

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 24, 2003 at 5:56 am

    #487727

  • RE: How to cut off error message when inserting data. 

    DECLARE @rval int 

    EXEC @rval = sp_helprotect @username=@UserName

    @rval will be 0 if worked otherwise 1

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 24, 2003 at 3:39 am

    #487719

  • RE: using grouping 

    SUM(CASE WHEN cbostatus <> 'closed' THEN 1 ELSE 0 END) as [Num Requests Open]

    Will give you the count of open requests

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 24, 2003 at 3:20 am

    #487718

  • RE: using grouping

    I'm getting confused on what the problem is now. This query is based on your original plus 'All' in front of Team for Team totals and the data is ordered...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 23, 2003 at 10:43 am

    #487643

  • RE: using grouping

    Try this

    select case when (GROUPING(ddtreasuryteam) = 1) THEN 'All Requests' 

    ELSE isnull(ddtreasuryteam, 'n/a') END as Team, 

    case when (GROUPING(CBOSTATUS) = 1) THEN 'Total Received' 

    else...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 23, 2003 at 9:15 am

    #487622

  • RE: using grouping

    Try changing the first part of the select to

    select case when (GROUPING(ddtreasuryteam) = 1) THEN 'All Requests' 

    else isnull(case when (GROUPING(CBOSTATUS) = 1) THEN 'All...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 23, 2003 at 3:31 am

    #487561

  • RE: SP Problem With VB6

    quote:

    If possible I would avoid using the ADO Command.Refresh statement because it has a noticeable performance hit.

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 23, 2003 at 2:22 am

    #487548

  • RE: T-SQL Datetime Problem

    When designing a table, if a column is going to contain a date then I automatically make it datetime. There are a lot of pros and cons on what dataype...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 23, 2003 at 2:17 am

    #487547

  • RE: SP Problem With VB6

    It is the RETURN value of the stored procedure. Every SQL Server stored procedure has this parameter (whether it is explicitly used or not).

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 22, 2003 at 5:28 am

    #487398

  • RE: T-SQL Datetime Problem

    If you want to remove the time portion from input dates then cast them to varchar(11). Is this the whole procedure? The reason I ask is that I question the...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 22, 2003 at 2:47 am

    #487390

  • RE: variable tablename in cursor select stmt

    The problem is that your table names are in a table and that is why you are using cursors.

    How many 'Volume_Control.tblFilenames_' tables are there and what size are they (rows)....

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 19, 2003 at 8:08 am

    #487222

  • RE: variable tablename in cursor select stmt

    Change the cursor2 declare to this

    declare @sql nvarchar(4000)

    set @sql = '

    DECLARE cursor2 CURSOR 

    GLOBAL

    DYNAMIC 

    FOR

    SELECT sum(file_size_bytes) , Lseries from ' + @filename + ' group...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 19, 2003 at 6:33 am

    #487197

  • RE: 20 % records

    Ah! Thought so when I looked at the code as it did not look like traditional sql server.

    Unfortunately I have not used Oracle and cannot help you, maybe someone else...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 19, 2003 at 2:29 am

    #487159

  • RE: How to test DOS "file in use" status?

    Could use fso but would have to trap errors

    DECLARE @fso int 

    DECLARE @hr int 

    DECLARE @file int 

    DECLARE @iomode int 

    DECLARE @filename varchar(255) 

    

    SET @filename...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 18, 2003 at 10:15 am

    #487000

    • Viewing 15 posts - 2,851 through 2,865 (of 3,544 total)