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...

And now is the time to go to an Oracle forum, as you're now asking PL/SQL questions 🙂

Interesting question to close the week, thanks.

Shaira (8/29/2013)

---

Thanks for the link but it's still working one package at a time to get the information. Granted, once it's done you've got it, but for now I...

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...

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...

Sure, the XML PATH...

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...

Which version of SSIS?

Where are the packages stored?

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.

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.

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:...

sainatth.wagh (8/29/2013)

---

Thanks for replying promptly. But i had question since i came to know that 70-448 has retired as per July 31 2013. So now will i still receive the...

sainatth.wagh (8/29/2013)

---

Hi All,

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...

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...