This bl**dy club !

[Spirit]

It's Friday afternoon, got a stack of work and what am I doing ?

1: Thinking about Nev's post about T*t Monday
2: Thinking about RT4 !

How much duller life would be without CVR4 - and how much more work would get done !

[BraindG]

It's Friday afternoon, got a stack of work and what am I doing ?

1: Thinking about Nev's post about T*t Monday
2: Thinking about RT4 !

How much duller life would be without CVR4 - and how much more work would get done !

here here... we need to have words with them that started it.

ive got a pleb load to do here, yet im thinking about cvr4 code

[HJM]

It's Friday afternoon, got a stack of work and what am I doing ?

1: Thinking about Nev's post about T*t Monday
2: Thinking about RT4 !

How much duller life would be without CVR4 - and how much more work would get done !

LOL - I know the feeling, today at work I have :-

- written some CVR4 T's & C's
- booked a hotel in Folkestone for RT4
- added pictures to the RT3 Summary I wrote yesterday
- logged on many times to see who else had booked for RT4

and to think I am now going to have to work tomorrow, 'cos I have an audit in less than two weeks

too


J

[Spirit]

- added pictures to the RT3 Summary I wrote yesterday

What, where ? Did I miss something ?

[HJM]

What, where ? Did I miss something ?

Nah, it's just for me at the mo - I'll see what Heath reckons before I go public with it

[BraindG]

Nah, it's just for me at the mo - I'll see what Heath reckons before I go public with it

[The Vee]

Yep, have vented my feelings bout this place before. But what else could make me think of T. Monday and RT4 on my way to work tonite. !!!

[richy rich]

me too i should of been doing quotes and invoices today non done, sh*t got to do them soon.

[The Vee]

- logged on many times to see who else had booked for RT4



too


J

Did you really need to log on to know who??? CVR4

[BraindG]

Did you really need to log on to know who??? CVR4

You not got a RSS feed to the RT4 thread?

[The Vee]

RS2000,RS4,RS6 but RSS ooh, computer stuff, Think I'll pass on that one for now. Am a simple man of simple pleasures, please don't spoil it with PC techy stuff

[BraindG]

RS2000,RS4,RS6 but RSS ooh, computer stuff, Think I'll pass on that one for now. Am a simple man of simple pleasures, please don't spoil it with PC techy stuff

CREATE TABLE #CallsTotals (
Campaign Varchar(100),
Date Datetime,
Calls Int,
Presentations Int,
Leads Int
)
DECLARE @Name varchar(255)
DECLARE @Sql nvarchar(4000)
SET @Sql = ''
DECLARE
CampaignCursor
CURSOR
FOR
SELECT [Description]
FROM MCCntrl join master.dbo.sysdatabases as SD
on mccntrl.description = sd.name

OPEN CampaignCursor

FETCH
NEXT
FROM CampaignCursor
INTO @Name
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT @Name
SET @sql = '
use [' + @Name + ']
INSERT INTO #CallsTotals (Campaign, Date, Calls, Presentations, Leads)
SELECT top 1 ''' + @Name + ''',
dateofcall,
(select count(*) from callrslt where dateofcall = ''17 mar 2006''),
(select count(*) from callrslt cr join mcalcode mc on cr.callresultcode = mc.callresultcode where presentation = 1 and dateofcall = ''17 mar 2006''),
(select count(*) from callrslt cr join mcalcode mc on cr.callresultcode = mc.callresultcode where countaslead = 1 and dateofcall = ''17 mar 2006'')
from callrslt
where dateofcall = ''28 Apr 2006''
'

EXEC sp_executeSql @sql
FETCH
NEXT
FROM CampaignCursor
INTO @Name
END
CLOSE CampaignCursor
DEALLOCATE CampaignCursor
SELECT * FROM #CallsTotals
DROP TABLE #CallsTotals

[richy rich]

wtf are you on today b

[HJM]

Did you really need to log on to know who??? CVR4

LOL - I guess not really

[BraindG]

wtf are you on today b

Life mate, Life!

[The Vee]

So the answer is 0.

[WildCards]

I'm the same as you lot, I use the RSS now and then, but prefer the site proper. Trouble is the gret big blue screen, fortunately my Boss/Stepdad and I face each other, but sometimes I get engrossed in a thread and forget to minimise when he gets up to do something. I still get the work done, but do get quite distracted at times. Bloody CVR4