Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 2,894 total)

  • RE: How do I use one column for node names and the others for elements in that node?

    aaron.reese (9/20/2012)

    I do have to agree with the byte-bloat issue.

    Can anyone beat this? its from the NHS clinical data set upload for patient details

    <personGenderCodeCurrent>M</personGenderCodeCurrent>

    There is nothing wrong with that!

    XML is...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 20, 2012 at 7:27 am

    #1540064

  • RE: use column in Group By, but Hide column from the results set

    Phil Parkin (9/19/2012)

    preetid2 (9/19/2012)

    Thanks Phil! this worked perfect!

    I feel like I have entered a parallel universe.:alien:

    I knew that! Your avatar makes everything right! What a solution!

    :hehe::hehe::hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 2:12 pm

    #1539788

  • RE: How do I use one column for node names and the others for elements in that node?

    ...

    I want the xml to look like this:

    <PartsList>

    <123>

    ...

    It is not valid XML. You cannot have element named as number....

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 12:04 pm

    #1539734

  • RE: use column in Group By, but Hide column from the results set

    Phil Parkin (9/19/2012)

    Eugene Elutin (9/19/2012)

    Yes it is possible, but what it will give you?

    SELECT Col1, Count_Rec

    FROM (SELECT Col1, Col2, Count(*) AS Count_Rec

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 11:45 am

    #1539730

  • RE: T-SQL Help Needed

    GSquared (9/19/2012)

    Eugene Elutin (9/19/2012)

    ...

    I just afraid that we scare Joe even more now...

    I don't think you'll scare him. Maybe offend, but not scare.

    ...

    I...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 11:40 am

    #1539727

  • RE: use column in Group By, but Hide column from the results set

    Yes it is possible, but what it will give you?

    SELECT Col1, Count_Rec

    FROM (SELECT Col1, Col2, Count(*) AS Count_Rec

    FROM MyTable...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 10:20 am

    #1539678

  • RE: MERGE vs IF EXISTS with INSERT UPDATE

    And another thing to mention for MERGE is that SQL Server kind of splits the data into up to three "streams" and executes INSERT, UPDATE and DELETE (if required).

    So,...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 10:17 am

    #1539676

  • RE: T-SQL Help Needed

    ScottPletcher (9/19/2012)

    Eugene Elutin (9/19/2012)

    ...

    ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and Primary Key.

    ...

    You...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 8:47 am

    #1539607

  • RE: End Of Year

    Jeff Moden (9/18/2012)

    Eugene Elutin (9/18/2012)

    Please ignore this stupid remark!

    Easy, big guy. You're right but that's something that he would say. 😉

    I've spent 5 minutes to choose the word...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 6:20 am

    #1539505

  • RE: T-SQL Help Needed

    ...

    ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and Primary Key.

    ...

    You wouldn't call it...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 19, 2012 at 5:09 am

    #1539491

  • RE: End Of Year

    CELKO (9/18/2012)

    I don't want to post it again, so Google around here for "Report_Periods"; it is a basic look-up table for temporal durations. Don't use UDFs; they screw up...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 18, 2012 at 8:06 pm

    #1539346

  • RE: T-SQL Help Needed

    CELKO (9/18/2012)

    I do order some items from different countries including non-US, but order numbers looks the same to me. Have Amazon registered international order numbering standard?

    I don't know,...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 18, 2012 at 7:54 pm

    #1539343

  • RE: Cursor within triggers...

    CELKO (9/18/2012)

    I have a product_sku CHAR(10) s table and a storage product_sku CHAR(10) s table.

    No, you do not. A table has a key and you have none. What...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 18, 2012 at 7:26 pm

    #1539338

  • RE: T-SQL Help Needed

    HowardW (9/18/2012)

    GSquared (9/18/2012)

    Last I heard, Google uses a customized version of MySQL for their primary data storage. They rebuilt the engine and modified the ACIDity of transactions towards "eventually...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 18, 2012 at 10:56 am

    #1539194

  • RE: UniqueIdentifier as a Primary Key

    ...

    3) What are your "multiple reasons" for not using an identity column?

    ...

    I've worked once on similar system. All "multiple reasons" I have heard from original designers definitely didn't justify custom...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 18, 2012 at 9:43 am

    #1539162

Viewing 15 posts - 1,171 through 1,185 (of 2,894 total)