Forum Replies Created

Viewing 15 posts - 16 through 30 (of 6,464 total)

  • Reply To: Software need db owner permission to master database (sql2016)

    Michael L John wrote:

    That works.  But, you may see additional errors appear when running the app. The app may have something that tries to modify the database(s), such as shrinking(!) or something...

  • Reply To: The Changing Nature of Data

    roger.plowman wrote:

    Matt Miller (4) wrote:

    roger.plowman wrote:

    Eric M Russell wrote:

    For a highly selective and sensitive database, something  like AIDS patients or voter records, address should be protected. Not only can it be used in conjunction...

  • Reply To: The Changing Nature of Data

    roger.plowman wrote:

    Eric M Russell wrote:

    For a highly selective and sensitive database, something  like AIDS patients or voter records, address should be protected. Not only can it be used in conjunction with other...

  • Reply To: Is DBA responsible for ETL operations and cube creation in DW design project?

    While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for them.

     

    In short while...

  • Reply To: Get the Datetime

    GeorgeCopeland wrote:

    I have a suggestion for you Jeff. Your company may bill by the quarter hour, but that doesn't mean that you have to enter your time that way. Tell...

  • Reply To: Get the Datetime

    Well if not reading the manual is reason to remove people's ability to code, then there are a LOT of developers to fire out there.  As with many other disciplines...

  • Reply To: Is SSIS a dinosaur in Modern ETL?

    I'd also take issue with the oversimplification that "SSIS only deals with the Microsoft stack".  there are a number of built-in connectors, and support for OLEDB connectors and other such...

  • Reply To: Are the posted questions getting worse?

    Chris Harshman wrote:

    jonathan.crawford wrote:

    Do you guys run EVERYTHING that goes into production through QA/UAT, or do you trust some users if they have a proven track record of high scores, and...

  • Reply To: Select from view where not exists in table

    The except syntax direct compares matching sets of columns.  That said - the output of the EXCEPT is a recordset, so you could make it a subquery then join back...

  • Reply To: Select from view where not exists in table

    Try this one

    SELECT 
    V.[ID],
    V.[ReferenceID],
    V.[ReferenceType],
    V.[Enddate]

    FROM [MyDB].[dbo].[V_MyView] V
    except

    SELECT
    T.[CustomerID],
    T.[RelatedReferenceID],
    ...
  • Reply To: Setting Session Skill Levels

    You may not have this luxury in every venue but I ended up working in a short description of what was meant by beginner or intermediate into the session description.

    Something...

  • Reply To: XML with Namespaces

    That's because you essentially have a one to many link between the class and vat rates level, and you're only returning the first one.  That's what the [1] is doing...

  • Reply To: How to Retrieve a Substring From a Larger String of Varying Length

    Understood - but I'm not getting into a lost cause debate about having Microsoft change one of its core assumptions since the early 90's for SQL server:  simply pointing out...

  • Reply To: XML with Namespaces

    As in :

     

    select 
    fields.value('(../ns3:DummyValueMessageHeader/ns3:TransactionType)[1]', 'varchar(100)') AS TransactionType
    ,fields.value('(../ns3:DummyValueMessageHeader/ns3:CreationDateTime)[1]', 'datetime2(7)') AS CreatedDate
    ,fields.value('(ns2:Sync/@actionCode)[1]', 'varchar(100)') AS actionCode
    ,fields.value('(ns4:MerchandiseHierarchy/ns4:MerchandiseMasterDivision/*:ChainNumber)[1]', 'varchar(100)') AS ChainNumber
    ,fields.value('(ns4:MerchandiseHierarchy/ns4:MerchandiseMasterDivision)[1]', 'varchar(100)') AS MerchandiseMasterDivision
    from @x.nodes('//SyncMerchandiseHierarchyRequest/SyncMerchandiseHierarchy') as xmldata(fields)
  • Reply To: XML with Namespaces

    This is a "quick and dirty" trick, but simply add *: in front of ChainNumber in your query.  Of course that will work assuming no 2 of your namespaces have...

Viewing 15 posts - 16 through 30 (of 6,464 total)