What's Your Compensation For Carrying A Pager???
Jul 20, 2005
My employer currently pays me $1/hour when I carry a pager. I have to
carry the pager every fourth week. The problem is that my employer
insists that I be available when I'm carrying the pager. So, for $1/hr
they expect me to remain within pager range, remain sober, and be
available to come to work. That really sucks on weekends. No going
to the beach (out of pager range) or out to a friend's cottage (out of pager
range), etc. Declining to carry the pager is NOT an option.
I'm curious what compensation others get and more importantly, what's
your employers expectation of your availability when you're on-call?
Thanks.
View 49 Replies
Jan 16, 2008
Hello everybody!
I'm fighting with report's HTML view for a week, and i cannot overcome it. The problem is wrong pager spliting. Having changed a lot of controls properties i acheived correct pagination while exporting to PDF format (it gives me 4 pages in A4 format).
But HTML pagination haven't changed at all. It gives me 2 large pages. And whatever i change it gives me the same 2 pages.
Has somebody deal with that?
Thanks for any help!
View 3 Replies
View Related
Apr 15, 2004
Hi. this is a tricky one to explain but I'm at a bit of a loss
Consider a product demand table such as
ProductDemand Qty
Prod 1500
Prod 2300
Prod 30
Now consider a Inventory table such as
Product BatchTotal qtyFree qty
Prod 1Batch 13000
Prod 1 Batch 2300100
Prod 1Batch 3200200
Prod 2Batch 22 600300
Wha I am trying to achieve is the "Free Qty" column such that, within each product, the demand is "comsumed" by each batch in turn until completly comsumed (or no batches are left). Hence the demand of 500 would result in 300 going to zero for batch 1, carry forward 200 demand which would be completly comsuemd by batch 2 leaving 100 "free". Subsequnet batches would remain all free for that first product. Then the operation continues for the next product.
How on earth do I do it ?????
Thanks for you thoughts
Gerry
View 7 Replies
View Related
May 28, 2008
hi
how to use pager email in sql 2005 server
View 4 Replies
View Related
Aug 2, 2000
Is there a third party tool that can be used with SQL 7.0 to send an alert to a numeric pager?
View 1 Replies
View Related
Apr 11, 2008
I am making a report for a car dealer. Each month a certain number of cars will be placed on the lot and a certain number will be taken off. I want to make a report that will show the inventory levels at any point in time. (I will further refine the report by color, origin, model, etc later.) I am currently listing each car in my inventory table, flagging it with a "removed" flag when it is sold. My flag for adding a car is 1 and removing a car is -1. It's easy enough to sum the table and get the current inventory level but I'm having trouble looking back over time.
Say in January I had 35 cars on the lot. I sold 20 and added 5. In February I sold 9 and added 10. In March I sold 12 and added 5.
I need the report to break every month. But on the break I need to add all the cars in the table minus cars sold. For the January report it should show a total (cars added - sold) in the table. Each month I need to take a new grand total of all cars added minus cars sold up to the end of that month OR cars added that month minus cars sold that month added to the running total from the previous month.
Is there some sort of calculate measure I could stick in my cube that would carry these totals? Or any other ideas?
Thanks.
View 1 Replies
View Related
Mar 22, 2007
How can I carry a value over from a subreport to a main report?
If I have a total in a sub report, I want to use that total in expression on the main report.
Any ideas?
View 4 Replies
View Related
Aug 15, 2002
how do I set up a SQL2000 server to send an alert to both an email address and a pager when a specific event occurs..please help!!! The server is in a different location and we need notification of problems!! thanks
View 1 Replies
View Related
Nov 14, 2014
I have a client that I provide financial modelling services to (using Excel). They have a requirement to start capturing subscriber movements in their SQL DB. how the table should be set-up and how to extract the necessary movements report. This is largely so that I may include these components in some of the financial models that I am working on.
Subscribers are reported as follows:
Opening subs (the prior periods closing balance; or the sum of new sales at point of 1st entry)
+ New Sales (new subs)
+ Upgrades (movement from a lower product package to the associated package)
- Downgrades (movement to a lower product package from the associated package)
- Churn (subscriber losses)
Closing Balance
All transactions are captured against a specific product package, on a specific date (ymd), and for an associated platform (e.g. digital TV, broadband TV, cable TV).
I believe we only need to capture new sales, upgrades, downgrades and churn. And then used a SP to compile the movements behaviour as described above.
So perhaps the table would appear as follows:
Platform
Package
Date
Movement
Value
DTV
PROD 1
2014-11-02
New Sales
8
DTV
PROD 1
2014-11-02
Upgrades
1
[code]....
So I am assuming that given a table such as the above, we could write a SP to produce an output such as (note, below looks at monthly total so will not agree back to sample above which contains only 2 days):
Platform
Package
Movement
September
October
November
DTV
PROD 1
OPEN
600
676
776
DTV
PROD 1
New Sales
92
106
88
[code]....
how one is best to accumulate the balances given that the open date for any given reporting period is in fact an accumulation of all balances since day 1.
How does one typically capture this type of thing in SQL?
View 4 Replies
View Related
