Viewing 15 posts - 23,911 through 23,925 (of 26,490 total)
Before transfering the data, change the recovery model of your test database to use the simple recovery model.
November 4, 2008 at 11:50 am
Not sure what kind of script you are talking about. If there are any structure changes, SQL Server will handle that for you.
November 4, 2008 at 11:44 am
I'd check to see if another full backup was run between 02:00 and 06:00. Start by checking the msdb.dbo.backupset and msdb.dbo.backupfile tables.
Also, if the full backup actually was completed...
November 4, 2008 at 11:43 am
Just to be sure, post the actual code you used.
November 4, 2008 at 11:33 am
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...
November 4, 2008 at 11:29 am
I'd check the execution plans of the update queries. Sounds like there may be some missing indexes.
November 4, 2008 at 11:06 am
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
Viewing 15 posts - 23,911 through 23,925 (of 26,490 total)