Forum Replies Created

Viewing 15 posts - 121 through 135 (of 158 total)

  • RE: Name value pair (EAV) model

    @tymberwyld

    When you need to display different descriptions for Products based on culture, you're doing an EAV even though you've defined the columns very specifically to Products, and in...

  • RE: Simple Method for Importing Ragged files

    I get these files which are basically text streams and they are only delimited by record.

    I've written a utlity to handle it now (it's slow and difficult to...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    1) Do I need to use the intermediate table or is there a way to do this going straight from the parameter string to the final table (while still being...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    For the use of a tally table or other mechanism, populating a variable with sample data like the above is completely wrong! Those delimited values would never be passed...

  • RE: The Optimists

    Don't ask users what they want, figure out what they're trying to do and then tell them what they want.

    I couldn't agree more. To quote (or paraphrase) Henry Ford:...

  • RE: Simple Method for Importing Ragged files

    The "Ragged Right" Files I have to deal with are Mixed Row Type files as well. Because of that, I cannot use column names from the csv file, but...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

    TheSQLGuru (2/19/2008)


    Can't say I agree with that title. [...] But things like this aren't due to stupidity. They are due to lack of knowledge/training.

    I bet...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

    Christopher Ford (2/13/2008)


    Earlier Jeff posted a question on using SUM(SAL) OVER()

    Since OVER() doesn't support ORDER BY when used with an aggregation.

    How about this one?

    SELECT J1.AccountID,

    J1.Date,

    ...

  • RE: More Than One Way to Skin a Cat

    Re: Defaults

    First off, I'm pretty sure there is some sort of team/committee for each Microsoft product that decides on what the defaults should be. I'm also sure that decisions...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

    Did you test using the Clustered Index with the ORDER BY subquery? It seems to me that the ORDER BY Would enforce the order, but since you are using...

  • RE: A Little Variety

    I think that there are several issues that aren't well thought out about this type of consolidation.

    The biggest, I think, is scale. I bike a bit, but I'm not...

  • RE: Do We Need a PK?

    Excellent question, James. Our policy is to never use auto number columns for anything other than identifying a row for update or delete.

    I guess that doesn't really answer my...

  • RE: Do We Need a PK?

    RowID, StateCode, StateName, Deleted, LastUpdated

    Yes indeed. We typically have 5 custom fields on every table (Custom01 through Custom05) but not on the fact tables.

    RowID, OrderTypeID, OrderTypeName, Deleted, LastUpdated

    What do you...

  • RE: Do We Need a PK?

    We have a table with state names and abbreviations. There are not likely to be more of them. We also have about a dozen small fact tables like that. Big...

  • RE: Do We Need a PK?

    By confusion, I was referring to the original scenario. PK/FKs are solely for maintaining referential integrity.

    Assignments does not need a PK since it will never be a FK in another...

Viewing 15 posts - 121 through 135 (of 158 total)