I imagine I am the oldest one to comment.. I was born in 1932 at the height of what is now called the "Great Depression". My dad was out...

You can remove the quotation characters by utilizing the REPLACE function. For example:

DECLARE @in VARCHAR(200)

SET @in = 'MAIN,0016861779528,"Dembo, Ron C","""Roulette"" or the Rules of Risk",0.00,,,"XX(205733.1)",2001,20020311,0,,'

SELECT REPLACE(@IN,'"','')

Result:

MAIN,0016861779528,Dembo, Ron C,Roulette or...

Remove:

WHEN NOT MATCHED BY SOURCE

THEN DELETE

Believe that is the source of the unwanted deletions.

A few more of us

How other members answered

Correct answers: 75% (6)

Incorrect answers:...

SanDroid (8/29/2011)

---

GSquared (8/29/2011)

---

I read a book about that once, by some guy named...

Thanks, terrific read. Now got to put sugar in my...

jdowling 65301 (8/26/2011)

---

Here's what it says. The first query ran fine, the sencond I ran against one of my local dbs and it gave me an error

INSERT INTO GrowthofDBEXEC sp_track_db_growth

Msg...

1. I reran the code that I posted earlier, using cut and paste...

Like most things in SQL Server the answer is It depends

What would happen if all the data currently in an SSAS database could not be accessed since unknown to yourself...

jdowling 65301 - Here is one way

-- Step 1. Create the table to save the data

CREATE TABLE GrowthofDB(C1 VARCHAR(20),C2 VARCHAR(20),DBNAME VARCHAR(100),FileGroupName VARCHAR(100),

LogicalFileName VARCHAR(100),PhysicalFileName VARCHAR(100)

,FileSize DECIMAL(10,2),Growth DECIMAL(10,2))

--Step 2 ......

Thanks for catching...

Recieved e-mail one hour ago from Pass

[delete]Nominated for the Pass Board of Directors[/delete]

[correction]

The 2011 Nomination Committee (NomCom) – a team that assesses and reviews all PASS Board of Director...

Very nice ...

My son lives in the Tidewater area (Virginia Beach), at the time of the tremor he was driving and felt nothing ... but when he stopped at his destination some...

How are you designating the second range ?

Is it something like this Sheet2$a4:c

I have been away from DTS for too long but do remember finding a great deal of help...