Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maxf
  • Order by date
  1. maxf

    Need help with SQL Select Statement

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

    Enterprise Manager Question

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

    Access 2000 to SQL server migration help

    that did it. thanks
  4. maxf

    Enterprise Manager Question

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

    Access 2000 to SQL server migration 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?
  6. maxf

    Enterprise Manager Question

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

    Need Help with SQL Select/Join Statement

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

    Need help with SQL Select statement

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

    Adding a DBO user to database

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

    Need Help with Stored Procedure

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

    SQL Select Null values

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

    Need Help with SQL statement

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

    need help with select statement to calculate sum

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

    need help with select statement to calculate sum

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

    sorting times

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

    sorting times

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

    sorting times

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

    Setting time zone question

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

    Select using a Min Function

    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 =...
  20. maxf

    Select using a Min Function

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

Part and Inventory Search

Back
Top