Are you connecting to an SQL2000 database in ssms 2008 or trying to open SQL2000 DTS packages that where deployed to SQL2008 R2?

If its the former then I would suggest...

Some of the best articles I've read are by Gail (GilaMonster) and are well worth the read as well as those above, http://sqlinthewild.co.za/index.php/category/sql-server/indexes/

Ok there is this that may be worth looking at http://www.sqlservercentral.com/Forums/Topic1237043-392-1.aspx

Which discusses a similar problem and may be adaptable to your needs.

Eugene Elutin (11/2/2012)

I do feel sorry for you mate... I guess I would be in the same position as you if I would be asked to fix ballet libretto......

Ok, progress, first does it look like Compare1 should equal compare2, can you post some sample data (5 rows) from the select you've just run?

The reason you got that error...

We arnt interested in matching those in SQL at the moment this task is there to allow the developer to have a look at the data that is being retrieved....

Ok, so I've now put in an impicit cast on each column of Compare1 and Compare2, there was also an error on the Useby column which I'd missed.

SELECT

Gender =...

Run this select without any alterations.

SELECT

Gender = P.Fsex,

MartialTypeID = P.Frelation,

Lastvisit = P.Flastvisit,

NxtVisit = P.Fnextvisit,

LastTxNumber = P.Flasttxno,

OldAcct = P.fOldAcct,

ClaimGroup = P.fClaimGroup,

ConsultDate =...

What is the size of the file?

Can you open the file in notepad in Windows?

kapil_kk (11/2/2012)

---

Yes, PL.ChartNo is numeric...

LocationId+'-'+Chart_no will comes as 1-1 not ASD-12

Also,

how can I update as a Select and dropping the where clause adding in (L.locationID+'-'+P.Faccount+'-'+P.Fpatient) and (PL.LocationID+'-'+PL.Chart_No)...

Basically just remove the Update and SET and replace them with a Select

SELECT

Gender = P.Fsex,

MartialTypeID = P.Frelation,

Lastvisit = P.Flastvisit,

NxtVisit = P.Fnextvisit,

LastTxNumber = P.Flasttxno,

OldAcct =...

Ok, this indicates that PL.ChartNo is a numeric is that correct?

In which case why would this LocationId+'-'+Chart_no (Possible "ASD-12345") ever equal Location_Id + '-' + P.Faccount+'-'+P.FPatient which has a possible...

you would proably have to create a table that had the Rid's gor each group.

eg

CREATE TABLE #Groups (

GroupStart Int

,GroupEnd Int

,GroupName char(10)

)

CREATE TABLE #RawData (

RId Int

,StartTime dateTime

)

Insert into #RawData

values(1,'2012-11-02 12:45:18.540'),

(2,'2012-11-02...

The questions is do the strings on either side actually match?

If you turn the Update into a SELECT, and add these as columns

(L.locationID+'-'+P.Faccount+'-'+P.Fpatient)

(PL.LocationID+'-'+PL.Chart_No)

Does (L.locationID+'-'+P.Faccount+'-'+P.Fpatient) =(PL.LocationID+'-'+PL.Chart_No)

You...

Duplicate post removed.