Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 26,490 total)

  • RE: Could this be done better?

    erikd (11/24/2013)

    Hi Lynn,

    They're all 1 in the test data, but not in my table:

    statusflagDescription Counts

    1...

    November 24, 2013 at 10:23 pm

    #1668715

  • RE: Could this be done better?

    erikd (11/24/2013)

    Mine was 503ms, yours was 96ms :blush:

    Try something for me, move the WHERE statusflag = 1 into the BaseData cte and rerun the code.

    Be sure to report the execution...

    November 24, 2013 at 9:26 am

    #1668668

  • RE: Could this be done better?

    What's the difference in execution times?

    November 24, 2013 at 8:59 am

    #1668664

  • RE: Could this be done better?

    erikd (11/24/2013)

    Hot damn, Lynn, that's awesome. Attached plans from running on my actual table. I'm expecting data for 13 more countries, so I'll compare again when I have everything.

    Is there...

    November 24, 2013 at 8:39 am

    #1668662

  • RE: Could this be done better?

    Here is my solution along with yours:

    with data (orc_country, orc_quotacell, statusflag) as (

    select 'Canada', 1, 1 UNION ALL

    select 'Canada', 2, 1 UNION ALL

    select 'Canada', 3, 1 UNION ALL...

    November 24, 2013 at 6:43 am

    #1668653

  • RE: SQL 2012 Standard Edition Trail version available?

    The only trial edition of SQL Server I am aware of is the Enterprise Edition trial version.

    November 24, 2013 at 6:09 am

    #1668650

  • RE: RANGE OF DATES

    First, please read the first article I have referenced below in my signature block. It will walk you through the what and how of the things you should post...

    November 24, 2013 at 1:25 am

    #1668640

  • RE: Not Able to Connect Sql 2005 Database in Sql 2000

    You can not attach a database from SQL Server 2005 to SQL Server 2000 regardless of the compatibility mode. Once you attach or restore a database from SQL Server...

    November 23, 2013 at 10:56 am

    #1668609

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/23/2013)

    Lynn Pettis (11/23/2013)

    Steve Jones - SSC Editor (11/22/2013)

    Lynn Pettis (11/22/2013)

    Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I...

    November 23, 2013 at 10:36 am

    #1668605

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/22/2013)

    Lynn Pettis (11/22/2013)

    Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the...

    November 23, 2013 at 2:05 am

    #1668586

  • RE: Are the posted questions getting worse?

    Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is...

    November 22, 2013 at 11:18 am

    #1668492

  • RE: SQL 2012 Dev Edition

    Ells (11/21/2013)

    My license key is already filled in when I run the setup of Developer Edition. Maybe because mine was downloaded from MSDN (I think?).

    Yes mine was not downloaded it...

    November 21, 2013 at 6:51 am

    #1668101

  • RE: SQL 2012 Dev Edition

    Ells (11/21/2013)

    added the product key and now I think its trying to upgrade although taking a long time.

    Sure? When I installed my version of SQL Server 2012 Developer Edition I...

    November 21, 2013 at 3:55 am

    #1668062

  • RE: sp_makewebtask is not available in sql 2008

    The web task procedures were removed from SQL Server 2008.

    Looking at MSDN it recommends using Reporting Services.

    November 21, 2013 at 3:22 am

    #1668054

  • RE: Rearrange Result of Data with TSQL Script

    sunil.mvs (11/20/2013)

    Thanks Chris ...

    The solution is as expected.. but need to check performance .

    Thanks

    Surya Sunil

    You should also make sure you understand how it is...

    November 20, 2013 at 7:27 am

    #1667811

Viewing 15 posts - 7,126 through 7,140 (of 26,490 total)