Viewing 15 posts - 3,031 through 3,045 (of 11,678 total)
I know Power Query can handle JSON pretty easily.
May 16, 2014 at 1:03 am
That's insane rambling and extremely short-sighted.
We're 9 years further than 2005, and ETL jobs are still as important.
Just using views as an intermediate layer between the transactional system is not...
May 16, 2014 at 12:28 am
I don't think much has changed.
You're still stuck with 3rd party tools.
May 16, 2014 at 12:23 am
Am I the only one who thought the question was worded a bit strange?
However you would not like to get the results back in a grid
Anyway, as stated above, the...
May 16, 2014 at 12:19 am
J M-314995 (5/15/2014)
Right now I'm using SSMS but when I get everything put together, I'm going to throw the script into an SSIS package and put it on a schedule.
If...
May 15, 2014 at 11:52 pm
mister.magoo (5/15/2014)
Try copying the first data row down so all the rows have exactly the same data - does it fail then also?
Or copy the contents into a brand new...
May 15, 2014 at 11:50 pm
In mathematical theory, a tuple (which is what we call a row, and a table is a relation btw) consists of ordered elements.
However, if you say element, no one will...
May 15, 2014 at 12:43 pm
How are you bulk loading?
May 15, 2014 at 12:36 pm
gbritton1 (5/15/2014)
There is a CountRows function that you can use. If it returns 0 for your dataset, display the No Rows Found message.
I've done something similar recently.
May 15, 2014 at 12:33 pm
Steve Jones - SSC Editor (5/15/2014)
skeleton567 (5/15/2014)
Koen Verbeeck (5/15/2014)
May 15, 2014 at 12:28 pm
Ian Massi (5/15/2014)
May 15, 2014 at 7:27 am
david.wright-948385 (5/15/2014)
skeleton567 (5/15/2014)
This is exactly why I oppose the development of computer controlled vehicles.
I'm kinda hoping that the software controlling automatic cars will fall under similar standards as airplane...
May 15, 2014 at 7:09 am
skeleton567 (5/15/2014)
Gary Varga (5/15/2014)
May 15, 2014 at 6:05 am
Viewing 15 posts - 3,031 through 3,045 (of 11,678 total)