Are you using an Access Project (*.adp) or an Access Database (*.mdb)?

I have to second Seth on the approach. Start by writing your query simply as a select query, starting with the main table first and all the data elements...

Try this:

with ParentCommittee (

CommID,

CommName

) as (

select

comm_id,

comm_name

from

Committee

)

SELECT

c.comm_id...

Take your post and expand it some. You provide some sample data, show us what the final results of the query you are try to write would be. ...

Good catch on str. I kept seeing it and ignoring it also.

One thing to remember, when we ask for sample data, we aren't asking you to provide the entire data set. We just need enough data to test what we...

GilaMonster (11/4/2008)

---

Lynn Pettis (11/4/2008)

---

Don't simply truncate the transaction log. You will break your log chain, and won't be able to do a restore to a point in time. ...

Try this:

(

CASE WHEN t.ItmRecvdYR1 > t.ItmRecvdYR2

THEN CONVERT(VARCHAR,((((t.ItmRecvdYR1) - t.ItmRecvdYR2)/(t.ItmRecvdYR1 * 1.0)) * 100)) + '%'

WHEN t.ItmRecvdYR2...

Two questions. What are the data types of the columns in the expression? What value are you getting currently?

Sanjay Rohra (11/4/2008)

---

sudeepta.ganguly (11/4/2008)

---

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of truncating the...

sudeepta.ganguly (11/4/2008)

---

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of truncating the logs as...

That tells me that the version of MSDE you are running is SQL Server 2000 as well. All you need to do is a backup of the database on...

Jeff Moden (11/3/2008)

---

Sridevi (11/3/2008)

---

Many Thanks to you.

I wrote a function and i got the result too.

CREATE FUNCTION select_concat (@A INT )

RETURNS VARCHAR(MAX) AS BEGIN

...

Have to agree with Sergiy on this one.

And with all that having been said, you DON'T want to be shrinking the transaction log after every backup. You just force SQL Server to make it grow again...