Forum Replies Created

Viewing 15 posts - 181 through 195 (of 498 total)

  • RE: Cursor error

    The problem is that you will need to use dynamic sql for the update statment. Oh BTW: you will also want to declare your variables for the tablename and fieldnames to...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 27, 2004 at 11:47 am

    #491805

  • RE: access query to sql server HELP!!!

    Then I would hope you have a datetime column or identity column that you could do the order by on.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 27, 2004 at 11:43 am

    #491804

  • RE: Can Procedure return datatype TABLE?

    True you can't call a stored procedure from within a UDF. However you certainly can use SET. The UDF is very powerful and if you learn to live with it's...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 26, 2004 at 11:48 am

    #491661

  • RE: Special characters showing in stored proc

    As I stated it is a "Database Project" that I created. In Visual Studio .Net it is under "Other Projects". When you create the project it will ask you to...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 3:55 pm

    #491480

  • RE: Self Join??

    You might want to look at the following thread... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=96968

     




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 3:35 pm

    #491476

  • RE: Special characters showing in stored proc

    I think what I would do is change your methodology. I prefer to have all my SPs saved as scripts. Anytime I change the SP I do it from the...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 2:36 pm

    #491467

  • RE: Finding Hierarchical Groups From The Same Table

    Very nice Thomas! I still think I would limit the depth level. Leaving it open will ultimately leave you in a bit of a performance and maintenance bind.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 2:31 pm

    #491466

  • RE: Finding Hierarchical Groups From The Same Table

    Here is an example of what I mean.

    SET NOCOUNT ON

    IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('NRGroups'))

        DROP TABLE NRGroups

    CREATE TABLE NRGroups

        (ID_ int primary key, PID int, Grp...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 2:11 pm

    #491463

  • RE: Finding Hierarchical Groups From The Same Table

    Now you know why I cringe everytime one of my developers wants to do this! If you put a limit on how many levels deep you will support then you...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 1:32 pm

    #491458

  • RE: BUG Or What Am I Missing

    You got me there Jonathan. However if you don't do it as a correlated subquery it'll return the same results as NOT IN.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 1:09 pm

    #491454

  • RE: Explicit value errors out when using Group By clause

    As Steve pointed out this is a case of lazyness catching up with you! This is the best reason to ALWAYS explicitly list out the fields you want to insert...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 12:14 pm

    #491446

  • RE: BUG Or What Am I Missing

    Ahh. Now I see what you are talking about. And yes it is a function of the ANSI SQL begin unable to compare a NULL to anything. I don't think...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 12:09 pm

    #491445

  • RE: BUG Or What Am I Missing

    Keven,

    Even though I work at MS I'm just a developer in same as you when it comes to stuff like this.

    You stated...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 23, 2004 at 11:47 am

    #491441

  • RE: Help me connect to SQL Server with ODBC

    This looks to me like you are using a trusted connection string and IIS is not configured correctly as AJ has stated. Can you post your connection string so that we...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 22, 2004 at 9:24 pm

    #491259

  • RE: Connecting from ASP to SQL

    I would prefer to set up IIS so that it uses a trusted connection to SQL Server. Then when the user logs in have a user table that does the...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    January 22, 2004 at 9:04 pm

    #491258

Viewing 15 posts - 181 through 195 (of 498 total)