This is one way.

DECLARE @TicketStartDate datetime

DECLARE @TicketEndDate datetime

SET @TicketEndDate = DATEADD(DAY, DATEDIFF(DAY, -1, GETDATE()) / 7 * 7, -1)

SET @TicketStartDate = DATEADD(DAY, -8, @TicketEndDate)

PRINT @TicketStartDate

PRINT @TicketEndDate

Also search this...

This sounds familiar to me but I forget the specific issue.

I ended up scripting out the linked server created by the wizard and then modifying that script.

I guess this is why you guys say show us what you have tried. This demonstrates the results I am looking for. I'd like to get this in one select...

Sorry for being unclear. Let me add to the narrative now and then see if I can work out the desired results.

If I exclude record 1 then my total is...

I agreed with Gabe because I have the distinct advantage of seeing the actual data which would result in duplicate data. Since this is more of a reporting/data warehouse I...

Thank you both (and Dwain)!

Agreed and thanks for the correction.

I would look at exporting using OPENROWSET.

You could probably use SSIS to call a single package multiple times. Pass the state as a package variable. Use the variable to create...

Thanks for the insights everyone. I will take me a bit of time to review/understand the methods. I'll post back if I have any questions.

Last fleeting thought. I might explore replication. My initial and brief research indicates that filtered replication may be possible. If this is correct it may be easier than writing the...

Sorry I responded too quickly and my suggestion won't help since you need to purge the primary.

I have seen commercial applications that archive data into a separate but identically structured...

Can you restore a backup to your reporting server?

pietlinden (9/25/2013)

---

One option might be to use Access (shudder, I know) to create a linked table that only links to the data you want and then export that back to...

http://sqlmag.com/sql-server-reporting-services/ssrs-how-create-reports-user-protect-sensitive-data

There seems to be some important security considerations here.

I would attempt to pass the userid as a parameter to a stored procedure and NULL the column there rather...

http://www.mssqltips.com/sqlservertip/1084/dynamic-flat-file-connections-in-sql-server-integration-services/

Try this and let us know if you run into any issues.