Chris,

Do you mean this:

retrieve unique products (prdID) AND the city it's in (postcodeID) AND the shortest distance to a reference city

Cheers

ChrisM

You have no data in your bargains...

Try this:

SELECT COUNT(*) FROM dbo.Bargains

Ah, it's a NVARCHAR!

Please run these in QA (or SMS) and post the counts from each statement:

SELECT COUNT(*)

FROM dbo.Bargains b

GROUP BY b.Client, b.CountryCode, CAST(b.ClientID AS NVARCHAR (10))

SELECT COUNT(*)

FROM dbo.Bargains...

pri.amin (12/5/2008)

---

Same error with this INSERT:

Msg 2627, Level 14, State 1, Line 2

Violation of PRIMARY KEY constraint 'PK_tblClients'.

Cannot insert duplicate key in object 'dbo.tblClients'.

The statement has been terminated.

Can I...

You're not accounting for the trimming of clientid when you extract from the bargains table and insert into clients table. But why all the fuss with views and DTS/SSIS whatever,...

Like this:

[font="Courier New"]SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE VIEW dbo.vwImportAllNewClientIDs

AS

SELECT CAST(b.ClientID AS VARCHAR (10)) AS ClientID, b.Client, b.CountryCode

FROM dbo.tblClients c

   RIGHT OUTER JOIN dbo.Bargains b ON c.ClientID COLLATE...

rbarryyoung (12/4/2008)

---

mtassin (12/4/2008)

---

I'm not sure if it's Business Object's best practice, but my best practices for Crystal Reports are to develop stored procedures to retrieve the data in exactly the...

Hi rhubbard

No problem, should be pretty straightforward. But first, can you explain what this chunk of code does? I'm lost...

NVARCHAR1(Topic), NVARCHAR6 (Meeting Room Name), datetime1 (Meeting Start Time), datetime2 (Meeting...

gregarobinson (12/4/2008)

---

Well, I cannot tell you what's different but I just tried this:

INSERT INTO [DEV001\SQL2005DEV].myDatabase.dbo.myTable

and it worked. "dbo" has always been present so that is not a change....

Can you post the whole INSERT statement?

INSERT INTO DEV001\SQL2005DEV...........

Not the INSERT, the SELECT. What does it...

Hi Greg

Some of our older servers have similar names and I've worked around it successfully by using square brackets, as you suggest.

Have you ran the SELECT part of your INSERT...

What's sp_MSforeachdb running?

What do you get when you run this:

select name from sysdatabases

where UPPER(name) LIKE 'ORTUSSEARCH%'