Viewing 15 posts - 4,966 through 4,980 (of 11,678 total)
Jeff Moden (8/29/2013)
As an equally interesting question, I wonder what possessed that first someone to think "Ok... I'm going to eat the next thing that comes out of that chicken's...
August 30, 2013 at 1:02 am
And now is the time to go to an Oracle forum, as you're now asking PL/SQL questions 🙂
August 30, 2013 at 1:00 am
Interesting question to close the week, thanks.
August 30, 2013 at 12:56 am
Shaira (8/29/2013)
August 29, 2013 at 2:18 pm
Sean Lange (8/29/2013)
Koen Verbeeck (8/29/2013)
WITH CTE_NoZero AS(SELECT ID, ReadNo, deviceNo FROM DeviceReading WHERE ReadNo <> 0)
SELECT ReadNo, deviceNo
FROM
(SELECT ReadNo, deviceNo, RID = ROW_NUMBER() OVER (PARTITION BY deviceNo ORDER BY ID...
August 29, 2013 at 2:03 pm
WITH CTE_NoZero AS
(SELECT ID, ReadNo, deviceNo FROM DeviceReading WHERE ReadNo <> 0)
SELECT ReadNo, deviceNo
FROM
(SELECT ReadNo, deviceNo, RID = ROW_NUMBER() OVER (PARTITION BY deviceNo ORDER BY ID DESC)
FROM CTE_NoZero) tmp
WHERE RID...
August 29, 2013 at 1:25 pm
Alan.B (8/29/2013)
Koen did a great job explaining your query. I just wanted to include a couple alternatives that do the same thing and are easier to understand.
Sure, the XML PATH...
August 29, 2013 at 1:19 pm
OK. I asked because it is easier in SQL Server 2012.
When the packages are stored in MSDB, they are stored as XML in a table.
This means you can query the...
August 29, 2013 at 1:14 pm
Which version of SSIS?
Where are the packages stored?
August 29, 2013 at 12:58 pm
Last maximum value is a bit contradictory.
You either want the last non-zero value, or you want the maximum value if it is non-zero.
August 29, 2013 at 12:57 pm
SharePoint is the way to go (if you have the correct version/license).
Here's an article on the PowerPivot gallery:
Create and Customize PowerPivot Gallery
Make sure you install the PowerPivot for SharePoint instance.
August 29, 2013 at 12:52 pm
If you have a SSAS cube, users can access the cube using Excel and build pivottables and charts on top of it.
If they have permissions of course.
Regarding the PowerPivot gallery:...
August 29, 2013 at 12:42 pm
sainatth.wagh (8/29/2013)
August 29, 2013 at 12:40 pm
sainatth.wagh (8/29/2013)
I cleared my 70-448 exam yesterday with 820 marks. So i am happy about it. However wanted to know whether will i receive the transscript with MCTS certificate...
August 29, 2013 at 12:19 pm
This query concatenates all the values found in the name column of the sys.all_columns table for a specific table.
The coalesce function is used to take into account that the very...
August 29, 2013 at 7:11 am
Viewing 15 posts - 4,966 through 4,980 (of 11,678 total)