Tag Info

New answers tagged

0

I found a solution to this problem. Create the following files: RemoveSubscriptions.bat: @echo OFF SET Server=http://localhost/ReportServer_MSSQL_2008 SET ReportUrl=/test/reports/testreport "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\rs.exe" -i RemoveSubscriptions.rss -s %Server% -e Mgmt2010 -v reportUrl=%ReportUrl% > %date%.log ...


3

Since I can't see your table structure and I don't know the size of your data, here's something that will return the right answer but may or may not need to be tweaked for performance. You can write a query that groups both created and closed tickets together by date. Although you could just write two queries and do a full outer join, I would guess you want ...



Top 50 recent answers are included