Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can't Login and Deploy SRS 2008 business Intell.. report
Hello, At first, check the SSRS project settings (right-click your project -> Properties), especially the target server URL (should look like http://localhost/ReprotServer for the default intallation settings; you have probably set the value to http://localhost/Reprots). Then you need to have...- BIExperts
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How to run results of query to a text file?
In SQL Server 2005 or higher, you can write a CLR stored procedure and save the data using .NET framework classes. You can also use Integration Services (replacement of DTS) to export the data into .csv file. Start Import/Export Wizard from Object Explorer in the Management Studio and follow...- BIExperts
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How to 'flatten' a table?
I would definately use UNPIVOT operator, because it geneates better execution plan: SELECT Customer, Month, Amount FROM (SELECT Customer, [Month 1], [Month 2], [Month 3] FROM pvt) p UNPIVOT (Amount FOR Month IN ('Month 1', 'Month 2', 'Month 3') ) AS unpvt As Denny wrote...- BIExperts
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Curious if it is possible to....
If you want to access file system in SQL Server 2000 (or do other operation outside of SQL Server), you can generaly use an extended procedure. It is coded in C according to given API (see books online for more information). You can also use SQL Server Agent to run a job with Operating System...- BIExperts
- Post #4
- Forum: Microsoft SQL Server: Programming
