Darn it! I'm sorry. Lost track.

OK - continue where we left off. I assumed that you wanted to eliminate the nulls because the sample data that you presented...

fwiw - it doesn't like dashes ( - ) either

Well, I think

is just gorgeous. It never ever occurred to me to do such a thing. Shucks.

Man I love...

would this be a good use of Except?

Something like

select * from mytarget

except

select * from mysource

I've not had an opportunity use it myself.

This quote:

..there are features in SQL Server MySQL has no complement for. Security is one particular area where MySQL trails Microsoft – unlike SQL Server, MySQL has no concept of...

david.howell (3/13/2012)

---

You can,...

Eugene is correct in asking you to provide more info, however I was a little bored so I threw this togehter. Since your requirements were a little vague, the...

Here is a MS forum entry that might help you..

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/5c927e16-e769-42ca-8b65-0cd39c3bd67c">

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/5c927e16-e769-42ca-8b65-0cd39c3bd67c

I'll be in a meeting for a few hours. I'll try to take a look at this when done.

easy = good !

😀

Please see the attachment for screen shots and step by step instructions. Essentially:

Create the dataset

Insert a matrix

drag Category field into Row group

drag NoOfItems into Data cell

drag subcategories between Category...

Howdy, it's kind of hard to tell from the screen shots, but it looks as if you've created a matrix, then inserted another tablix into the first matrix cell....

Looks like you copied the 2nd half of the formula from another field. Remove the 2nd = sign.

=(Sum(Fields!FEE_transactionAmount.Value, "DataSet1") + (Sum(Fields!FEE_OptionCost.Value, "DataSet1")

SQL_Enthusiast-AZ (3/5/2012)

---

Never mind. I used a variable plus RIGHT

EXAMPLE:

DECLARE @mask VARCHAR(30)

SET @mask = 'XXX-XX-'

SELECT

p.FIRST_NAME + ' ' + p.LAST_NAME,

(SELECT...

I'm sure there are fancier and better ways, but here is a simple method with some self-joins (and a test table):

CREATE TABLE #RefIDs (OldID int, NewerID int)

INSERT INTO #RefIDs

VALUES...