Viewing 15 posts - 23,911 through 23,925 (of 26,484 total)
Are you using an Access Project (*.adp) or an Access Database (*.mdb)?
November 4, 2008 at 10:29 am
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...
November 4, 2008 at 10:22 am
Try this:
with ParentCommittee (
CommID,
CommName
) as (
select
comm_id,
comm_name
from
Committee
)
SELECT
c.comm_id...
November 4, 2008 at 10:14 am
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. ...
November 4, 2008 at 9:57 am
Good catch on str. I kept seeing it and ignoring it also.
November 4, 2008 at 9:52 am
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...
November 4, 2008 at 9:40 am
GilaMonster (11/4/2008)
Lynn Pettis (11/4/2008)
November 4, 2008 at 9:21 am
Try this:
(
CASE WHEN t.ItmRecvdYR1 > t.ItmRecvdYR2
THEN CONVERT(VARCHAR,((((t.ItmRecvdYR1) - t.ItmRecvdYR2)/(t.ItmRecvdYR1 * 1.0)) * 100)) + '%'
WHEN t.ItmRecvdYR2...
November 4, 2008 at 9:12 am
Two questions. What are the data types of the columns in the expression? What value are you getting currently?
November 4, 2008 at 9:07 am
Sanjay Rohra (11/4/2008)
sudeepta.ganguly (11/4/2008)
November 4, 2008 at 7:09 am
sudeepta.ganguly (11/4/2008)
November 4, 2008 at 7:06 am
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...
November 4, 2008 at 7:03 am
Jeff Moden (11/3/2008)
Sridevi (11/3/2008)
I wrote a function and i got the result too.
CREATE FUNCTION select_concat (@A INT )
RETURNS VARCHAR(MAX) AS BEGIN
...
November 3, 2008 at 10:01 pm
Have to agree with Sergiy on this one.
November 3, 2008 at 9:48 pm
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...
November 3, 2008 at 9:28 pm
Viewing 15 posts - 23,911 through 23,925 (of 26,484 total)