Forum Replies Created

Viewing 15 posts - 49,411 through 49,425 (of 49,552 total)

  • RE: UNION ALL VIEW PROBLEM FOR INSERT

    Could you please post the script of your view, tables and constraints. It's easier for people to help if they know exactly what you're doing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 30, 2005 at 4:20 am

    #586087

  • RE: Date Range

    I must be going blind. I stared at that statement for several minutes and didn't even notice the from was missing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 29, 2005 at 6:16 am

    #585784

  • RE: Finding an interval of numbers in a char column?

    Oops, my bad. Sorry.

    No disrespect or insult was intended.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 29, 2005 at 6:02 am

    #585780

  • RE: Date Range

    The piece End derived table "D" should be preceeded by a -- (it's a comment, not part of the query)

    SELECT D.CUSTNMBR,sum(d.SLSAMNT) AS Total

     (

      SELECT CUSTNMBR,SLSAMNT FROM RM20101

      WHERE CUSTNMBR LIKE 'A%'

      UNION ALL  

      SELECT...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 29, 2005 at 4:47 am

    #585772

  • RE: Finding an interval of numbers in a char column?

    I hate to point out the obvious, but CAST('A102' AS INT) gives 'Syntax error converting the varchar value 'A102' to a column of data type int.'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 28, 2005 at 11:56 pm

    #585744

  • RE: Duplicate spids in sp_who

    Thanks, that makes sense.

    What about the self-blocking? It's not having any visible effects on the server, the commands aren't running for very long, though they do run often (They're an...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 26, 2005 at 3:12 am

    #585315

  • RE: Finding an interval of numbers in a char column?

    Got a suggestion, but it depends on what the data looks like.

    This won't work is you have values like A10B54 or 10B10 but is fine if the entries are...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 25, 2005 at 4:32 am

    #584906

  • RE: Question of the Day for 25 Aug 2005

    The points are for boasting rights, nothing more.

    I would imagine the 21 points was a mistype that will be corrected as soon as Steve notices.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 25, 2005 at 2:29 am

    #584892

  • RE: Question of the Day for 23 Aug 2005

    I assumed that the database did exist, and hence restore with replace was required, because there is a use Mydatabase right before the restore.

    If the database didn't exist, then the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 23, 2005 at 8:08 am

    #584189

  • RE: Question of the Day for 23 Aug 2005

    Agreed.

    I didn't get the reason that REPLACE wasn't required.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 23, 2005 at 1:52 am

    #584156

  • RE: Question of the Day for 23 Aug 2005

    Agreed.

    I didn't get the reason that REPLACE wasn't required.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 23, 2005 at 1:49 am

    #584155

  • RE: RE:

    Wierd........

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 22, 2005 at 6:35 am

    #583877

  • RE: RE:

    ?????

    Are you asking what it means, what you can do about it, why you got it, or something else completely?

    To have got that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 22, 2005 at 1:57 am

    #583825

  • RE: Stored Procedure error

    Yes, SQL's looking for a table-typed variable called @dbname1 to update, since an update statement must target a table, not a varchar variable.

    More important is what are you trying to do?

    If...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 22, 2005 at 1:41 am

    #583823

  • RE: what''''s wrong with my cursor!!!!

    You missed my point. If you don't FETCH before going into the WHILE, you don't know the value of @@FETCH_STATUS since it is GLOBAL for ALL cursors on a connection....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 19, 2005 at 12:19 am

    #583406

Viewing 15 posts - 49,411 through 49,425 (of 49,552 total)