Forum Replies Created

Viewing 15 posts - 16 through 30 (of 789 total)

  • RE: Update multiple rows using Sub Query

    Sean Lange (5/13/2011)

    Something like this?

    Update users

    Set deleted = '1'

    from users u

    join UserStatus us on u.username = us.username

    where us.status = 'inactive'

    Ooops sorry for the same post, I didn't see...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 13, 2011 at 10:30 am

    #1324457

  • RE: Update multiple rows using Sub Query

    stan-617410 (5/13/2011)

    Two tables: Users, UserStatus

    Users fields: UserID, Username,Deleted (bit)

    UserStatus: UserID, Username,Status (active,inactive)

    I need to update the "Deleted" field when a user's status is Inactive.

    Update users

    Set deleted = '1'

    Where...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 13, 2011 at 10:27 am

    #1324455

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    I'm late here .... Jeff, I can see the brilliant stuff in this great article! -

    Come and be a twitter guy (@JeffModen), I would like to see the SQL...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 4, 2011 at 1:27 pm

    #1320061

  • RE: combine two columns into a single column

    I don't know your data type in your table, and one of the options can be:

    SELECT CAST(month_value AS NVARCHAR) + '/' + CAST(year_value AS NVARCHAR) AS YOUR_FIELD FROM TRANSACTION

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    February 15, 2011 at 1:10 am

    #1286890

  • RE: Spring SQL Connections 2011 and SQLServerCentral.

    Good news very professional staff it worth to attend ... I will check my possibility from other continent to come from EU to USA!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 31, 2011 at 5:48 am

    #1280350

  • RE: Display More Than 8000 Characters (SQL Spackle)

    Hey Jeff, I'm late here, but really this is very nice article, thanks for sharing!

    Wish you more success my friend,

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 28, 2011 at 1:05 pm

    #1279907

  • RE: SELECT OR CURSOR

    So you don't need to use cursor!

    🙂

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2010 at 1:36 am

    #1267560

  • RE: SELECT OR CURSOR

    One alternative is:

    INSERT INTO #TAB1

    SELECT T2.SNO, T3.DEPTID, T3.DEPTNAME

    FROM #TAB2 T2 INNER JOIN #TAB3 T3 ON T2.DEPTID = T3.DEPTID

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2010 at 1:27 am

    #1267557

  • RE: sql aZURE

    I know that is later but I post the link for the other users at least:

    http://www.microsoft.com/en-us/sqlazure/videos.aspx

    ChungaLlunga!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 25, 2010 at 5:05 pm

    #1266290

  • RE: Foreign Key Problem

    I don't now the structure of the tables and in what conditions are Foreign keys with Primary keys, I think you should enable ON DELETE CASCADE during the relationship...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 25, 2010 at 3:35 pm

    #1266289

  • RE: Install sqlserver2008 on old server

    According to your server details (little details), I can say YES you can install the SQL Server 2008! Before to install you can use the upgrade adviser with SQL Server...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 25, 2010 at 3:25 pm

    #1266288

  • RE: Table too large

    Why you are trying to SELECT all the records!?

    While you are using the SQL Server 2005 you have possibility to do the partition table ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 24, 2010 at 1:58 pm

    #1266245

  • RE: Call in the Experts

    OCTom (12/23/2010)

    Getting help may not mean getting it from a person.It may mean visiting sites such as SSC.

    The key is to know when to do that.

    Then the SSC is the...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 23, 2010 at 8:35 am

    #1265960

  • RE: Call in the Experts

    This is the true story where all of us can learn that you cannot know everything, otherwise you will know nothing at all!

    So doing SOS to the the people who...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 23, 2010 at 7:15 am

    #1265924

  • RE: FREE! SQL Scripts Manager – a Christmas gift from Red Gate

    robertm-772679 (12/23/2010)

    Thanks for the quick reply Dugi. My problem is that there is no exe file to extract from the zip file. It's a shame. They sound like some...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 23, 2010 at 6:57 am

    #1265905

Viewing 15 posts - 16 through 30 (of 789 total)