SQL_Nw (11/16/2011)

---

Thanks for your reply.

I added defaults for @report_start and @report_end as for yesterday 24 hours 00:00 to 23:59, but even If i schedule it every 8 hours, the...

This is probably happening because the values for those parameters are expected in the report.

My suggestion would be to create defaults for the parameters in the report with the necessary...

Have a look at the following: http://sqlblog.com/blogs/kevin_kline/archive/2008/10/09/ssis-packages-need-love-too-er-memory-too.aspx

I think the resources listed there will provide the necessary information.

jean.gelinas (11/8/2011)

---

Using the following in a text box on a local report included in a VS 2010 c# project:

= Switch(

Fields!BeneficiaryType="PERSON","Name:",

Fields!BeneficiaryType = "TRUST","Trust Name:",

Fields!BeneficiaryType = "Charity","Charity/Organization:",

Fields!BeneficiaryType = "ESTATE","Estate Name:")

Getting the following...

Definitely not a SQL Agent issue.

One or two things are coming to mind that may cause this...the first is drivers (32/64 bit). BIDS is a 32-bit environment, and will...

I guess the only possible con is that...

raotor (11/3/2011)

---

OK, Here's the query:

SELECTCOUNT(Price)

FROMTempSales

GROUP BY Price

ORDER BY Price;

I'm afraid as I'm so green with this forum you'll have to tell me the best way to attach the execution plans...

I also think that SSIS is a great tool, if you use it appropriately.

The ease of use is sometimes the product's biggest downfall. I see too many people who...

onlo (11/2/2011)

---

Currently, to create a Analysis Server database role, the only way I know is : create a rolw within the Visual Studio of the Analysis Services Project.

However, I am...

Yes, you do need a "FROM"-clause. The CTE's can be used as tables in your final query.

As far as I know, "Isnull" is not a valid Excel function so it cannot be used in queries against an Excel connection.

You would be better off extracting all the...

I tend to agree with Elliott on this one.

If you separate SSIS from the SQL Server instance, there are definitely a few trade-offs which in my opinion is not always...

David Lester (10/26/2011)

---

You do have the right idea. One to One for all but a single client, whom is one to many. While there is no guarantee this will...

David Lester (10/26/2011)

---

I have a warehouse where there is a product code field, and this is 99% of the time queried for a single product code, which matches to a...

Hi,

How about using a recursive cte?

Read up about it in BOL...that should work.

Martin.