Here's a solution that does all in one path.

However, you need to decide whether you really need the identical output several times just named different (especially the SUM(bibal) stuff)...

Side note:...

If you don't want to use SQL Agent you could use a *caugh* loop with a delay.

something like

DECLARE

@start DATETIME,

@duration_minutes INT,

@delay_seconds CHAR(8)

SET @start = GETDATE()

SET @duration_minutes = 1 --...

Günter,

did you try using an EXISTS query to see if there are any data in your view?

Something like

IF EXISTS (select 1 from dbo.VWFaktSensitivitaetAggregation where DatumID=2010053100) ...

Since all you want...

The WITH statement is part of a CTE (common table expression).

A cte (at least the type you're using) is nothing but a subquery, just easier to read (for some of...

It's getting late over here in Europe...

So, instead of a coded version here's a brief description of how I'd do it:

Store the results of the query you just posted in...

Ok, what you're basically trying to do is an UPSERT (Update or Insert) based on existence of a customer ID. Right?

Why do you need to do it against XML files?...

Gianluca Sartori (6/14/2010)

I haven't seen any matches yet, but tonight they're playing Italy vs. Paraguay.

Vuvuzelas will get soon into my...

Did you consider using SSAS? It might be helpful for the "blob" scenario while still allowing you to shred the data.

The other issue I'd be worried about: when dealing with...

What would be the sorting order to get the "top x" to apply the new events?

What is the business rule in case of non-integer results? (e.g. 10% of 5 rows...

Usually, it helps a lot if you'd post something like

"here's what I have: ...

here's my desired result:...

those are the business rules to follow...

and here's what I've tried so far:...

"

For more...

Based on BOL there is no restriction. So, in theory, it shouldn't matter.

Did you try it using a simple sproc? Wouldn't such a test be easier than asking a theoretical...

How are you planning to deal with tie values?

Eg. 20% = 1 and 20% =2?

I'd also recommend you change the structure of your procedure names:

it's considered as bad practice to start your stored procedures with sp_ since SQL server will try to find those...

Most common answer: "it depends" 😀

The major question is: What are you going to do with the data (= Why do you have to store it in XML format)? Wouldn't...

If you literally mean "nobody" than the only way I can think of is "DROP DATABASE".

Other than that: AFAIK at least all persons with admin permission on that particular server...