I am trying to get a count based on unique case ID but I'm getting duplicates in a query and I'm not sure how to get unique results. Here's my query:
SELECT
tblcases.caseid,
tblCases.Ca...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2351...
We are attempting to understand the differences between MySQL vs Microsoft SQL Server. Specifically we are evaluating an internet based accounting system that uses MySQL as the backend database. ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20969421.html
Zones:
DatabasesDate Answered: 04/30/2004 Grade: A Views: 0
After successfully installing DBI and ODBC
I am failing to connect to the database?
Why?
WHICH perl debugger should I use?
~~~~~~~ few line of code
#!/usr/bin/perl
# Fig. 15.18: fig15_1...
http://www.experts-exchange.com/Programming/Languages/Scripting/Perl/Q_21279578.html
Zones:
PerlDate Answered: 01/19/2005 Grade: A Views: 0
Can I write a script in Microsoft SQL Server 2005 and then put that same script in MySQL and be able to use it?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21724370.html
hello Expert,
I have a copy of microsoft sql 5.5 setup on PDC.
The pdc is running windows nt server sp6.
I need to remove microsft sql 5.5 all relevant files from the above
mention server
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21995182.html
The select query below works fine. Basically it returns the calculated columns ComponentsOnOrder and ComponentsAllocated.
What I would like to be able to do is update the columns "StockOnOrder" ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23004784.html
I have a table called PRODUCTS with 100,000 items and there is a field called Category_ID which contains an integer between 1 to 1,700 which is a category that each of the products is assigned to.
...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23074298.html
How would I obtain the year from the current date rather than forcing 2007 in the following view when I create it?
Thanks!
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23084112.html
I have inheritted a SQL datebase in which the date in a table is in the following format - yyyy/dd/mm - and is set up as a varchar field. How can I change the date data already in the database to y...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23133700.html
Zones:
SQL SyntaxDate Answered: 02/03/2008 Grade: A Views: 0
hi Wonder if you can help me?
I have the following SQL
SELECT id_type, type, max(subtype) from Gtypes group by id_type, nm_type
The problem I have is subtype is a boolean field and the max...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23147505.html
