Forum Replies Created

Viewing 15 posts - 601 through 615 (of 1,034 total)

  • RE: Don't understand pivot

    opc.three (3/22/2011)

    What you want is a dynamic cross-tab. Here is a comprehensive article about how to do that...and why cross-tabs almost always outperform the built-in PIVOT operator:

    http://www.sqlservercentral.com/articles/Crosstab/65048/%5B/url%5D

    Jeff writes great articles,...

    March 22, 2011 at 12:59 pm

    #1302112

  • RE: Don't understand pivot

    He definately wants to use Pivot here...

    CREATE TABLE #test(

    Project VARCHAR(20),

    Person VARCHAR(50),

    projRole VARCHAR(50))

    INSERT #test

    ( Project, Person, projRole )

    VALUES

    ('Project...

    March 22, 2011 at 11:02 am

    #1302006

  • RE: LOB Data

    Tom.Thomson (3/11/2011)

    But unfortunately the explanation hasn't been corrected. It still refers to an article which gets it wrong (as has previously been pointed out by other commenters) although there...

    March 11, 2011 at 2:36 pm

    #1297891

  • RE: Restore - too recent to apply to the database?

    oliver.morris (10/20/2008)

    OK I will try that instead. Is there anything to be said for using both to backup because they are using different services and if one service went down...

    March 3, 2011 at 12:01 pm

    #1294212

  • RE: Dimension key errors despite having selected Ignore Errors

    Is the SSIS package configured to ignore errors, or is the error handling of the cube itself configured to ignore them?

    I've found that changing the error handling of dimensions to...

    March 3, 2011 at 8:22 am

    #1294052

  • RE: Forum Introduction

    Me, I'm looking for textual how-to's...

    I can imagine the whiz bang, but my meager attempts to create the web parts and incorporate them into a dashboard have been dismal...

    March 3, 2011 at 8:16 am

    #1294049

  • RE: The Percent Sign in T-SQL

    mtillman-921105 (2/28/2011)

    Yeah, I just included the "To divide by zero and get an error" as a joke. If you look at the symbol and take it at face value,...

    February 28, 2011 at 9:54 am

    #1292416

  • RE: Example SCD type 2

    Me too,

    I managed to get one plugged into a cube, but the results from it don't seem any different than when the dimension was a type 1 SCD. Attributes...

    February 28, 2011 at 8:05 am

    #1292332

  • RE: The Percent Sign in T-SQL

    I got this right but...

    SELECT 0%0

    gives

    Msg 8134, Level 16, State 1, Line 1

    Divide by zero error encountered.

    So it seems you can use it to divide 0 by 0 and get...

    February 28, 2011 at 8:02 am

    #1292328

  • RE: SQL to split a non delimited string into delimited string

    Jeff Moden (2/7/2011)

    Wolfmeister (2/7/2011)

    That's pretty slick! Thanks guys.

    Just making sure... do you understand how ColdCoffee's method works?

    Heck I didn't understand what he was doing with the CTEs till I...

    February 8, 2011 at 9:26 am

    #1283801

  • RE: SQL DISTINCT on Multiple Columns

    This was a great article on distinct.

    Did I learn anything about Distinct? No.

    But that doesn't mean that somebody else can't come along and learn something valuable from this article....

    February 8, 2011 at 8:15 am

    #1283721

  • RE: What Brand of Desktop is best these days?

    Will1922 (8/12/2010)

    Build your own. Do the research and you can make a great machine that's exactly what you want. NewEgg is great because you can do side-by-side comparisons...

    February 4, 2011 at 8:27 am

    #1282508

  • RE: How many of you are not true DBA's?

    I'm a SQL Server Generalist with a DBA title.

    I spend

    20% of my time designing new tables/databases for application modifications/creation for internal apps

    20% of my time consulting with developers who actually...

    February 4, 2011 at 8:24 am

    #1282502

  • RE: Are you a "hunt and pecker" or a "typist"?

    It's been at least 15 years since the last time I clocked my touch typing but the last time I did it was 120 WPM when I was still in...

    February 4, 2011 at 8:15 am

    #1282498

  • RE: UPDATE using a self-join

    Brandie Tarvin (2/1/2011)

    Don't get me started. I know Business Users who swear Excel is a database. <*headdesk*>

    It isn't? 😛

    I know I've seen people make the case that Vlookup is...

    February 1, 2011 at 1:17 pm

    #1281120

Viewing 15 posts - 601 through 615 (of 1,034 total)