Private Testing Only

Various comments, bug, issues, wishes have been expressed in a few threads.

This is my attempt to varify what is and isn't. I have been able to varify most things already.

For a start, only formatting listed under "formatting Tips" will be used.

Text Formatting

Underline: to start, to end
Bold: to start, to end
Italic: to start, to end

Text formatting can be mixed and used within Steps, Bullets, and Quotes
All formatting tags must be closed within the container they were started

Adding Links
to begin the link tag
to end the link tag
Example: EE
Links can be used within Steps, Bullets, and Quotes

1: Steps
Adding Steps

2: title of step
will format a step number and title

will close the step formatting

3: use distinct heading 4 Steps not encapsulated

Adding 3a Steps
Adding 3b Steps
Adding 3c Steps
Adding 3d Steps

4: use distinct heading 4 Steps encapsulated

Adding 4a Steps
Adding 4b Steps
Adding 4c Steps
Adding 4d Steps

Adding Bullets

will begin formatting a bullet point

will close the bullet formatting

will begin formatting a bullet point and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

will begin formatting a bullet point and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

Adding Snippets

 will begin formatting the subsequent text as a code snippet

1:

Select all Open in new window

will close the code snippet formatting

 
will begin formatting the subsequent text as a code snippet

1:
2:

Select all Open in new window

If a > B + C then D
 
select <columns list> from <data source> where <conditions>
 
if A >= B then C else D+C end
 
........

1:
2:
3:
4:
5:
6:
7:

Select all Open in new window

 will begin formatting a code snippet and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

1:

Select all Open in new window

 
will begin formatting a snippet and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

1:
2:

Select all Open in new window

Adding Quotes

will begin formatting the subsequent text as a quote

will close the quote formatting

will begin formatting a quote and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

Code snippet as an attachment small bits should be OK

If a > B + C then D

select <columns list> from <data source> where <conditions>

if A >= B then C else D+C end

........

Attached code snippet 1

Code snippet as an attachment small bits should be OK Check out the plus signs
 
If a > B   C then D
 
select <columns list> from <data source> where <conditions>
 
if A >= B then C else D-C end
 
and what about & ampersand 
 
........

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

Select all Open in new window

as above after edit ?? for plus + signs
would not embed into this position using the embedd button after changing... put it down the bottom

Code snippet as an attachment small bits should be OK Check out the plus signs
 
If a > B   C then D
 
select <columns list> from <data source> where <conditions>
 
if A >= B then C else D-C end
 
and what about & ampersand 
 
........

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

Select all Open in new window

Attached code snippet 2

will begin formatting a code snippet and see what happens when it wraps around a faily log line which can sometime cause issues particularly where any form of scrolling becomes involved in the result sets. and just realised juft how very lon the ling must be to invoke wrapping regardless of window size.

1:

Select all Open in new window

Apart from code snippets, a lot of success depends on spacing and locating the control tags

Tried to test image attachment and complained about a URL problem
Tried to test file attachment and said it had an image so embedded that

plagiarism-checker.jpg

256 KB
test file attachment

-- another file...

commenttype.jpg

910 KB
add another file

So, tabs and tags in the list of attachments not in unison...

Keyboard characters.... Expert Skin
~`!@#$%^&*()_-+={[}]|\"':;<,>.?/
32 of them
they worked

Keyboard characters.... Premium Skin
~`!@#$%^&*()_-+={[}]|\"':;<,>.?/
32 of them

-- step 1 create some test data - note the change in names just for the purpose of testing
 
-- for membership, I added in a column agentid (but dont use it) - seems odd to use cname from membership with agentid from availability in SP
create table tmp_ee_membership (agentid int,cname varchar(100), dintervalstart datetime)     
create table tmp_ee_availability (agentid varchar(100), availability int)
 
insert tmp_ee_membership
select 1,'agent1','20091101'
union all select 2,'agent2','20091102'
union all select 3,'agent3','20091103'
union all select 4,'agent4','20091104'
union all select 5,'agent5','20091105'
 
insert tmp_ee_availability
select 'agent1',1
union all select 'agent2','2'
union all select 'agent3','3'
union all select 'agent5','5'
 
GO
 
-- step 2 try the "guts" of the procedure as interactive SQL in a query window
 
declare
 @begindatetime	datetime,
 @enddatetime datetime,
 @agentlist varchar(max)
 
set @begindatetime = '20091101'
set @enddatetime = '20091106'
        
/* GET LIST OF AGENTS */  
SELECT @agentlist = substring( (Select distinct ','''+cName+'''' as [data()]
From tmp_ee_Membership
Where dintervalstart >= @begindatetime
and dintervalstart < @enddatetime
and cname is not NULL
FOR XML PATH ('')),2,8000)   
select @agentlist
/*USE LIST OF AGENTS OBTAINED PREVIOUSLY HERE AND GET THEIR AVAILABILITY*/  
exec ('SELECT agentID, sum(availability)
From tmp_ee_Availability
Where agentID in ('+@agentlist+')  
Group by AgentID')
 
GO

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:

Select all Open in new window

Private Testing Only - MW

Steps

title of step

use distinct heading 4 Steps not encapsulated

use distinct heading 4 Steps encapsulated

Test

Consulting

About The Author

More Articles From mark_wills

Comments

Add your Comment

Join Experts Exchange Today

Gain Access to all our Tech Resources

Get personalized answers

Access Proven Solutions

Read In-Depth How-To Guides

Watch Step by Step Tutorials

And Much More!

Top Consulting Experts