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

    Enabling web access for 2005 Reporting Services reports

    How do I enable remote web access so that end-users can view reports generated by SQL Server 2005 Reporting services? I have already created reports that can be viewed by using http://localhost/reports from the SQL Server 2005 machine but I cannot access them through a browser on another...
  2. againstTheWind

    CPU core voltage is low

    According to my Intel hardware monitor software that came with my D975XBX board my CPU core voltage is running around 1.188 when it should be running around 2.05. I just built my first system with this board and I don't know if this is a significant problem or how to fix it. I would greatly...
  3. againstTheWind

    Operating temperatures for Core 2 Duo E6400

    I just built my first system with a new Core 2 Duo E6400 with a D975XBX board. I am slightly confused by the 3 temps given by the BIOS while the processor was idle: Processor: 85C Internal: 35C Remote: 33C I am using a CPU fan from a Pentium D which I though was the same fan for the new...
  4. againstTheWind

    Disabling connect to database engine window

    Is there a way to disable the "Connect to database engine" window that pops open whenever I open a saved query? Perhaps enabling some kind of "connect automatically" function??
  5. againstTheWind

    Stored procedures inside a SELECT statement

    I am trying to use a stored produced to contain an entire SELECT statement. What code do I need to use to create a view with a couple of the same stored procedures(but with different variables being passed). Something like exec proc1 88,99 exec proc1 95, 21 ?? Thanks!
  6. againstTheWind

    variables to define a column name inside a stored procedure

    I am trying to use variables declared inside my stored procedure to also make-up part of the column name. Something like this perhaps: ALTER PROCEDURE [dbo].[Cust_Recency] @RecentMonth tinyint, @Lastmonth tinyint AS select count(customerid) as RecencyFrom@RecentMonthTo@Last month from...
  7. againstTheWind

    Reusing code

    I have a query that I will have to reuse several times and I am wondering what the most elegant way to do this usually is - perhaps declaring a variable to store the SELECT statement? If so, how would I use this variable? Thanks!
  8. againstTheWind

    Changing the URL and adding a string

    I am trying to call a function once a form is submitted that will change the current URL to a new URL that includes an additional parameter at the end. Here is what I have function ResInquiryTrack() { location.replace(location.href + 'FBinquiry=1') } However, it is not working. Any ideas?
  9. againstTheWind

    New PC recommmendations

    Hey guys, I'm looking to build my first computer and I am looking for some recommendations. I'd like something that is going to last a while as well as be able to run image editing software, SQL Server Express, Dreamweaver, burn cds, have 50 tabs open in IE 7, and crunch the latest SETI data...
  10. againstTheWind

    problems with data source for SQL Server Express

    I just installed SQL Server Express. I have successfully logged in and created a database with the management studio. However, I keep getting a "not accepting connections error" when trying to create an ODBC data source. All of the help material describes how to add a data source for Visual...
  11. againstTheWind

    Windows Vista video compatibilty

    So the more advanced graphics in Windows Vista will not be supported by the integrated video on some motherboards. I am looking into building a system soon and am wondering whether it would be better to get a motherboard with integrated video powerful enough to support vista or just get a video...
  12. againstTheWind

    help with aggregate functions

    I am trying to determine the number of repeat customers we have. The data is an ORDERS table where using: select count(CustomerID) as OrdersMade from Orders group by customerID will provide the total number of orders for each customer. Example: CustomerID OrdersMade 5456 2 4547...
  13. againstTheWind

    Selecting groups of repeat orders by using aggregate functions

    I am trying to determine the number of repeat customers we have. The data is an ORDERS table where using: select count(CustomerID) as OrdersMade from Orders group by customerID will provide the total number of orders for each customer. Example: CustomerID OrdersMade 5456 2 4547...
  14. againstTheWind

    data with a one-to-many relationship and limiting results

    I have a list of pictures associated with hotels. Each hotel (specified by a unique ID number) has several pictures associated with it. I would like to write a SELECT statement that will only return one photo from each hotel instead of all of the pictures. the data looks like this: HotelID...

Part and Inventory Search

Back
Top