SELECT * FROM MyTable ORDER BY xCountry='Mongolia', xValue DESC
This works in MS Access, but not in MS SQL Server 2000. Access returns Mongolia first, then the other countries by xValue DES...
I'm looking code that can find the right Price for a call. I've MS SQL 2005 database all the call information and price information.
Does somebody has an options / suggestion?
Table Pr...
Hi,
I need to define a field on mysql database table which will store values like: (without zero fill)
0.0004
0.1
-500.22
0.03
I have tried with FLOAT (5,4) but it does not store t...
I am doing an visual studio windows forms application. I will manage a little amount of data and I dont think worth to install sql express in the target computer to read the data.
There are 5...
how do I make SQL 2008 backward compatible to SQL2000 databases?
I have a database in ACCESS 2003 that is about 1.6 gig. I would like to move this table into SQL Server Express, but when I do, the transaction log fills and stops the upload. How can I eith...
I am creating a new schema for access database but i have question related to the tables, i have been assigned to create a form and to feed that form i have to create a table to create a relat...
I installed a license of Business Objects Enterprise. It allows you to install several different types of databases for its applications functionality. The default is MySQL. However, I have st...
I have been trying to get this to work in MS Access 2007. Idea is the query ask for a user input and in one case orders the results ascending room numbers and in the other case by descending r...
Hi,
I have a products table which includes fields
id, title, description,img, categoryid,subcategoryid
There are also tables for category and subcategory
the category is basically
id, c...
We have a 20 Gb database for MS Great Plains Dynamics that is having problems. Of the 1505 tables, 4 are having issues:
SYSINDEXES
TW01155
TW02255
TW00157
When we try to drop tthe ta...
When running a query with a not exists sub query I should get 7 rows as a result. If the table Opportunities is empty I get the results that I expect but If I add a row to the table then I get...
Hello experts.
I'm building a site where a client can login-insert in a db a car or transporter ,than upload pictures for each artikel.I also have search pages to allow other users to find wh...
I am having an issue on our Windows 2003 Enterprise based server running MS SQL 2005.
Every couple of seconds, the event log reports am Event ID 18456, login failed for user sa. I can log i...
the book explains it as a group of objects with the same properties, which are identified by the enterprise as having an independent existence.
But I am not sure that the definition is that...
I need a little advice I have a main database that holds all the live data.
What I want to do is create a new database that is a duplicate of the live data.
Also the new databases data need...
Need suggestions for an alternative for Doubletake software for aoutomated fail over of SQL
I've been tasked with creating a document or set of documents which our company's Data Warehouse users can use to have a better understanding of all of our data which is contained in the Data ...
Hello,
I was wondering if changing the relationship in a query view changes the relationship in the entire database, or only for that query.
Also, I am an Access newbie, so I was wonde...
I'm struggling with this Case statement and wondering if I can do an "IN clause" inside a "Case statement" in a "Where clause", or if I'm just missing something? or just pushing the envelop.....
Hi,
I have a SQL query problem that I need help to solve.
I have following SQL query that gives me a correct result (one row as result for LIH.INVOIC_NO = '438692295')
SELECT LIH.INVOI...
Dear Experts,
What is the minimum hardware requirements to install mysql 5.4 community server on windows platform. Also tell me any specific software requirements to run this on windows ser...
I have a stored procedure that returns a data set.for a report. The code for it is below. I need it to return one more line of data that requires looping through the columns of each record a...
Motel (MotelID, MotelBranchName, MotelAddressID)
Motel table store information about the motel. MotelAddressID points to Address table. I want to delete AddressID record in Address table if...
Cast((Missedopportunties + ValueEngineering + Referencepricing + Marketrate) as Decimal(20,2))/Cast((ActualSpend + Missedopportunties + ValueEngineering + Referencepricing + Marketrate ) as ...
