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

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

I get this error when trying to perform the Convert using this code, convert(datetime, s.play_time): Microsoft OLE DB Provider for SQL Server error '80040e07' Syntax error converting datetime from character string. /stage/cadmin/add_tee_time.asp, line 60 Any idea how I can do the convert...

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

That did it!! Thanks. One more question. If I wanted to add a Max Function to select the Max year from the h.year column would I do this: SELECT h.year, h.MDOfficeVisit AS [data], (SELECT MIN(h1.MDOfficeVisit) FROM historical h1 Where h.condition_id=h1.condition_id AND h.factdataregion_id =...

Im using the order by clause to give me the first value for the h.year column, but I also need to find the smallest value in the h.mdofficevisit column for all the records which meet my condition. So I want to select all the values for the years (h.year) and values (h.mdofficevisit as Data)...