Thanks for the quick reply.

It says that OpenRowset is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote...

Interesting article, but I have a question, which hopefully will save me a lot of hours:

In Oracle 10 I do it in one select statement, using START WITH and CONNECT...

Fantastic!

Thanks a lot!

Before I will test it, I have a query, please:

I understood from Twitter that they have just changed (September 2010) their authentication flow to use oAuth authentication method (it points...

Nice article, but I wonder, what would be a performance using this PREV and NEXT join statements, as well as to ask

if there is any faster way to implement Oracle's...

Second one is the correct result.

I have just managed to do it using SUM OVER and ROW_NUMBER OVER and CASE on their result.

It is too ugly, so any aesthetic way...

Thanks, but adding of

UNION ALL

SELECT 1,6,100,1,100,15

my example will return zero duration for this Top record. This is a place to fix my explanation's mistake - in case of Top...

Using of a CASE shall slow you down. Why not to use UNION ALL instead?

If I understand correctly, there're might be different cases which you can manage in the follow...

FIFO is fine - the first you get.In my example I have find the first Commercials by there sequence

ROW_NUMBER() OVER (PARTITION BY commercial_break_id, commercial_id ORDER BY commercial_break_id,com_break_line)

Wayne,

Thanks for the reply. There's an automatic booking process which works OK.

But the normal situation in TV business is that the Sales department can decide on the fly,

close to the...

Hi Bob,

Thanks for the quick reply of yours. The result set I expect to have is as follow:

commercial_break_id commercial_id duration

1 ...

Jeff,

Instead of talking and talking and talking and talking and talking

just copy, paste and run my code... You'lll find out that it works like a charm

Here is a working idea, as you have asked.

Tested on SQL2005 : took it from Oracle, removed FROM DUAL and changed allias from dates to date (DATE is...

PLEASE! PLEASE! PLEASE!

Because

All I want to put City and State information in front of Project

means for me that all the calculations should be done for the group of those three, in...