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
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...
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...
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 =...
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 =...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.