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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BIExperts

    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...
  2. BIExperts

    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...
  3. BIExperts

    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...
  4. BIExperts

    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...

Part and Inventory Search

Back
Top