The two fields have different collations is all I can come up with not having the DL for the table. Script the create statement for the table and look...

I'd check the execution plans of the update queries. Sounds like there may be some missing indexes.

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

...