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 derfloh 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: *

  1. dolodolo

    phpmyadmin

    It's not my website - thanks anyway. I'll just execute code.
  2. dolodolo

    phpmyadmin

    Yes, I should create a foreign key but I don't see anywhere to do that on phpmyadmin.
  3. dolodolo

    phpmyadmin

    Hi there, I'm creating a very simple database in phpmyadmin. How do I assign a possible value list to a field in a table? The PV list is an indexed field in a different table. I can't figure out how to do it in phpmyadmin. Thanks for your help. Dolores
  4. dolodolo

    carriage return in a string function

    Thanks guys - that works!
  5. dolodolo

    carriage return in a string function

    Thanks very much!
  6. dolodolo

    carriage return in a string function

    Hi, I'm trying to insert a carriage return into the following string function but it still returns all the records on the same line: SELECT @str = COALESCE(@str + char(13),'') + '$' + CAST ( t2.stotalAmount AS VARCHAR) + ' for ' + CAST( rtrim(t2.snotes) AS...
  7. dolodolo

    UNION ALL statement needs to group data results

    Hi, I'd like to combine the results from this UNION ALL: select pr.hmy, count(pm.hmy) from pmuserex pm inner join property pr on pr.hmy = pm.hproperty inner join person p on p.hmy = pm.hobjpointer inner join room r on r.hmyperson = pm.hobjpointer where pr.hmy = 510 group by pr.hmy UNION ALL...
  8. dolodolo

    How to create a stored procedure

    Thank you!
  9. dolodolo

    How to create a stored procedure

    Thanks so much!
  10. dolodolo

    How to create a stored procedure

    Hi, I need help with conventions on turning a script into a stored procedure. here's the script: /* Version 1.0 DESCRIPTION Create Temporary Tables for Updating Minimum and Maximum Rent on Floorplan table Created by d.meehan 4/23/2010 */ if exists (select * from dbo.sysobjects...
  11. dolodolo

    Delete statement with condition from joined table

    Tahnks so much!
  12. dolodolo

    Delete statement with condition from joined table

    Hi Guys, I need help with the following statement. I am trying to delete records in one table (unitbut_amenity) based on a value in a joined table (unit): delete from unitbut_amenity inner join (select u.hproperty hproperty, u.hmy hunit from unit u) as main on main.hunit =...
  13. dolodolo

    subquery in SQL select statement

    Thanks mucho!
  14. dolodolo

    subquery in SQL select statement

    I’m trying to run the following script and get an error (see below): select ach.hperson, ach.sname, ach.sacct, ach.bportal, ach.hroommate FROM (select hperson, count(hmy), brecur from achdata where brecur <> 0 group by hperson, brecur having count(hmy) > 1) main inner join achdata ach on...
  15. dolodolo

    SET ANSI_DEFAULTS ON in Report Script

    Hi, How can I set ANSI_DEFAULTs to ON in a report script in SQL Server. Here is the select statement: SELECT t.sfirstname, t.slastname, ts.status, pm.susercode, pm.susertype, pr.scode FROM pmuserex pm INNER JOIN [jqnnbla_sandbox_2k5].jqnnbla_sandbox_2k5.dbo.tenant t on t.hmyperson =...
  16. dolodolo

    Combining select statements

    Thanks, it works now!!!!
  17. dolodolo

    Combining select statements

    Thanks - I am still getting an error - Incorrect syntax near 'm'. Any thoughts? select m.thmy, t.hmy, t.uref uref, t.upostdate postmonth, a.scode acct, p.scode property, d.samount amt, j.scode job, t.snotes notes FROM (select t.upostdate postmonth, d.hprop prop, d.hinvorrec thmy...
  18. dolodolo

    Combining select statements

    Hi, I am trying to run a query that will first select a set of data based on one criteria and then select another set of data based on the results of that query. Here's my attempt - I know I'm mising something - thanks for your help. select main.thmy, t.uref uref, t.upostdate postmonth...
  19. dolodolo

    Making Access multiuser

    Thanks All, It turns out that it will open once Access is open but not from Explorer - strange quirk. Again thanks all for your help! Dolores
  20. dolodolo

    Making Access multiuser

    Hi, Thanks for your reply. We are not using user level security - it's a nightmare. When the DB is open, no one else can open it. You click on it and nothing happens. I am having the folder containing the DB shared specifically. I'll see how that works. Again thanks for your prompt reply...

Part and Inventory Search

Back
Top