Hello and welcome to the forums.

In your table definition, column 3 is TaxClassID and is an integer. In your data file, column 3 is a decimal numeric.

If I'm interpreting...

It isn't necessary to post in more than one forum. It just duplicates effort for those helping and fragments any answers you get.

Direct replies to http://www.sqlservercentral.com/Forums/Topic1579175-148-1.aspx

Or maybe the DBAs looking at the editorial agree so completely that there's nothing more to say. I myself sometimes wonder if the SAN administrators get a bonus for...

Minnu (6/10/2014)

---

Hi team,

created a job to delete all the records from table 'Unify 'daily. i want the same job to take the backup of table before deleting the records.

Is it...

zedtec (6/10/2014)

---

Ok I will check that thanks.

I have also tried to restore by adding my .bak file onto a folder on the C drive locally.

When I try to do a...

Klingon

I learned something new today, so thanks for the question.

GilaMonster (6/9/2014)

---

Ed Wagner (6/9/2014)

---

Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have...

I don't know this for sure, but if you're selecting p.subjectnumber, it looks to me like that's the patient number and you want a total per patient. If you...

I don't see what the problem is either. Perhaps you could explain what you mean.

However, I did notice that you're comparing a varchar column against an nvarchar value. ...

Castle

Page

If the load needs to be repeated, I've always found a stored procedure that uses bulk insert to be very reliable. Create your format file and your staging table...

You need to put your return statement in an IF, not in a SELECT. Example:

IF @isExist = 'No'

RETURN;

I have to ask why you have a database that hasn't been backed up in 2 years. I don't know what you mean by it being "stand alone", but...