Search results for query: *

Got it - select F_LEADS.SOURCE, F_LEADSOURCE.SOURCE_NAME, sum(case when month(F_LEADS.LEAD_DATE)=1 then 1 else 0 end) 'M1', sum(case when month(F_LEADS.LEAD_DATE)=2 then 1 else 0 end) 'M2', sum(case when month(F_LEADS.LEAD_DATE)=3 then 1 else 0 end) 'M3', sum(case when...

Sorry, could you show me how ?

Fantastic, works a treat. Now I need one little extension on this. In a separate table (f_source) we keep the full name of the source. How would I show the full name of the source in this query ?

Mmm. I think I started off on the wrong foot here. Well the closest I have got is - SELECT "F_LEADS"."SOURCE",Count("F_LEADS"."LEAD_DATE") AS "COUNT of LEAD_DATE" FROM "DBA"."F_LEADS" "F_LEADS" GROUP BY "F_LEADS"."SOURCE" ORDER BY "F_LEADS"."SOURCE" ASC...

Hi, Have a basic knowledge of SQL statement building but need to create a query and I am lost. I need to count records in a table and group by the month between two dates and to export as a .csv file so I get a result like - mm/yy count 01/07 3245 02/07 8734 or something similar...

Yes, tonnes of it, but I cannot find anything

Can anyone advise if the following is possible and if so, is it easy to set up. We have a BCM50 with Callpilot. We would like, when callers ring our main number, for the auto attendant (or other) to answer, play a short message, and then continue to ring as per normal. Our main number just...

Thanks for the reply, but unfortunatly I am an end user so most of it is gobbledygook. Can anyone explain in laymans terms ?

Can anyone advise on how to set up a LCR table please. BT want us to subscribe to a premium Help Line to get this advice and I'm buggered if we want to pay it. What I would like to do is - If the number dialled starts 00 39, then dial a prefix number. If the number dialled starts 00 34, then...

If you look at all the other functions in the file, they are very much the same and they work fine, it is just this one.

Feherke, Remember this/me ? Either something has gone wrong or I missed something out when we did this. The final code I had was - function disablecountry(disableIt) { document.searchbox.Country.disabled = disableIt; { ds1=document.searchbox...

Once again, you da man ! Glad you came up with the second option which I did. Works brilliant. Thanks so much for that.

If it helps, when I create the option list, I can give the resorts a id=

Ooops ! Few errors there. Where is the edit post button ? Should read - Thanks feherke, your a god ! With a little tweaking, it works spot on. This was the end code - { document.searchbox.Resort.disabled = disableIt; ds=document.searchbox...

Thanks feherke, your a god ! With a little tweeking, it works spot on. Tjis was the end code. [b]{ document.searchbox.Resort.disabled = disableIt; ds=document.searchbox; ds.Month.disabled=ds.Country.selectedIndex==1 || ds.Country.selectedIndex==2...

Please help because this is driving me crazy. I have a script at the moment which is disabling some selection boxes on changing other selection boxes - function disableresort(disableIt) { document.searchbox.Resort.disabled = disableIt; } function disablecountry(disableIt) {...

works fine

VM is set up correctly as it works if you call extension on an internal call or DDI number. All VM boxes have been inialised as weel.

We have just had a BCM50 installed in our office and there are a few bugs left to iron out. Any help/advice muchly appreciated. 1) We have VM (callpilot) set up on each extension, set to kick in on no answer and busy. If we try and transfer an external call to an extension, it will - a) If...