I need to get a get a count of all the distinct subnets in an IP column and group by the subnet on MS SQL. ie.. count all ips that have a subnet of 192.168.0,192.168.1,10.10.10 and so on.
Any help is appreciated. Thanks
This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We tested this with the same database structure on different servers and different versions of ms sql (2005/2008), and it's only THIS particular client's server that throws the error. I'm actually frustrated.
SELECT Tasks.TaskID
FROM Tasks
INNER JOIN TaskHelpers ON TaskHelpers.TaskID = Tasks.TaskID
order by TaskID
Yes, I know I can put "Tasks.TaskID" into the order by clause, but for some reasons I can't.
Hi,
Have anyone can sharing with me the info on which is how to automate a web query login to download data in Ms.Excel 2007? Problem is existing that i need to manually login through a web query each time....
Thanks in advance for any help you can provide!
I have a need to determine if a database on a MS SQL Server has changed between two distinct moments.
The change can be structural or data-related and the check should be generic (i.e. independant of the structure of the database).
Preferably, I'd like the check to be T-SQL based or with SMOs, not file based. I checked on MSDN but I haven't found anything relevant so far.
I'm working with MS Excel interop in C# and I don't understand how this particular line of code works:
var excel = new Microsoft.Office.Interop.Excel.Application();
where Microsoft.Office.Interop.Excel.Application is an INTERFACE defined as:
[Guid("000208D5-0000-0000-C000-000000000046")]
[CoClass(typeof(ApplicationClass))]
public interface Application : _Application, AppEvents_Event
{
}
I'm thinking that some magic happens when the interface is decorated with a CoClass attribute, but still how is it possible that we can create an instance of an interface with a new keyword? Shouldn't it generate a compile time error?
I have a debug .exe file that i want to run on other machines that don't have MS Visual Studio 2008 installed on them. How can this be done? The release option doesn't work as the application does not function correctly when build in release (not sure why).
At the moment I'm getting a message saying "This application has failed to start because the application configuration is incorrect".
An ideas?
Cheers.
My test page is processed if believe to trace in 46 ms, while 11 of them I am doing this
20:53:06.111597 system.db.CDbConnection Opening DB connection
20:53:06.118046 system.db.CDbCommand Querying SQL: SHOW COLUMNS FROM `questions`
20:53:06.122476 system.db.CDbCommand Querying SQL: SHOW CREATE TABLE `questions`
Is this obligatory?
i have a web application that export CSV and i logged in as admin but what happened during the exportation the IE opens a new tab and export the CSV but what happens next when you click any of the link on the web app you will automatically logout!
This only happen on IE.
here is the header i used:
header("Content-type:application/vnd.ms-excel");
header("Content-disposition:attachment;filename=".$this->filename);
I am using cakephp 1.3.x.x
TIA :D
basically I need to check something like this
select * from users where name = @name, pass = @pass
the problem is that 'pass' = 'pAsS'
is there something more strict for string comparison in sql (ms sql-server)
Does MySQL have an equalavent to MS SQL Servers "indexed view" functionality?
http://stackoverflow.com/questions/439056/is-a-view-faster-than-a-simple-query
What I'm specifically looking for is a way for MySQL to create a "view" that will return results faster than simply performing the underline view's query/sql.
Suppose a query "select * from employee" returns 80 rows. I need to display middle rows that is from 20th row to 50th row.
I know, like to display first 20 rows we have option like "select top 20 * from employee" but if we need middle rows how to get it in MS SQL specifically.
I m new to this SQL queries...Can anybody answer to this question.
What do you think, what events/changes/news were the most significant in C++ world
Like
templates in the arena, including STL, boost
new standards - C++0x, TR1
The Qt library
MS managed C++
MPI, openmp, PPL
may be new IDE :) : eclipse,
netbeans, codeblocks, codelite
Hello, In MS SQL Server is there a way to detect whether a database has had its isolation level set via the T-SQL command ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;
I cannot find a simple way to detect this in either T-SQL or via the Management Studio's GUI.
TIA
I simply want to include a row number against the returned results of my query.
I found the following post that describes what I am trying to achieve but gives me an exception
http://vaultofthoughts.net/LINQRowNumberColumn.aspx
"An expression tree may not contain an assignment operator"
In MS SQL I would just use the ROWNUMBER() function, I'm simply looking for the equivalent in LINQ.
I am willing to build an email application which runs on the server side.
Not being familiar with any particular server I wonder if I can get some recommendations based on experience.
I have seen many great startups which built some neat apps on the email platform (for instance, friendfeed's notification mechanism, or surely posterous which mail is at the heart of their business logic), and wonder about which mail server have they found easy to learn and integrate with.
PS:
MS Exchange or any other not open-source are not an option
Must run on linux
I imported System.Collections namespace in my class, but I still cant use ArrayList type. The code editor says the "class not found". I am using VS2008 & VS2010.
So has MS stopped support for this type in framworks 3.5 and upwards ?
hello, im trying to delete a foreign key with the following syntax (5.0.45-community-nt):
alter table [table] drop foreign key [fk_name]
but I'm getting the folling error:
The table '#sql-5f8_9c' is full – 99543 ms
any ideas?
thanks!
i am going on a job interview and have zero experience with ms sql, however i have 1 year with oracle. is there such a huge difference between the two? what programming questions can i expect?
I have CMS table that contain CMS_STARTTIME and CMS_STOPTIME (attachment).
I want to create report to summarize exist data by using Date, Time and Year as Parameter (attachment).
I don't know how to create sql statement to meet this requirement. I'm using MySQL and MS-SQL.
Does one can help?
Thank you very much.
i have a data structure for my compiler (such as ast) , and i need a method to print it (like ms visio) and verify its contents (i need to verify the contents of the ast nodes)
note : i dont want to print it to the console , i am using c++ & qt
thanks
Hi,
My issue is that I've got update triggers on an SQL View (MS SQL 2005) which I'm mapping to LINQ to SQL entities in C#...
My SQL looks correct but it complains about trying to insert a null value into a secondary table PK field.
I believe my issue relates to having the primary key and identity as seperate fields in the primary table. So my question is this....when using @@identity, does it look at the primary key of the inserted row, or does it look at the field with "IDENTITY" specified???