Exactly.

There was recently an article on this site.

Right for you.

http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

There is a special feature for storing files.

They name it "File System".

So, store files where they belong.

Record a link to your file into database and return it to application when...

Read about scalar functions in CREATE FUNCTION topic of BOL.

Greg,

Why do you need #Ins?

It does not add anything, just causes another recompilation of the trigger.

dhay1999 (10/5/2007)

---

Yes, this is a non-analysis services Datawarehouse. so basically I am processing a "cube" to get aggregations at 6 different hierarchical levels/views. No matter what I do,...

Jeff Moden (10/8/2007)

Personally, yeah... I think dates with no orders should be included in the mix and possibly execluding weekends as a separate category. Not what the OP asked...

Ilkka Vaahtoranta (10/8/2007)

---

Yeah that does the trick! Thanks. But I do not really understand what they do and what those char(10) and char(13) stand for? Is there more usable char(?)...

I believe this topic is a perfect illustration for the article "Why programmers cannot program?".

They take care about everything - formatting, performance, style, but ignore building correct algorithm absolutely.

Maddogs,

I was talking about MY PROJECTS.

Projects I designed, built and told developers what to do.

Of course, there are plenty of other projects around, designed by normal simple-mind developers.

Of course, we...

What about days having no orders?

What if nobody made any order on Tuesday?

Jeff, don't you think the Thursday calculation should include zero orders for Tuesday, not whatever number for...

Greg,

in the example given your approach gives 3 days Orders Count for 05/05/1998.

OP expects it to be 10.

That's why I asked about the logic to be implemented.

David,

that was not much help.

You cannot build any right query unless you know what you are querying for.

I still see the same logical error (according to my understanding) in the...

Still it's not clear what are trying to achieve.

As for me the solution you posted is logically wrong.

But I cannot be sure because I don't have an idea what's the...

I fixed the typo.