Viewing 15 posts - 31 through 45 (of 595 total)
But that will give you all of the nodes and their position in the tree. The OP specifically asked for only the bottom nodes. Some of these will be at...
October 3, 2019 at 12:59 pm
Bit of a dirty cheat, but seeing as they do support the site...
Download Redgate Toolbelt and use database compare. This will not only pick up top level objects such as...
October 3, 2019 at 12:52 pm
The short answer is PowerBI if data is already in the cloud
If the data sets are not too large (< 1M rows) then Excel and Pivot tables is always an...
October 3, 2019 at 12:48 pm
Hi Andrey, It turned out to be a little bit more subtle than that.
I eventually traced it to the account setup. One was set to Language = British English and...
July 25, 2019 at 3:45 pm
your problem is going to be referential integrity. where you have foreign keys you will need to identify all of the dependent records.
If you are building a test or...
January 22, 2019 at 10:13 am
I think you will be OK with the suggestion above as long as the sheets follow a naming convention or you can iterate through the sheet names from another data...
January 22, 2019 at 10:05 am
I expect the OP wants to always have the hash value in the same place so that queries are consistent - you can pretty much lift...
January 9, 2019 at 7:22 am
forSalePropertyCampaignList is an array [ ] of objects { } rather than an object itself, therefore you need to reference the first element of the array [0] - arrays are...
January 3, 2019 at 6:50 am
SSIS and Excel do not play nicely. Can you get the data from the original source rather than from Excel.
Excel will generate errors you can't program for in...
January 3, 2019 at 6:40 am
HI Peter.
I agree that SSIS does tend to make simple things complicated but it also makes REALLY complicated things less complicated when you get really under the hood.
January 3, 2019 at 6:34 am
Although it has gone quiet from the OP, Mail Merge, especially MS Word does not like nested data sets and most commercial mailing houses seem to struggle with it too. ...
January 3, 2019 at 6:20 am
Have a look at the following:
BIML (Business Intelligence Markup Language) which is an add-on for SSDT and helps to scaffold out SSIS packages based on sys metadata -...
December 18, 2018 at 7:03 am
EAVs can be a good way to scaffold an application until the users understand what they want as it gives ultimate flexibility on the data management side with 'relatively' little...
December 18, 2018 at 6:48 am
The one that freaks me out is the nested join syntax
SELECT
A.something
C.anotherThing
FROM
TableA...
November 27, 2018 at 6:12 am
YES, you need to abstract the logic to make it easier to understand, maintain and test.
My first reaction would be to move the logic to a function as...
October 23, 2018 at 7:02 am
Viewing 15 posts - 31 through 45 (of 595 total)