I use window functions all the time! Would love to know how to enhance them even further.

SELECT t.Name,

t.CountryRegionCode,

t.[Group],

t.SalesYTD,

RANK() OVER (PARTITION BY [Group] ORDER BY SalesYTD) AS SubRank,

RANK() OVER (ORDER...

Hi,

I have exactly the same issue - is anyone able to assist?

Basically i am using the queryout option to execute a stored proc that ultimately returns rows to...

I am having a more basic problem.

I have a simple SSIS package that is connecting to an Oracle database. I want to run a script on the database that...