Viewing 12 posts - 1 through 12 (of 12 total)
bcrockett (8/19/2016)
CASE WHEN [TotalStaffedTime] = 0 THEN 0 else ((do this calculation))
And I tried this, and its not working, is my syntax wrong? Or what's the correct way to perform...
August 19, 2016 at 7:09 pm
CASE WHEN [TotalStaffedTime] = 0 THEN 0 else ((do this calculation))
August 19, 2016 at 7:06 pm
Where would I want to enter that?
SELECT
CONVERT (varchar,TimeStamp,1) AS 'DATE'
,cast([AgentLogin] as int) as EXT
,[AgentSurname] +...
August 9, 2016 at 6:27 pm
Thanks for the help! So, the HandleTime will vary, depending on user -- all times will be less than 24 hours.
In he declare statement - is = 1300 hard...
August 9, 2016 at 6:23 pm
andrew.leef (8/4/2016)
John Mitchell-245523 (8/4/2016)
You're trying to insert from the dim_person.person_name column, which is (presumably) nvarchar into the person_Ext column in your temp table, which is int.John
Yup,
Try flipping the order...
August 4, 2016 at 9:28 am
That was it too, but I need the person_ext to be an INT - but I figured it out, my select state was out of order.. I didn't realize this...
August 4, 2016 at 8:59 am
Sean Lange (7/7/2016)
bcrockett (7/7/2016)
Sean Lange (7/7/2016)
bcrockett (7/7/2016)
Where...
July 7, 2016 at 10:31 am
Sean Lange (7/7/2016)
bcrockett (7/7/2016)
Sean Lange (7/7/2016)
bcrockett (7/7/2016)
Where...
July 7, 2016 at 10:30 am
Sean Lange (7/7/2016)
bcrockett (7/7/2016)
Where do you get...
July 7, 2016 at 10:03 am
John Mitchell-245523 (7/7/2016)
Where does that list of phone extensions come from - another table, a spreadsheet, somewhere else?John
I get them from an excel file -
July 7, 2016 at 10:00 am
John Mitchell-245523 (7/7/2016)
Why not do it like this?
WHERE MyCol IN (SELECT MyNumber FROM MyOtherCol
)
John
Not sure how do this, haven't done it.... how does it work?
July 7, 2016 at 9:54 am
I have to pull data, from a phone system, but I have to pull the data on a specific group of phone extensions -
SELECT
...
July 7, 2016 at 9:53 am
Viewing 12 posts - 1 through 12 (of 12 total)