After further investigation I see that the store_key in the pos_transaction table is a smallint while the orig_store_key column in the postran_sku is an integer. Could that be causing...

This query is just a portion of the much bigger query. This is the portion that is causing the problem. I have attached 2 queries along with the...

Gail/Jeff, attached is the DDL for both the tables and their indexes and constraints. Thank you for your time.

David

I came across the attached document which may help.

David

I thought about creating my own. The CREATE DATABASE ... FOR ATTACH worked well once I got the syntax down. This database was created long before I got...

This is how I got it to work:

use master

go

create database focus

on

(filename='c:\mssql7\data\Focus_Primary.mdf'),

(filename='e:\ruelp\D_FocusData\FOCUSCM.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSCMIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSLP.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSLPIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSLP2.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSLP2IX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSCC.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSCCIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPC.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPCIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPC2.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPC2IX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPT.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPTIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPTS.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSPTSIX.ndf'),

(filename='e:\ruelp\D_FocusData\FocusRptData01.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSSF.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSSFIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSTND.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSTNDIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSWHRS.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSWHRSIX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSWHRS2.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSWHRS2IX.ndf'),

(filename='e:\ruelp\D_FocusData\FOCUSWRK.ndf'),

(filename='c:\mssql7\data\FOCUSLOG1.ldf'),

(filename='c:\mssql7\data\FOCUSLOG2.ldf'),

(filename='c:\mssql7\data\FOCUSLOG3.ldf'),

(filename='c:\mssql7\data\FOCUSLOG4.ldf')

for attach;

go

That seems to work!  Thank you.

David 

Ramesh, it worked!!!  Thank you very much! 

David

This is what I get:

The table definition is:

CREATE TABLE [esell].[outlet_sku_xref] (

 [retailer_id] [int] NOT NULL ,

 [sku_id] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [outlet_id] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [threshold] [int]...

If I use your example, would that work on my file example.  What would the row terminator in the file need to look like?  Right now there is now row...

Got it.

SELECT *

FROM

sys.triggers t JOIN sys.tables a ON t.[parent_id] = a.[object_id]

JOIN sys.schemas s ON a.[schema_id] = s.[schema_id]

WHERE t.[Name] = 'TR_AIUD_CC_CUSTOMER_DELTA_A' AND a.[Name] = 'CUSTOMER' AND s.name = 'CRM'

The database in general.  Hit ratios, waits, poor running SQL etc...

David

Awsome!!!  Thank you.

David

The execute SQL step worked great.  I will look into doint the identity value using vb script.  Do you have an idea on how to do that?  Thank you very...

Thanks for all the input.  This really help a lot.  Have a great day!