Please ask a question, rather than leaving us to guess.

Your SQL query can do this using FOR XML PATH...

OK. Please answer my other questions and describe what you mean...

Is it always after exactly 4 hours?

Have you checked the event log?

Does the job fail?

Looks to me like a formula error.

What about

=Sum(Fields!TotalSales.Value)-Sum(Fields!Budget.Value)

?

Your formula is doing this:

134,648.44 - 63,530.00 = 71,118.44

Please include sample data and expected/desired results too.

:blush: I forgot there was one. Yep, that should work. Not sure how performance compares with Unpivot in T-SQL, so staging might still be best if there is lots of...

Ah indeed. I just assumed that this would not be SQL Server to SQL Server, I admit.

John Mitchell-245523 (7/14/2011)

---

If you only ever will have the three account types, then you can do this in the code:

INSERT INTO MTable (Account_Code, Account-type)

SELECT Account_Code,

CASE LEFT(Account_Code,1)

WHEN '1' THEN...

Are all the inserts going into the same table?

asranantha (7/14/2011)

---

hi friends,

plese solve this and send my mail id =asranantha@gmail.com

...

Haha, that will give...

b.narasimhakumar (7/14/2011)

---

thanx for your reply but i have to do changes in SSRS only not in Data base.

when we compare all the fields of result set it is unique

from there...

Change your selection query to eradicate the duplicates at source.

You do not remember correctly -...