Search results for query: *

I have a table with members, referralnumbers and 2 dates: effectivedate and termdate. At the [highlight #FCE94F]member[/highlight] level, I want to find 2 referralnumbers that together their respective date ranges span 1 year. For example: Member Jack Beanstalk referralnumber 12345 spans from...

System is MS SQL SERVER 2008 R2. I have a field in a table called Clinical notes. The data types is longdesctype(text). Within this field is kept running notes from every user's data entry. Our system (Trizetto) logs each unique entry with the date and an 8 digit username between chevrons. For...

I'm running SQL Server 2008 R2, and SSRS Visual Studio 2008. Here is a question I received from one of my users: Can you include an Action Date in the report so I’ll know if we’ve already seen the member on the report? Is there a way in T-SQL to code for "new" data? I have a report that runs...

WE have BI Management Studio 2008, 3.5SP1 and we have many reports in SSRS. Is there a way to search all reports for particular table names? WE have to upgrade data in the tables and we would rather not go thru each report manually searching code. Thanks for any help in advance.

[ponder]How do I program SSRS to print specific data to a new page? for example, data looks like this: Hospital A Mark Twain Hospital A Bill Murray Hospital A Robert Klein Hospital A Will Smith Medical Clinic B Mark Twain Medical Clinic B Bill Murray Medical Clinic B Robert Klein Medical...