Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Using Code Snippets in SSMS

    Have you tried directly adding your folders under:

    C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\SQL\Snippets\1033

    I would also assume you'd need to include the directory in the XML located in the same directory. Something...

  • RE: Using Code Snippets in SSMS

    Are there any examples for creating an MDX Snippet?

  • RE: Finding Lowest Level Descendants in Hierarchy

    I might be hallucinating, but I think this may be the correct answer?

    SELECT hrc.*

    FROM HumanResources.Employee hrc -- children

    left join HumanResources.Employee hrdc -- descendants of children

    on hrdc.OrganizationNode = hrc.OrganizationNode.GetDescendant(null, null)

    WHERE hrc.OrganizationNode.IsDescendantOf(@ParentNode)...

  • RE: Prevent sp_ Procedures with SQLCop

    Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?

  • RE: Fuzzy Matching Barcodes

    Actually they are all numbers... and that's an interesting approach. I had always examined it as a pattern matching problem, but I could use the difference to calculate which number...

  • RE: Fuzzy Matching Barcodes

    Unfortunately, the SKUs aren't all vendor specific, but for those that are I could implement narrowing down the product number to improve performance. This still leaves me with, from this...

  • RE: Filtering Members of one Measure onto Another

    Nevermind... Figured it out ----

    had to use the KEY to filter on, not an attribute! OrderID is the key attribute in the Order dimension used to relate these two...

  • RE: Data Source Views

    It sounds like you're looking for a SSAS Design best practice. This link is for SSAS 2005 but it has a great deal of fundamentals to start from:

    http://technet.microsoft.com/en-us/library/cc966399.aspx

    Star...

  • RE: Forced to use ReportViewer

    Sending view dynamically? I'm not sure if this is possible since your report metadata and structure coudl change if the view changes. If the views have all the same sets...

  • RE: Report Model Design

    are you looking for a tutorial? you should start with the following.

    http://msdn.microsoft.com/en-us/library/ms167048(v=SQL.100).aspx

    They have additional information about refinement as well, but I would treat this report model much similar...

  • RE: rendering to excel

    You can create a new list/table/matrix for each categorization of data. Using the properties of the object, you can append a page break to the object. When exporting to excel...

Viewing 11 posts - 1 through 11 (of 11 total)