Okay, I may be missing something, but how do you accidently mirror a database?

It is really hard to know the problem when part of it is in the header and not repeated in...

anthony.green (7/27/2012)

---

Thanks Lynn I will give that a go.

I just took Cadavre's solution and change it to a iTVF and craeated a test view and it took 13 seconds to...

Does the following query meet your requirements?

with BaseData as (

select distinct

[SID]

from

dbo.table3

), CIDData as (

select

bd.[SID],

t3.CID

from

...

Or, for the SID in table3, you want a distinct comma delimited list of CID's from Table3 and Table1.

You are saying that the SID in table2 does not relate to the SID in table3?

What I think I see is that for each PID in table2 you want a...

There could be many cuases for this. There really isn't enough information here to narrow it down. It could be due to the size of the inserts/updates to...

One piece is missing for my understanding, without the concatenation if I were to query the tables, how do they relate to one another, and based on the sample data,...

You do know that you had everything there you needed to do this, right?

here is my code, with your WHERE clause commented:

SELECT

j.name AS JobName,

...

I'm trying to figure out how the tables relate first, so I can figure out how the final result set is to be built. Think I could get 5...

anthony.green (7/27/2012)

---

The tables are as follows

CREATE TABLE [dbo].table1(

[PID] [int] NOT NULL,

[CID] [int] NOT NULL,

CONSTRAINT [PK_tbl1] PRIMARY KEY CLUSTERED ([PID] ASC,[CID] ASC)

)

GO

CREATE TABLE [dbo].[table2](

[PID] [int] NOT NULL,

[SID] [bigint] NOT NULL,

CONSTRAINT [PK_tbl2]...

Oh, and the expected results based on the sample data.

Thanks.

Not exactly sure what is happening, could you post the fdl for the table, some sample data, and your code so I can play a little?

Hate to say it, but I posted a reply. When I started it, Arron had not yet replied, but when I posted it, he had. I hope what...

I guessed wrong on Replication.