Just verified it is working for me. But I won't be suprised if the SQLJunkies site again has problems.

Hey, 500 posts from Sweden here. Not bad for someone who doesn't like webfora.

Hm, when I have read this all correct, may I...

The cynical in me might now think, that requirements have (sharply) dropped, because people are not able (anymore) to meet this requirements. After all, when should they learn or do...

Sorry, but what exactly is now your question?

use northwind

select

 sum(case when isnull(freight,0)=0 then 1 else 0 end) as 'ohne Fracht'

 , sum(case when isnull(freight,0)>0 and isnull(freight,0)<18 then 1 else 0 end) as 'unter 18'

 , sum(case when isnull(freight,0)>=18 and isnull(freight,0)<24...

http://www.sommarskog.se/dynamic_sql.html explains how you can do it, and also, why this is a bad idea in most cases.

create table #showme

(

 d1 datetime

 , c1 char

)

insert into #showme values('20050301 09:30:00','a')

insert into #showme values('20040815 19:38:00','b')

select

 *

 , dateadd(d,0,datediff(d,0,d1)) d2

from

 #showme

order by

 d2

drop table #showme

d1                                                     c1   d2                                                    

------------------------------------------------------ ---- ------------------------------------------------------

2004-08-15 19:38:00.000                                b    2004-08-15 00:00:00.000

2005-03-01 09:30:00.000                               ...

Just out of curiosity. Did anyone bother to have a look at the link I've posted?

Steve, many thanks!

After all, it are just three letters. They don't make any answer more valid, do they? But I confess it's a cool feeling and I'm proud.

Why should I get...

Do this! I certainly have learned a lot from it. And I for myself, enjoy Joe's style of writing.

You have read the explanations in BOL on 605? I would guess hardware causing this error, but a call to MS PSS might be a good choice here anyway.

Unless I am mistaken, Carl is given credit in Joe Celko's "SQL for Smarties".

You do have read the drawbacks of using @@IDENTITY, haven't you?

create table #demo

(

 c1 int

 , c2 char

)

insert into #demo values(1,'a')

insert into #demo values(1,'b')

insert into #demo values(1,'a')

select * from #demo

update #demo set c2='z' where c2='b'

select * from #demo

drop table #demo

c1          c2  

-----------...

TANSTAAFL.

The mindset between OLAP and OLTP is somewhat different. Usually you have a denormalized schema in OLAP db's. At least this transformation from...