LutzM (6/1/2011)

---

Google is your friend in this case:

I searched for "The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020" and the first...

Could I please ask you for another favor ? I am stuck with this one:

http://www.sqlservercentral.com/Forums/Topic1115231-149-1.aspx

Lutz, Your help would be deeply appreciated.

Thanks and...

Hi Lutz,

I was stuck with another issue and your solution resolved that one as well. You hit two birds with one...

You are the Man, Lutz !!!!! Genius !!!

Thanks very much !!!

Actually that is the problem I...

I have tried remaking the parameter but still get an error. Also, the thing is the @From part still works...

When I change the datatype to datetime in the report parameter, it gives...

Changing...

Thanks again.

The datatype of the create-dt field in the table is datetime. The parameter is...

Ninja's_RGR'us (5/24/2011)

---

I'd check to make sure that the @To is not set to 2011-05-01 and actually set to 2011-05-31.

I personnally preffer to use < 2011-06-01. I can't tell you...

Thanks for your reply. both @from and @to are set as String datatype in the report...

Davin21 (5/23/2011)

---

The issue seems to be that you are grouping by the field which shows the aggregated value

Try Select count(CREATE_OFFICE_TEAM_CD), CREATE_DT as create_dt from MF_FORUM

where WORKFLOW_ACTION_CD IN ('D', 'A')

and...

sqllearner-339367 (4/7/2011)

---

Paul,

Creating a report with aggregation for database less than 10,000 of rows can be achieved using T-SQL queries. Consider if you want to analyse the database having millions of...

stevefromOZ (4/5/2011)

---

Excel definitely comes to mind. Most of the other major vendors (e.g. IBM Cognos, SAP BO) support querying SSAS cubes, so if you have these on hand, they...

GSquared (3/25/2011)

---

In that case, don't do it in a trigger, unless the trigger is in a database that has absolutely no performance implications at all, and can deal with dropped...