Jeff Moden (6/16/2008)

---

Yes... we did something similar at work... we changed from SQL Server...

On the performance, I'm trying to get the results right, then I'll mess with the speed. Once I know the right data is coming out, then it's time to...

It's meant to be an inner join. Sorry about that.

Piotr Rodak (6/16/2008)

---

I developed an access control system that has been working on MSDE for 5 years now.. The database is about 150MB in size, biggest table contains 1.5M rows,...

GilaMonster (6/16/2008)

---

Naturally. I probably should...

It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.

If an airplane's (or ship's) navigation...

I do have an opinion on this subject, and it's got a basis in reality. There is a gradient scale of being right, with dead-wrong on one end and...

I have some examples where hardware was a solution. See if you agree with...

What I very specifically asked for is create scripts and insert statements.

For example:

create table T1 (

ID int identity primary key,

Col1 varchar(25),

constraint CK_Col1 check (col1 != '' or col1 is null))

go

insert...

Sorry for the delay in answering, I was out sick for a few days.

Here's what I meant by adding that one table back in to the query.

SELECT CHF.CONTACT_WID ,

COUNT(DISTINCT...

Change the formula to:

dateadd(day, -1 * datepart(day, ltrf.month_year), ltrf.month_year) + 1

That should do it.

Just an off-the-cuff guess, is Auto-Close turned on on that database?

Kevin (6/10/2008)

---

Hi

I have made use of MSDE and now SQL Express 2005 for an application, some details:

* Size of Databases between 30 - 150MB - yes MB

* ...

I disagree with all of the answers. The most correct answer is "Change the column to data type varchar(max) and use Update".

Can you extract the XML file into a flat table? A temp table or a real table, either one?

It looks to me like this proc is stepping through the...