Works for me on SQL 2000. What error do you receive?

A bit more sample data and perhaps some DDL would go a long way towards getting you an answer, helping us to help you.

In the meantime you may want to...

For a 10 digit phone number, I'm guessing it's already a character datatype and not an int so there would be no need to cast it. You can append...

Your other option would be to look into using SSIS...

You could specify a text file datatype and use SSIS to output and transform it however you need. it's very...

Guess I forgot to answer the original question...

SELECT cast(col1 as varchar(10)) + CAST (Col2 as varchar())

For the nulls you could use cast(isnull(col1,'') as varchar())

The only way to combine all of those types is to get them into a varchar datatype.

The real question is why do you need to combine the columns?...

This is somewhat convoluted, but it should work... though I don't think it would scale terribly well, it should get you moving in the right direction...

create table #test (

Date int,

Time...

This should be fairly straightforward, however I do have 1 question for you. The time portion, that looks like it might be the number of miliseconds or some other...

I've never had the opportunity to work in an environment where I've had to squeeze 10 ms out of my code to make a drastic difference. I've always maintained...

you could have a look at the below link and see if it fits the bill...

http://www.sqldts.com/214.aspx

Right, the step never completes so it can't move to the next even using on completion...

Your problem is here...

- SQL Server Edition Operating System Compatibility (Warning)

Messages

* SQL Server Edition Operating System Compatibility

* Some components of this edition of SQL Server are not supported on this...

If you are looking for worst performers, you might want to take a look at setting up a profiler trace and then reviewing it. Just be careful a) where...

You may want to check for certain services starting/stopping as these will mostly be informational alerts. although you could also check that information through wmi or various other means...

More than likely the clones do some sort of compression on the large backup files, which is why something like Redgate's backup product or Litespeed or whatnot may offer some...