Since this is a SQL Server forum, I'll concentrate on SQL Server only, but in reality this investigation should start from the application-end and work down the application stack.

With SQL...

All code inside a table trigger is within the scope of the transaction that started the trigger. Fine in theory, in practice especially involving queries to other servers will...

This is because the UNION keyword combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in...

The next step is to determine why the query is being suspended. From here on you'll need to do some wait stats analysis. Maybe this article[/url] will help...

You'll need to cross-reference this with the actual query execution plan to see if it is reasonable or badly optimised.

This modified query will add the execution plans to the output:

SELECT...

See if you can modify the database connection string used by the accounting package to connect.

If so, try adding Language=British to the connection string and see if it solves the...

You'll need to include all columns referenced in the result set in the GROUP BY clause, except for columns that are wrapped inside an aggregate function.

So let's go through this...

This looks like a snowflake schema with a chain of slowly-changing dimensions.

You'll need to map how the original pfe subquery joins to the other subqueries and trace it...

You're welcome.

These forums don't have a "mark as answer" facility, however ask.sqlservercentral.com does 🙂

You can write a subquery that will return the min sequence number, and use that as an offset to the real sequence number value 🙂

Edit: This highlights why it is...

-- Set up test data

declare @test-2 table (

SequenceNumber int

);

insert into @test-2 values (1);

insert into @test-2 values (2);

insert into @test-2 values (10);

insert into...

The factor preventing us from providing an accurate answer is because we need a set of expected results in a tabular format that the query should generate from the sample...

When you install a named instance, the installer will automatically set the install directory name to something like C:\Program Files\Microsoft SQL Server\MSSQL10.{instance name} or something like that. You'll have...

Text, ntext and image are special data types that does not support the normal string operators.

If you want to concatenate, you'll need to cast each field into varchar or nvarchar...

Can you please confirm that the datatype is Text, as opposed to varchar(???) or nvarchar(???)?