Google some FOR XML PATH queries and you'll crack this soon enough.

Do you have a unique key on this table?

Try this:

select

[SLA]

,[PCCode]

,[PrCode]

,[LocalID]

,[DateOfBirth]

,[Number]

,[ATariff]

,[DSeen]

,[MPI]

,[Service]

,[POD]

,[Device]

,[ActivityDate]

,[SeenDate]

,[DateActivity]

,[Period]

, Count(*) [Count]

FROM [PROV].[dbo].[DA]

group by

[SLA]

,[PCCode]

,[PrCode]

,[LocalID]

,[DateOfBirth]

,[Number]

,[ATariff]

,[DSeen]

,[MPI]

,[Service]

,[POD]

,[Device]

,[ActivityDate]

,[SeenDate]

,[DateActivity]

,[Period]

having count(*) > 1

Andy Hyslop (4/6/2012)

---

I got the impression that no...

So what? You're in a 2005 forum.

If I told you that my car was 'not working', would you know how to fix it?

Are you saying that it works when you run it manually but not when it is run as a scheduled job?

As far as I know, you cannot create a JPEG file with multiple pages.

I'm not sure exactly what those settings affect, but worth a try 🙂

Have a look in Tools / Options / Database Tools / Table and Database Designers / Column Options in BIDS.

Lynn Pettis (3/30/2012)

---

Phil Parkin (3/30/2012)

---

Jeff Moden (3/30/2012)

---

If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve...

Koen Verbeeck (3/30/2012)

---

The reason there's no error is probably because the For Each Loop thinks it has no access rights, so there are no files to loop over.

So I would...

Jeff Moden (3/30/2012)

---

If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve such an eventuality. ...

Create two new variables in...

Not in my opinion. In statements such as 'between a and b', it is generally assumed that 'a' is smaller, less or fewer than 'b', whatever a...

Koen Verbeeck (3/30/2012)

---

Phil Parkin (3/30/2012)

---

Or create a linked server on the TBL_A server to the server with the codes table. Then create a view on the TBL_A server which returns...