Recent content by maxf

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...

Thanks. Client network utility did it. I got it working!! thank you

that did it. thanks

Sorry, not familiar what the client network utility is. Can you give me a little more of a description of how I would do this? Thanks for your help

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...

i got it working. i needed the group by clause as you suggested. thanks

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 changed the column data type to datetime so it sorts now. I do have a different question now. In my table I have a column for PLAY_DATE (smalldatetime) and a column for PLAY_TIME (datetime). I want to order records based on PLAY_DATE, on if there are multiple records on the same PLAY_DATE...