Search results for query: *

I've got a table of Business Owners Information (name, city, state...). I've got another table which hold the Offers Business have placed. I want to display a list of all the Business Owner Information AND if the Business has an Offer in the database, I want to display the Offer Name. The...

I'm trying to find the easiest/quickest way to migrate a db (the db structure--primary keys, column types-- and data) from Access to SQL server. Can anyone recommend a good post or article which details an easy/quick method?

I two clients who are on the same remote SQL server. I am unable to add the same server twice as I get the error message "A SQL Server already exists with this name". I tried to add one of the servers to a new sql server group but it gave the same error message. Is there a way I can...

Im having a SQL nightmare. Simply put, I have a table, "Documents" which has a uniqueID for each record "DocumentID", and another table, "DocumentTYpes", with a uniqueID, "DocumentTypeID", and the tables are linked via another table...

Im trying to use this statement: SELECT Distinct D.DocumentID,D.FileName,D.Title,D.ShortDescription,D.DatePublished,DTR.DocumentID,DT.DocumentType,DT.ThumbNailImage from Documents D, DocumentSubjectAreas DSA, DocumentSubjectAreasREL DSAR, DocumentTypes DT, DocumentTypesRel DTR WHERE...

What is the T-SQL command to add a user with DBO privileges(allow user to select, insert, update, delete table information, run all stored procedures, etc... basically, check all the checkboxes in manage permissions section) to a database? thanks

Im trying to modify the IbuySpy Store and need help with a Stored procedure. Right now Im running this code which works: SELECT @OrderID = @@Identity /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/ INSERT INTO OrderDetails ( OrderID, ProductID...

Im simply trying to select all the values in my table for which there is a null value but Im unable to get the query right. Im using Select * from orders where IsNull(status) This isnt working. How can I do this? thanks

Im getting this error: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'rs.pathnames=cl.path_groups Inner Join Alternative_medicine ALM ON rs.pathnames=ALM.PATH_Group_Name'. when running this sql statement: Select rs.* From...

Im trying to calculate the difference between two columns. The statement im using is: Select course_name, sum(no_players-players_booked) as no from TEE_TIMES When I try this statement I get the error message: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Column...

I have a column,PLAY_TIME, in my database which Im using to hold the time, hour, of a scheduled event. For example, PLAY_TIME, holds the values, 9:00AM, 9:15AM 10:00AM etc... The PLAY_TIME column was set up as a VARCHAR data type, by the previous developer. The problem is that when I try to...

My site is hosted on the East Coast (U.S.), however, the people using my site are all in San Francisco (3 hours behind). The site uses dates and times extensively. Instead of adding code to adjust dates and times on each page, is there a way to simply set an application level variable or a...

I have a select statement where I need to select data from 2 columns. From one of these columns, I also need to use the Min function to select the Min number from the data. Heres what my statement looks like: mySQL1="SELECT h.year, h.MDOfficeVisit AS [data], MIN(h.MDOfficeVisit) AS...

fds_id | region | impact_value | condition_id 1..........West............1.02..............6 2..........West............2.02..............7 3..........South...........1.76..............6 Im trying to select distinct regions and their corresponding fds_id, impact vaule based on the...

I know how to set up IIS to host mulitple sites on with only one IP using host headers. But how can I set up mutliple FTP sites without using nonstandard port numbers? Is there a feature comparable to using host headers for websites for FTP sites? An example would be large Webhosts who setup...