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.
| Author |
Topic |
|
maggie_patterson
Starting Member
1 Post |
 Posted - 2015-04-03 : 14:43:03
|
| SELECT TicketNumber, SequenceNumber, Created, ProfileId, EscalationReason, IsPrecall, RequestedTimeFrame, WantsOriginalTimeFrame, HasTimeslotExpired, GoBackTimeFrame, TechNumber, JobNumber, OriginalApptDate, OriginalApptTime, Comments, NewApptDate, IsTroubleCallOrInstall, WorkOrderID FROM CORPORATE.ERONE.ORIGGOBACKNE;this is my table and i need to find the rate of tickets to go back to customers homemaggie patterson |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-04-03 : 15:19:09
|
| The list of columns you posted does not appear to have anything that resembles a RATE. Are there more columns in the table?You need some additional pieces of information as well - e.g., where the customer's home is. |
 |
|
|
|
|
|
|
|
trying to find a rate with this table