Re: [SQL] interesting SQL puzzle - concatenating column with itself.

2005-05-10 Thread Nick Fankhauser
parameter or something else entirely? BTW the concatenation function you suggest works nicely except that as you noted, it concatenates in an unpredictable order, so I'm now trying to solve that problem. -Nick -- Nick Fankh

Re: [SQL] interesting SQL puzzle - concatenating column with itself.

2005-05-08 Thread Nick Fankhauser
Excellent! Thanks for providing both the idea and an example. I didn't get the idea right away, but the example made it clear. I'll try that on my table and report back on how it works out. Regards, -Nick -- Nick

[SQL] interesting SQL puzzle - concatenating column with itself.

2005-05-08 Thread Nick Fankhauser
#x27;m not seeing. Thanks -Nick -- -- Nick Fankhauser [EMAIL PROTECTED] Phone 765.935.4283 Fax 765.962.9788 Ray Ontko & Co. - Software Consulting Services http://www.ontko.com -

Re: [SQL] Is there a more elegant way to write this query?...

2003-11-11 Thread Nick Fankhauser
Hi Eric- Thanks for your suggestion. > An explain analyze would help. I'll do that (and move the question to the performance list) when I get to the performance question, but at this point, I'm just seeking some help in looking at this from a different angle- I couldn't figure out how to achieve

[SQL] Is there a more elegant way to write this query?...

2003-11-11 Thread Nick Fankhauser - Doxpop
, case_count desc, limit 1000; Thanks! -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ ---(end of broadcast)-

[SQL] Is there a more elegant way to write this query?...

2003-11-10 Thread Nick Fankhauser
, case_count desc, limit 1000; Thanks! -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] need assistance with multi-row matching expression

2002-08-19 Thread Nick Fankhauser
1) then pid end from pfm where fid in (1,2,3) group by pid order by count(pid) desc; -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services