Save them to the file system, then import them into the new SQL instance.

You'll need to move the subquery into the From clause as a Cross Apply or a derived table that you can join to. That will mean the data from...

It looks like you're doing this in a more complicated fashion than you need to.

The easiest way to get missing ID numbers is to compare the IDs to a Numbers...

John Mitchell-245523 (12/14/2010)

---

I think the CONVERT function is what you're looking for. Or you could allow the data layer to store the data and leave the formatting to the...

This has all the data on formatting dates in T-SQL: http://msdn.microsoft.com/en-us/library/ms187928.aspx

Honestly, though, you should be formatting dates in the presentation layer, not in the database or data access layer. ...

Nested outer joins can do weird things like that. Glad you got something working.

GilaMonster (12/13/2010)

---

Seriously?

Use the one most suited to what you're trying to do. You don't get prizes for the fanciest, most complex way of writing code.

If you're trying to round up...

You're welcome.

Craig Farrell (12/13/2010)

---

Hmm. Guess I shoulda double checked the older format. It will work for VARCHAR(MAX), however. ...

Are you familiar with using Round() and adding .5 to the value?

DECLARE @Number DECIMAL(9, 2) ;

SELECT

@Number = 12300 ;

SELECT

@Number AS Original,

...

Hadn't thought of that, with regards to Access doing that. Yeah, that makes sense.

It's what ceiling is for. If you don't want to use it, you'll need to build a version of it. That won't be hard to do if you...

Create a Calendar table, or use a Numbers/Tally table (physical or virtual).

It'll look sort of like the below.

DECLARE @StartDate DATETIME;

SELECT @StartDate = '12/1/10';

;WITH

Numbers (Number) AS

(SELECT TOP 32 ROW_NUMBER() OVER (ORDER...

What edition of SQL Server are you running it from?

Have you checked the Windows server logs for anything odd during the backup?