While I don't want to discourage new members, you might want to look at the dates of previous messages. This thread has been dead for 2 and a half years.

ignore that last one and try this instead


Select pt.ProductID
from Products pt
left join Rating RT
on pt.productid = rt.productid
group by pt.productid
order by IsNull(Min(rt.Rating),0)

I think you want something like this

Select distinct pt.ProductID
from Products pt
left join Rating RT
on pt.productid = rt.productid
order by IsNull(Min(rt.Rating),0)

get rid of the square brackets around the varchar(255) and it will work fine.

For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that.

select * from persons where (prefix like '%'+@input+'%'
or
firstname like '%'+@input+'%'
or
lastname like '%'+@input+'%')
and address like '%'+@addressinput+'%'

This isn't a problem as I have already solved the problem, just trying to figure out why it happened.

Ok I have a field that is type money. I wrote a stored procedure that updates this field,...

that would add the assumption that the names in b are the first letter of the names in a

ok, i am assuming that you want a name for all id's. if a has an entry use that, otherwise use the name from b. also assuming that B has an entry for every id. if those assumptions are correct,...

I don't have time to test this, but i don't think that this will work. This won't show any id1's that don't have a matching id2 or any id2's that don't have a matching one

select distinct case when id1<id2 then id1 else id2 end, case when id1<id2 then id2 else id1 end from tablename

um, yes you can. I have Windows XP Pro with SQL Server 2000 installed on it.

which version of xp?

I agree that storing images in your database is probably not the best way to do it. But it is possible. Look into BLOB's (binary large object)

it think this should work

select nick, max(energy.dateposted) from users
join energy
on energy.userid = user.id
group by nick

there's probably a more efficient way but this should work
select max(empsal) from employees where empno not in (select top 3 empno from employees order by empsal desc)

only other way that you might make it faster is to split the tables by type

eg have a SudokuGameList table and a CrosswordGameList table, ditto for history

but I really think that, with the...

sounds like a reasonable setup. Best bet is to make sure it is indexed properly

give an example of what you are trying to do

1) I am in the process of doing this right now and so far it has been relatively painless. There are some minor tweaks you may have to make, but it is pretty easy to convert. Two problems we have...

you're quite welcome

not 100% sure what you are going for, but hopefully one of these will either do it for you or get you going in the right direction


1. this will give you each person and their max
select...

from a practical standpoint, I had this happen on a database with an int identity column. You will get an arithmetic overflow exception. Since we are purging and only keep 60-70 million rows at a...

this seems more like a code problem than an sql problem. try posting in the appropriate forum for the language you are using. (vbscript?)

you want to use dynamic sql

DECLARE @STA as char(50)
SET @STA = '''TT'', ''DD'''

exec ('SELECT * FROM ABC_TBL where ABC_Filed in ('+'@STA')')

sp_who
or
sp_who2

does this work for you?

SELECT RNO,PNAME,AGE
FROM TAB1
WHERE enroll_status in ('D','A','Q')

post the queries for the 3 lists and I should be able to help you do one query to get the combined list

actually, that one will only work if there is something in cat a

this will work better


select distinct main.id, a.name, b.name, c.name
from tablename main
left join tablename a on main.id...

this is what you want


select a.id, a.name, b.name, c.name
from tablename a
left join tablename b on a.id = b.id and b.cat = 'b'
left join tablename c on a.id = c.id and c.cat = 'c'
where...

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
...

correct. 4 bytes * 8 bits = 32 bits. hence it has a range from -2^31 to +2^31

you are confused, int is not limited to less than 10,000 in sql server. the limit is around 2 billion. (2^31)-1 to be precise

well for stored procedures, just right click on them and click properties
for the triggers, right click on the table, then go to all-tasks and click on manage triggers

are they stored in the time column, or their own column

also, do you need minutes?

and I suppose changing the database is out of the question?

ok, let's start from scratch. give me a brief description of what exactly you are trying to accomplish. including field types and names

something like
I have three columns: workerid, begin_time...

the way you want to do it, I don't know of a way without knowing the criteria you are sorting by and the table schema.

if you have a primary key and are sorting by that primary key,
example table...

sorry, couldn't resist. Will need table schema to answer your question

me