punsaonline (5/19/2009)

---

If Microsoft would have think that then you might not get 2005, then 2008 so on, as database service was working fine earlier with 2000 also.

I was just looking...

Then why worry about rewriting it in a different format?

Please post your query that uses this function.

In your original post, you said the first query returned in seconds. Did it return the expected...

punsaonline (5/19/2009)

---

Hi,

My Query previously looks like that

Select A.A1,B.B2

FROM A_TABLE A

INNER JOIN B_TABLE B

ON A.A1 = B.B1

WHERE B.B2 = 'XYZ'

This query executed in seconds but when i changed this query to

Select...

You might take a look at log shipping.

FYI, Books On-Line is your friend. You will find many of your answers thee.

If you need to work with this database on your computer you may want to consider spending $50.00 (USD) and buying the Developer Edition of SQL Server.

You indicated in your original post (I belieive) that you are using SQL Server Express? I don't think you will be able to access the database. The Express...

First, your data provided does not match the diagram.

Here is some code to play with:

create table dbo.bom (item_id int, item_name varchar(15), qty int, parent varchar(10),parent_id int, has_child int, primary key(item_id));

insert...

I really expected that you'd have data for this year and last year as well. You do want to be able to compute the YTD and Previous YTD Sales...

As i get started at looking at this, I just want to confirm you are using SQL Server 2000, not SQL Server 2005. I don't want to use any...

Florian Reischl (5/18/2009)

---

No problem :-). Take the time you need or give me a short hint...

Simple answer. Yes.

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2...

The only other change I would make to Option #3 is to make the EndPeriod an "open end" on the range. Example:

StartPeriod ...