Search results for query: *

Hello All, I've searched the documentation here on vba and lotus notes but have come up short. Most topics here deal with sending messages via lotus notes. The problem I have here deals with reading the contents of a view and writing those contents back to excel. I assume you could use...

Thank you both for your replies. They both seemed to work very well. However, for some reason, the first solution seemed to run much faster.

Hello All, I'm having a terrible time at this and don't quite know how to go about it (so I'll just jump right in). Say you have 2 tables: TableA ------- empsys epssys paysys beginningDate endingdate TableB -------- epssys paysys BegDate EndDate Table A is linked to Table B by epssys and...

Thanks SQLBill and JayKusch for your help with this. I've found out what I need to do and my problem while I was doing it. One more piece of advice I could use. I'm doing this through QueryAnalyzer and the output is less than desirable. Is there a better way of accomplishing clean output...

Tried this: declare @iCurInt int declare @iCurDate datetime select @iCurInt = 1 set @iCurDate = '07-16-2003 00:00:00' while @iCurInt < 3 begin SELECT DATEPART(mm, entrydate) AS tranmonth, DATEPART(dd, entrydate) AS tranday, DATEPART(yyyy, entrydate) AS tranyear...

Hello All, I'm having a bit of a difficult time here. I have a query that I can run for a single day and it produces the correct output for the situation. The query goes as follows: SELECT DATEPART(mm, entrydate) AS tranmonth, DATEPART(dd, entrydate) AS tranday, DATEPART(yyyy...

I think what you need is to change it to this: select p.id, x.counter from producers p Inner join (select pid, count(pid) as counter from clients c group by pid having count(pid)>1) x on p.id=x.pid You were aliasing inside your select for your join as c but then named it as x (on...