Yes, paste the code into notepad, edit it so that it's right for your environment, and save it as a .bat or .cmd file. Make sure the path to...

I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could set up some...

Use a CASE expression in your SUM statement, something like this:

...

SUM(CASE WHEN Year = 2010 THEN Amount ELSE 0 END) AS Total2010,

SUM(CASE WHEN Year = 2011 THEN Amount ELSE 0...

In your attempt yesterday, you aliased your derived table with the name of table that already exists, which is confusing for me at least, if not for SQL Server. ...

Have you tried ALTER TRACE permission?

John

Is the SQL Server service running? What port does it listen on?

John

That's because there's no column of that name in your temp table. You need to break out your dates from the tale and join on those. That's why...

Your join is wrong. Try this:

SELECT so1.[Date&TimeofReading]

FROM #SPLITOUTDATA so1

LEFT OUTER JOIN TEST.DBO.d0003 d

on so1.[Date&TimeOfReading] = d.[Date&TimeOfReading]

WHERE d.[Date&TimeOfReading] IS NULL

John

No problem. What you need to do is LEFT JOIN the results of your SELECT DISTINCT statement to d0003 in the way that Scott showed you earlier. You'll...

OK, how many columns are in the table and how many values are you trying to insert? You didn't accidentally remove a comma from the SELECT DISTINCT list, did...

Take out the line of your current query that ends with "(AS [Date&TimeOfReading],", and replace it with my line. All I've done is STUFFed some colons into the date...

Excellent. Before we start, a couple of things I recommend you change if it's within your power. First, don't create and delete the Split_XML function every time. ...

Thanks. RUG_CLOB appears to be a staging table. Please can we see the DDL for the table with the Reading_Date column in?

John

Please will you post table DDL (a CREATE TABLE statement) and an example of a few rows that you are trying to import into the the database. What queries...

Choose your fill factor with performance in mind, not disk space. If disk space is the absolute priority, choose 0/100.

As I think you have realised, you must find time...