Forum Replies Created

Viewing 15 posts - 31 through 45 (of 64 total)

  • RE: Which is faster?

    In this partiqular query there is a a single ccID variable, I explicilty called it 1518 because it was the last one I was working with... thanks for the tip...

  • RE: Warning: Null value eliminated from aggregate.

    quote:


    Depending on what you're trying to achieve, changing the nulls to zeros may impact the result in a way you dont...

  • RE: Warning: Null value eliminated from aggregate.

    Thanks for the reply. I never anticipated any problems with this syntax because in fact I have another procedure with some variying paramters that uses the same syntax for...

  • RE: Why is the Forum so slow

    FULL TEXT SEARCHING is an internal SQL feature right? What other engine could you use besides FULL TEXT Search? move the data warehouse to mySQL? :O

    -Francisco

  • RE: PeopleSoft Financials on SqlServer

    Thanks for replying with your system set up. I was just curios, you see our System Admin is the one who set up the box and has been fighting...

  • RE: PeopleSoft Financials on SqlServer

    that is one impressive database, I don't hava that db but I am curious of your hardware setup, for us on a smaller system wich averages about 30+users and about...

  • RE: I didn't ask for a work table...

    Thanks for posting such helpful replies, I will try casting the column again, but I know for a fact that it IS a varchar type... but I suppose it...

  • RE: Dynamic SQL problem

    Try commenting out the

    
    
    Exec(@SQL)

    and adding the line

    
    
    PRINT @SQL

    this will give you the SQL syntax of how the server sees it, it...

  • RE: How do you specify an Unspecified Error??

    Thanks to all for the replies,

    I didn't include more of the script as it was basically just

    
    
    Function Main()
    DTSDestination("MyFields") = DTSSource("MyFields")
    ...
  • RE: How to Print in QA

    maybe not possible then

    -Francisco

  • RE: Mind boggeling Row larger than page size problem

    I'm acctually spitting this into a DTS sql script, I thought the TempTable would only live for the life of the session thus the temptables wouldn't be available for the...

  • RE: Mind boggeling Row larger than page size problem

    Well I took your advise, and fixed it up like so...This runs fine, but I had to append log backups, it's either that or increase the size of the log...

  • RE: Mind boggeling Row larger than page size problem

    of course...

    I'll post this out as I have it ...

    (code follows)

    USE devREDe

    SET NOCOUNT ON

    /***************************************************/

    /* Eliminate Case Repitition...Speed boost*/

    /*

    if not exists (select * from tempdb.dbo.sysobjects where id = object_id(N'#tCompany'))

    BEGIN

    DROP...

  • RE: Why Secure the Database?

    If a sales guy can do any of this, he wouldn't be outta'v a job! I agree that the biggest threat is social engineering/hacking. Many people are more...

  • RE: Executing a Stored Procedure the right way

    Ouch!

    I see what you're saying... in a sense I'm leaving the entire database wide open! I suppose it would be better to script the columns to digits...

Viewing 15 posts - 31 through 45 (of 64 total)