I am going NUTS. I have a value, for instance 247 that's
stored as an integer. Anyway, I need my query to format
it in Minutes/Second format....
What I want to do is essentially Concatenate
(Job_Length/60) & (Job_Length%60)
I keep getting this error:
Syntax error converting the varchar value ':' to a column
of data type int.
Here's my query in it's entirety...ANd I've tried Casting
every way imagineable (except probably the right way).
Any help is seriously appreciated:
SELECT Department, Work_Type, Job_Number
, Author_ID, Author_Name, Author_Date
, Author_Time, Patient_SSN, (Job_Length / 60)
+':' +(Job_Length %60) as 'Job Length'
FROM Tbl_Job_Tracking Where Job_Number = '979075'