I modified your data and tried to use ChrisM's code.  I added a value to C2 in #T3, Chris's code still says C2 is NULL on all 3 tables.  I...

Since your 3 tables have the same layout couldn't you union them together into one table then check that one table's columns for NULL?

If you are working with...

Your statement:
Nested case stmt
(case when gn.glacctid = 25 then t.amex end ) +
(case when gn.acctid = 26 then t.vmc end) +
case when gn.acctid = 22 the...

What about using what I like to call a 'stacked' table to put this in?  You use the unpivot, in combination with a prior post on getting the column names. ...

IMHO, never ever use spaces.  Use underscores to make it more readable to the users.  I prefer underscores to camel, but I usually follow what the 'standard' is for the...

I would not pay for anything, if the company wants me to try something then they can pay for it.  If I was asked to pay for a mistake I...

IMHO I would try removing the SUM and group by from the 'meat' SQL, since you are summing the data in the other SQL.  I'm not saying it will help...

Here is what I've used to search for fields within SSIS packages(dtsx files) stored in the MSDB database.

--Connect to database:  msdb
SELECT [name] AS SSISPackageName,

I guess I wanted this because of the reason I needed it last year.  I used to have my work email address associated with my account. Password was being saved...

If you want to do it with Substring and CHARINDEX here you go.
<SQL>
DECLARE @testVARCHAR(500);
SET @test-2 = 'http://stable-test.test.net/api/files/fs.testcollection/TP-0000000.pdf/download/';

SELECT SUBSTRING(@test,
CHARINDEX('/', @test-2, CHARINDEX('/', @test-2, CHARINDEX('/', @test-2,...

I think this would work.

SELECT SUBQ.issue_number, SUBQ.type_code, SUBQ.alt_type_code,
SUM(SUBQ.data_value_1) AS data_value_1_sum,
SUM(SUBQ.data_value_2) AS data_value_2_sum
FROM (SELECT issue_number, line_number, type_code,
CASEWHEN alt_type_code IN ('NONE', '')
THEN '00'...

Back in the mid 80's I was going to school at DeVry in Kansas City.  We had to submit our COBOL programs to compile during our one hour lab time....

Here is what I came up with:

SELECT ISNULL(ac.code, b1.code) AS code, a2.aname, b1.bname, ac.cname

FROM (SELECT a.code, a.aname, c.cname, ROW_NUMBER() OVER (Partition BY a.aname ORDER BY a.code, a.aname) AS RNO

FROM @a...