Sign doesn't get him precisely what he's looking for, but it could probably be used. And it does reduce even further the typing required. 🙂

"Direction" isn't a type. It's a column with type Char(1), and a constraint to make sure it's only either "+", or "-".

It looks like I missed a close-parentheses at...

That looks like the query that will do what you need. What am I missing in your request? What help do you need?

All of those go under one trade ID in the details table.

Let's say it's trade ID = 1.

select TeamID, PlayerID, Direction -- Raw data

from dbo.TradeDetails

where TradeID = 1

order by DetailDate

or

select...

Do you want to update the table, or do you want to remove the spaces in a query?

If you want to update the table, here's one way:

set nocount on

update #test

set...

I'm assuming that Customer IDs aren't shared between databases. Is that correct? If so, then best-match on name is possibly all you can do. You might match...

To find which team a player went to, you can query all trade details with that player ID, or you can join between details with + an - in the...

How long does the first transaction run before it errors out?

Check out these articles and their discussions. All kinds of data on how to keep track of what's been changed, when, and by whom:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

In your data flow object, you can select an XML data source, and pick a file for the connection for it. Then you can make the file variable and...

If it's columns in a table, then you can use Unpivot and either the sum() - sum(abs()) calculation, or the 0 > Any function. Either will work.

Edit: And, had...

That would still work with a ledger type structure. It's just an easier data structure to deal with, and it will do what you need on that.

I also don't have definition and data for dbo.Audits_Comments.

I took a look at the code, and I need to know if this is a valid statement of the relationships between the various tables:

select *

from dbo.Audits

inner join dbo.Audits_InspectionItems

on Audits.AuditID...

Since the original example is using a string-split function to break it into rows, I'm pretty sure that's the desired input. But I think he already has what he...