please provide create table scripts for all tables involved in your query, sample data for each table and expected outcomes based on that sample data

Then you will need to lookup dynamic pivots and dynamic cross tab queries.

Part 2 of the links provided goes into dynamic cross tabs, and lots on dynamic pivot queries on...

Looks like you need a cross tab query, there are two links in my signature by Jeff on pivots and cross tabs which would help you out.

If you get stuck,...

What is the frequency of your backups, copies and restores?

Simply do a string concatination on the existing version value.

update vehicle set version = version + ' BT' where unitnr = '140'

Ok then "Ensure SQL is Stopped" as the first step.

And yes SQL will start if TempDB is corrupt as it is recreated every time SQL re-starts.

Your question was on what...

1. Stop SQL, replace the fault disks which make up the F drive, once all ok start SQL

2. Stop SQL, start SQL in Master only mode, alter the file locations...

There are limitations with SSRS 2008, it still uses the old Excel structure so your limited to 65535 (approx) rows and 256 columns, if you want more columns you will...

Something some where is trying to put a value like ABC into a column which will only take a value like 123.

With such a large procedure, take it a chunk...

ccappel (8/31/2012)

---

Thank you for this thread...I have been dealing with this problem for years without resolution. Just to make sure I understand the gist of the problem:

1. The...

Yep, you plan is right in theory.

You would pass in a sql file to SQLCMD using the -i switch and then wrap the whole SQLCMD call into a bat file...

A repair didnt work, failed with an error saying the services didnt install properly so had to do an uninstall re-install.

Reading further into the error, it seems like it was...

You will need to alter every column in every table to match the new collation, then alter every table, then alter the database

Or

Create a new DB with the right collation,...

Well your violating the licence terms of the evaluation edition running it in a truly production environment, it should be licenced accordingly.

Evaluation is to ensure that the software will do...

Something is activly using the log then.

The first link on why is my transaction log full should help to find out what is using so much log space.