Amazon's stock changes frequently. When I search now, there is only 1 item for 2k5 developer for $299 and it's a used copy. Thanks for the info, I will keep...

Changed to LEFT OUTER JOIN and the data I expect is showing up. My Bad! 😀

Thanks for the help!

In table1 the collation for the provider column is: Latin1_General_BIN

In table2 the collation for the provider column is:SQL_Latin1_General_CP1_CI_AS

I updated the sql below and the statement executes successfully yet there are...

Within the project properties in BIDS, there is also a 'TargetReportFolder', this would be the folder name from the root directory.

So, if you had a folder named 'Test' you would...

If you search around on the web you will probably find other connection strings that people have used, which may or may not work in your scenario. Below is the...

The site referenced below will show you the configuration changes to make.

Configuring Reporting Services to Use SSIS Package Data

I recently had a project which involved using SSIS as a reports...

I turned on some logging for the SSIS package and was able to determine that it was a permissions type error. In the SSIS package I was writing the dataset...

Karen L (1/12/2010)

---

Yes, you can do it. Little tricky though. This is the best source I've found for how to set it up

http://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx

I've also used straight...

It seems like it would be possible since you can configure SSRS to use SSIS as a datasource per Microsoft. I've done the configuration part in SSRS, now I'm just...

Thanks for the suggestion. I will give that a try!

You do provide an excellent solution however the WHERE clause in the parent query will contain conditions on the proccode column which have yet to be implemented. When those conditions...

SELECT

a.provcode

,(SELECT COUNT(DISTINCT acctno)

FROM charge_t

WHERE

dateofservice = '11/16/2009'

AND priinstype = 'R'

AND curinstype = 'R'

) AS 'Patient Count'

,(SELECT COUNT(proccode)

FROM charge_t

WHERE

dateofservice = '11/16/2009'

AND priinstype = 'R'

AND curinstype = 'R'

) AS 'Procedure...

Since transaction replication is written to the secondary database, does that mean that the entire secondary database is read-only? For example, if we only have 5 tables being published from...

Thank you Jack for the helpful information. I created a function to split out the parameter data and this seems to best solution for what I need to accomplish.

srisagar_p (2/24/2009)

---

Dear All,

I need a quick reply which helps me a lot to proceed my work.

I need a solution that will dumps the Activity...