I'd also look at Matt's suggestion about UNION'ed select's.

Also, I would suggest getting away from writing queries like this:

SELECT mst.CICS_DIM.CUST_KEY -- 4- and 3- part names here is being depreciated

FROM

stg.STG_CUSTOMER_INTEG

INNER...

You want something like this:

STG_CUSTOMER_INTEG

INNER JOIN mst.CICS_DIM

ON ((STG_CUSTOMER_INTEG.CUST_CIS_ID = CICS_DIM.CUST_CICS_ID)

OR (STG_CUSTOMER_INTEG.CUST_CRD_ID = CICS_DIM.CUST_CICS_ID)

OR (STG_CUSTOMER_INTEG.CUST_CSS_ID = CICS_DIM.CUST_CICS_ID)

...

where columnname like 'A%'

From what I have been reading, you don't have a problem. The mirroring is working just as it is supposed to work. Stop worrying until you have something...

kingstonnadar (2/13/2009)

---

;WITH cteCountSpeed AS

(

SELECTROW_NUMBER() OVER ( ORDER BY Col1 ) AS Row, *

FROMtblCountSpeed

)

SELECTC1.Col1, C1.col2, ( C2.Col2 - C1.Col2 ) / ( C2.Col1 - C1.Col1 ) AS QueryColumn

FROMcteCountSpeed C1

LEFT OUTER JOIN...

Mitch2007 (2/13/2009)

---

Thanks for the prompt reply Lynn.

Unfortuantly i'm not getting any results and this may be due to the DataType for the field I am using.

I have the Datatype as...

Well, My BS degree is a dual major in Computer Science and Business Administration and my MA is a dual major in Computer Information Resource Management and Space Systems Management...

All updates occur on the main server (for sake of this example FacilityID = 8888), and all records on this server have the FacilityID coded as 8888, correct?

All updates and...

Roy Ernest (2/13/2009)

---

Lynn Pettis (2/13/2009)

---

Ninja's_RGR'us (2/13/2009)

---

bitbucket (2/13/2009)

---

I think I have gained an insight into why some of the users questions appear to be soooooo, well not intelligent. Last evening...

Not much we can do without the DDL for the original tables/views, sample data for the tables, and expected results to test against.

Ninja's_RGR'us (2/13/2009)

---

bitbucket (2/13/2009)

---

I think I have gained an insight into why some of the users questions appear to be soooooo, well not intelligent. Last evening I attended a SQL...

How does the backup server know what its ID is?

The following will return the last day of the previous month:

dateadd(mm, datediff(mm, 0, getdate()), -1)

Personally, the queries, however, should be coded as a < and use the following:

dateadd(mm, datediff(mm, 0,...

Then scope_identity is returning null. Tried this, select scope_identity(), on my dev server, and it returned null.

I'd put an isnull() with a default value around your call to scope_identity...

littlebeeper110 (2/13/2009)

---

Project:

Setting up transactional replication for a large hospital system. Replication pulls changes from primary server to x-number of facility servers. Replication is setup and working correctly.

Issue:

Each replicated...