Viewing 10 posts - 1 through 10 (of 10 total)
Makes sense, but I'm still confused. Parameters are ParamYear, ParamMonth, etc., but not clear on where the "start" and "end" components come from.
From the Year dropdown, user might select 2012,...
December 18, 2012 at 9:28 am
OMG! That is so obvious!! Thanks so much for the quick reply! ~Carol
July 24, 2012 at 6:10 pm
Strange. I was getting error pointing to false portion of iif statement, and adding those two parens eliminated the error.
Not getting error now if I delete those two added...
May 19, 2012 at 10:15 am
This is EXACTLY what I was looking for, Fitz! Kept getting error on false part of iif, but solved that by enclosing first part of iif in parens, and it...
May 19, 2012 at 8:22 am
Will do next time. Thanks!
July 8, 2011 at 5:34 am
mister.magoo (7/6/2011)
Is this what you are after?
SELECT AA.AgencyName,AA.AgencyIDFROM (
SELECT CA.AgencyName, CA.AgencyID, COUNT(*) OVER(PARTITION BY CA.AgencyName) AS AgencyIDCount
FROM ContactAction AS CA
GROUP BY CA.AgencyName, CA.AgencyID
) AS AA
WHERE AA.AgencyIDCount>1
ORDER BY AA.AgencyName
My friend, that's...
July 6, 2011 at 7:10 pm
anil_kumar32 (7/6/2011)
[font="Times New Roman"]Hi,
You may try following script.
SELECT AgencyName,AgencyId
FROM ContactAction
WHERE AgencyName IN
(
SELECT AgencyName
FROM contactAction
GROUP BY AgencyName
HAVING COUNT(*)>1
)
ORDER BY AgencyName
Regards,
Anil Kumar
[/font]
Anil - Like the other post, I thought for sure...
July 6, 2011 at 4:22 pm
Kritika -
I thought for sure that would work, but it gives me the agency name twice with the same AgencyID twice, e.g.,
Disability Network UWSE281
...
July 6, 2011 at 4:10 pm
That gives me the number of different IDs associated with each AgencyName, and only lists those with more than one ID. But how can I get the associated AgencyID to...
July 1, 2011 at 2:07 pm
Sorry, guess I wasn't clear, as that counts the number of actual records for each agency.
There are hundreds of records in the db for each agency. However, some are listed...
July 1, 2011 at 12:44 pm
Viewing 10 posts - 1 through 10 (of 10 total)