Hi steve,

Tnx for your reply.

No, this is no concern, all days are inserted as FULL days, thats also why i have put the enddates time as 23:59:59 in the code.

But...

Hi Steve,

I have almost broken all my braincells on this one, but i'm getting closer ..

The hint to the document that you posted had me change my way of thinking,...

Hi Steve,

I have found the article and the sample document you where talking about:

Webpage : http://www.manning.com/nielsen/SampleChapter5.pdf

I have tried several approaches based on this, just as my primary solution was based...

The idea of 2 views i can understand and is possible.

But my main problem is still current

if we forget 2 seconds about the Z ranges but only concentrate on the...

Your welcome,

Glad to hear and tnx for the feedback

Eddy

Have you checked that the identity value is already set for the Run_id field, can be seen in SSMS --> modify table --> select Run_id column --> downside screen .?

you...

Nobody with an Idea on how to solve this problem.?

Schould i really fall back on external vb.net application for this.?

I hardly can believe that with the genius code from ditto...

Hello,

Anybody that can help me out here pls.?

what i have:

DECLARE @afw TABLE(id INT IDENTITY(1,1) PRIMARY KEY,

wkn_id INT,

code VARCHAR(2),

datefrom datetime,

...

Hi dave,

I have created the calender table in my system,

I already found some good uses for it but not so right away for this problem..

consider the folowing ranges with these...

Just read the article,

So there are 2 basic options left

or you use the statement as i provided WITH the option Recompile

or you have to fall...

JayK (1/17/2011)

---

WHERE

(pg.ProductLineID = @ProductLine) OR (@ProductLine = -1)

AND

(pg.ProductGroupID = @ProductGroup) OR (@ProductGroup = -1)

...

Hi dave,

Tnx for the link, will go reading that article right away,

I got some troubles posting the topic, it was already submitted when i was not done writing due to...

C3PO-594572 (1/4/2011)

---

Hopefully a simple answer..

How do you change the width of a displayed column when you do a query...so I can fir it on the screen.

In Oracle you would so...

Hi Jeff,

Is Raid 1 more preferred for database files over Raid 5.?

I know raid 5 writes...

I'm not so sure whether this is a SQLServer related problem.

I have seen the same problem occure on other servers,

fileservers, exchange servers etc..

The bad thing is, you can't find a...