Yes - this can be done in a tabular report. Based on your requirements, you can place a combination of date, store, item, and partner into a group. Then you...

Balaji,

Is there a particular reason why you're using a Matrix instead of the tabular report? By looking at your attached document, I don’t see the need for it. You...

How about:

SELECT ID, PersonID, YEAR, Amount

FROM YourTable

UNPIVOT

(Amount FOR MONTHS IN

(JanAmt, FebAmt, MarAmt)) AS U

What are you trying to accomplish?

Jason,

Why would you want the field in the query and not in the result? I've seen this in MS Access when building the query via the GUI, but that is...

Take a look at http://www.sommarskog.se/arrays-in-sql-2005.html#CSVand see if that help.

Eli

I'm not sure about your second question, but for the first - you can use and output parameter on your inner stored procedure which can indicate whether it completed successfully.

I fixed this by changing the Data Source from OLE DB to ODBC.

Is this what you were looking for?

SELECT Col1, Col2, Col3

FROM Table1

WHERE (Col1 = x AND Col2 = DATEADD (HOUR, -24, GETDATE()) AND Col3 = x) OR

(Col1 = x AND Col3...

I have come across this problem in the past and found that it was caused by a NULL value in the dataset. Try to update the query so that the...