add strings in the colunm or the table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

add strings in the colunm or the table

Author

Topic

Ginger8990
Starting Member

28 Posts

Posted - 2011-01-13 : 14:06:21

We have a call center report DB (SQL 2005),we try to generate a report which is not canned.

I am not a DBA and not sure how to alter the column to create a report with call agent's name and the time of transfer-call.
THe table is iAgentQueueStats, some columns (nFlowOutAcd)can be modified but not sure how to modify column.

Any help is appreciated.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-13 : 14:41:27

DO NOT modify the table to make a report. This will break the application.

Show us the table definition, and your query. We'll try to help you from there.

Ginger8990
Starting Member

28 Posts

Posted - 2011-01-13 : 16:17:09

Actually no application and software installe don SQL box, we just use ODBC to connect to the applications server (phone system server) then the ODBC filled into SQL and generated the report.
We have a database called i3 and a table called "iAgentQueueStats", there are a lot of columns under this table, the key columns are nFlowOutAcd(int, not Null and tFlowOutAcd (int, not NUll).

I am not sure how to insert date, employee name and time the call be transferred.
On the right pane of this column, i can see:
nFlowOutAcd int Allow Null
nStartWaitAlertAcdcalls int Allow Null
nStartActiveAcdCalls int Allow Null

What is int and Allow Null?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-13 : 16:50:16

What application generates, or presents, your reports?

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-01-14 : 00:36:30

int is the data type of the column, and allow null is a property by which you are allowed to store null values in the column.

Ginger8990
Starting Member

28 Posts

Posted - 2011-01-18 : 11:28:52

We use Interaction CLient. the MS query supposed to pull agetn name and time of the phone-transfer calls. We need to use the table called iAgentqueuestats and two columns --nFlowOutAcd and tFlowOutAcd
I tried to get the user name and transfer call time

SELECT FirstName, LastName FROM iAgentQueueStats (this is table)
SELECT callTransfer FROM nFlowOutAcd (column)
SELECT Calltime FROM tFlowOutAcd

Thank you for help!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 11:14:52

but you're not relating tables. so how will you determine which time corresponds to which agent?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Ginger8990
Starting Member

28 Posts

Posted - 2011-01-26 : 13:20:59

We have someone wrote this query but only pull the agent names and not transfer-time:

USE I3_ICC
SELECT dIntervalStart AS Date, cName AS [Agent Name], cReportGroup AS Workgroup, cHKey3 AS [IC Report Type], cHKey4 AS [Media Type], tFlowOutAcd
AS [Total Flow Out]
FROM IAgentQueueStats
WHERE (cReportGroup = N'*') AND (cHKey3 = N'*') AND (cHKey4 = N'*') AND (dIntervalStart BETWEEN CONVERT(DATETIME, '2011-01-01 00:00:00', 102) AND
CONVERT(DATETIME, '2011-01-31 00:00:00', 102))

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-27 : 12:15:43

does time related table have any fields to determine agent info?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources