In the original post you only state the vlues of a single row. From your last reply it looks like the value in the TotalTime (TT) column is quite different....

When using a third party backup application, an external process from this third party could lock files and/or processes. When cancelling a backup job within SQL, you'll need to manually...

Correct, the initial file can not be removed.

But by executing the DBCC command with the EMPTYFILE option,...

You are not able to deleted the primary log file. Empty the second logfile with DBCC SHRINKFILE ('name' EMPTYFILE) and follow this statement with a delete file statement (alter database...

replace the number 540 with the code below:datediff(minute, '0:00:00', convert(nvarchar(5), TotalTime, 114))The code will return the difference in minutes between midnight and the time in column TotalTime.

Then you'll need to cast the columns to the same type. I don't know how the column type is defined,...

You'll need to join the seond table twice to the first table, like:select

table1.col1

, table2_a.val

, table2_b.val

from table1

inner join table2 as table2_a

on table1.col2 = table2_a.id

inner join table2 as table2_b

on table1.col3 = table2_b.id

...

Duplicate post: http://www.sqlservercentral.com/Forums/Topic1459051-1292-1.aspx

The answer to what you are asking is Select DISTINCT Col1 from test where Col2 = 'vat' or Col2 ='cess' or Col2 ='bed'.

But what is the result you want when...

When you do a SORT action in a query, the sorting is executed in [tempdb]. Although you haven't declared any [tempdb] tables in your query, the query still uses [tempdb].

Check...

A DELETE statement with the OUTPUT clause is just one statement. It will be rolled back completely. That includes the INTO part.

The discussion on this link http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e0e7fb1c-0327-4833-b9fb-8a660b5389ca explains it.

You could put in some effort by yourself before posting. Just a simple search on internet will give you several links, like

http://msdn.microsoft.com/en-us/library/ms143711.aspx and http://www.mssqltips.com/sqlservertutorial/227/install-reporting-services/

Once you have created a SSIS package from the import/export wizard, you know the connection managers are correct. You can load the generated SSIS package in BIDS and adjust it...

I've had the same issues some time ago. In some cases it was a misconfigured MSDTC setting on one of the servers. But in some other cases I could not...