yep, it's the crap i am receiving  :-/

Yep, that does the trick 🙂

thanks a lot.

Hi Jonathan

Thank you very much for your help, which is greatly appreciated.

However, I was probably not so concise in describing what I need. My goal is to produce new records...

Thanks guys for the great advice 🙂

Sorry for the delay. I got stroke by a bad headache that knocked me out for over 24 hours. Your posting is fair enough, as we deal with both Oracle...

The DDL Looks like Oracle to me. To stay Close with your original code, i replaced the houre "numbers" with "small numbers".

In real world you might want to use the...

• This reply was modified 5 years, 8 months ago by  rotcha99.

Required me three attempts to read the original post 😉 I think, he means the input data may be errorous, as click streams can be. Hence, I suggest to perform...

I was able to re-phrase and extend my query with your help 🙂

with companyRatings as (
    select
        ratingData.*,
        -- that's the rating which counts for...

Hey Scott
Thanks a lot. I was quite sure, there's a more elegant way to solve this. I will check your solution. Mine is ridiculously long, complicated and hard to...

I see, raising an exception could do the trick and produce an entry in the log...

Sorry, I was referring to that INSERT INTO-Statement. As the author, the DDL was clear to me. Sometimes comments would help. I am researching patterns (PoC) to build an ODS...

Well, this will always insert the value -1, instead of a random/autoinc that makes a row (technically) unique.
Looks like I'll have to use the business keys (as infered by...

Unfortunately, it won't accept any values. turning off identify_insert will overwrite the value assigned by the server. Perhaps I could do something inside a 'before insert' trigger.

Hey Drew
Thanks for the real quick answer. You looked pretty closely though. That's a mistake in my example. I shouldn't have provided any value for attr5 in the live...

Well, it's a fictitious table 😉

My solution - after a weekend of thinking - is very similar (I'm new to SQL Server)

What do you think? I...