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...
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...
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...
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??
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!
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...
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!
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?
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.