Thomw (4/23/2010)

---

Thank you Mr Magoo & Wayne Works like a charm.

I didn't realize that the sort order when pulling from 'two' tables made a difference. Is this because...

Here you go...Wayne had it just about right, but missed the sort order reversal required...

select [Datetime] = Manpower_Record_Time,

Unit_ID,

...

We will have to wait and see - maybe...

Assuming that Manpower_PK is an integer and is your Primary Key, and using just the data you posted, is this better for you?

--= set up some test data =--

declare @t...

Terry Mott (4/22/2010)

---

Nested transactions.

I should be able to begin / commit / rollback a transaction in a stored procedure without worrying about whether an upstream procedure has begun a transaction...

I would suggest you are calling it with too many parameters...

Can you post the code here for calling the proc...?

Can i just check that you meant to use the Access OLEDB to import an EXCEL table?

EDIT: ignore me - hadn't realised you can use that for Excel inm the...

Michael Meierruth (4/20/2010)

---

Wayne,

You state what I always wanted to hear stated, i.e. that ROW_NUMBER()'s ORDER BY is not the same as the SELECT's ORDER BY. Yet, always - haven't encountered...

In SSMS, find the function under msdb/programmability/Scalar-valued functions, then right-click on it and choose Modify (or script as create)

You need to specify the collation you want to use

For example

SELECT Table1.Column1, Table1.Column2

FROM LinkedServer.db1.owner.Table1 AS Table1

JOIN db2.owner.Table2 AS Table2

ON Table1.Column1 = Table2.Column1 COLLATE SQL_Latin1_General_CP1_CI_AI

Seeing as our versions are the same, you could "suck it and see" and use the code I posted to recreate the missing function - then hope that was all...

Restore msdb from backup?

You do back it up right?

Have you checked in the msdb database for the function it is trying to use?

On my system it looks like this:

CREATE function [dbo].[fn_DTA_unquote_dbname](@dbname nvarchar(258) )

returns sysname

as

begin

declare @unquote nvarchar(258)

set @unquote...

Paul White NZ (4/18/2010)

---

No, the ROLLBACK TRANSACTION would fail if the error had already caused the transaction to abort.

Use...

I personally prefer this version (modified code from previous post) as it has zero IO and is quicker on my machine by 13 seconds for 1,000,000,000 rows.

create function [dbo].[GetRange](@start int,...