Try pivoting first then add.

SELECT

[ID]

((AA+CA)-(DA+DB+EA)) AS MyCalc

FROM (

SELECT

[ID],

SUM(CASE CODE WHEN 'AA' THEN Amount ELSE 0 END) AS AA,

SUM(CASE CODE WHEN 'CA' THEN Amount ELSE 0 END) AS CA,

SUM(CASE CODE WHEN...

Great to hear.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Could be locking and not releasing in a timely fashion. I could not find details on this but I do know that it does lock the data it is pulling...

Do this all the time to seperate read tables from read/write tables and have never had an issue with single Backup file (Just test them periodically to make sure no...

This is a good place to start and there is a link for Enterprise Edition datasheet at the bottom http://www.microsoft.com/sql/evaluation/overview/default.asp

"Don't roll your eyes at me. I will tape them in...

Most Painless yet, but always backup your data as Steve states, because anything could happen when least expected.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Try this, I did change a bit to conform more to TSQL format and hopefuly make easier to read. This should handle it.

SELECT

a.call_id,

uc.customer_name,

a.call_status_value,

dateadd(second, a.status_time_stamp,'1/1/1970 12:00:00 pm')...

This is called a pivot table which if is unknown number then there is a piece of code I post in scripts you can use as a blue print to...

The use

SELECT DATEADD(seconds,DateFld,'1/1/1970') AS dateoutput FROM TableX

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Or

SELECT replicate('0',7-LEN(field1)) + CAST(field1 AS VARCHAR(7)) as field1 from the_entity

but you will need to cast field1 to a varchar to make sure concatination does not come up a numeric...

It may be due to the account you are using to connect to the servers in EM. Check your registration properties for how you are connection to both and make...

Can you post the code you are using and the paramteres of the Oracle Procedure. Also I don't know of a way you can create the variable for oracle to...

Yes, it is similar to return a concatination, a null in any value will return a null. I am sure that it uses the same check mechanism.

"Don't roll your eyes...

Check out "INF: Network Encryption Available Using the Multi-Protocol Net Library (Q132224)" at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q132224

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Check out "PRB: "Unspecified error" Error 7399 Using OPENROWSET Against Jet Database (Q296711)" at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296711

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)