Forum Replies Created

Viewing 15 posts - 1 through 15 (of 77 total)

  • Reply To: Importing JSON

    That’s an error on my part. The original Json is valid and gets processed correctly except for the nested data. I can’t share the original, unfortunately.

    I guess my question boils...

  • Reply To: Importing and normalizing

    There should only be one record for each file in the Media table, and there could be several hashes for each file. The complexity occurs when another import is conducted....

  • Reply To: Importing and normalizing

    No, it will be one-to-many in most cases.  For some of these files, only the MD5 has was generated, but for others the SHA1 and PhotoDNA hashes were also generated...

  • Reply To: Importing and normalizing

    The only way to determine whether an insert or update is needed is the presence of the MD5 hash in the Hashes table.  If it already exists, then the corresponding...

  • RE: Executing stored proc stored in variable

    I figured it out.  You just have to set the SQLSourceType to Variable, and select the variable from the SourceVariable dropdown that appears.  Simple, once you know the option exists.

  • RE: Exiting ForEach prematurely

    I figured it out earlier this morning.  You're exactly right.  That task had more than one avenue to it, and I had neglected to set the constraint to OR (any...

  • RE: Snap textbox to right side of footer

    I had thought of that, but was hoping there was a way to do it and stay consistent with the template.  Thanks!

  • RE: A better way than multiple subqueries?

    I take your point on the sample not being consumable.  

    Thank you both for your suggestions.  I'll give them a try.

  • RE: A better way than multiple subqueries?

    tbl_devices
    device_uid                                                       ...

  • RE: Failover Cluster Installation Error

    I actually am a domain admin, but I got it working.  It seems that for some reason it kept choking on the name I was using.  For example, TEST would...

  • RE: Failover Cluster Installation Error

    So what I have looks like this:

    Node 1 - LFSQL01
    Node 2 - LFSQL02
    Virtual Cluster - LF_FV_CL
    SQL Cluster - LF_CL_SQL

    All of the above are valid...

  • RE: Failover Cluster Installation Error

    So this would be the name of the server I'm setting up the node on (in this case, it's the first node in the cluster)?

  • RE: Mirroring in a WSFC environment

    Yes, those assumptions are correct.  So, as I assumed, the cluster and its witness have no bearing on the sql mirroring at all, correct?  The mirroring, which I'm just setting...

  • RE: Source returns no tables

    To clarify, I use a query that specifies the schema to be used and this will return results, but I still can't get a list of tables. Does this...

  • RE: Report parameters not affecting query

    Caching is not set up for this dataset.

    I've run the report both in BIDS and in the report manager.

    The dataset is using a stored procedure, and the parameters...

Viewing 15 posts - 1 through 15 (of 77 total)