Recent content by dolodolo

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

Yes, I should create a foreign key but I don't see anywhere to do that on 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

Thanks guys - that works!

Thanks very much!

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

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

Thank you!

Thanks so much!

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

Tahnks so much!

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

Thanks mucho!

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

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