Staff Ratios
Jul 23, 2005i am doing some statistics for staff ratios and have had no luck
finding any DBA's per sql server or DBA's per sql databases. If anyone
has any numbers, i would greatly appreciate.
Thanks!
ADVERTISEMENT
How To Add New Staff Number?
Apr 1, 2008
i have a field called staff_number contains staff number like this:
DR1, DR20, SR57, DR165, etc.. where DR is a code for Doctors
NU17, NU564, NU9, etc... where NU is a code for Nurse
i am passing the code (DR, NU, etc) from my C# application but i want the SQL to add one more number to the last number..
so it should check if I am passing DR as code for the last DR, let's say DR14 so the next DR will be DR15
i don't know how to this because the number has no fix length so it's from 1 to 999
How To Extract Only 1 Record For Each Staff?
Oct 30, 2005Hi,
I have more than 1 record for each staff. This is the sample of record,
StaffNo Field1 Field2 Field3
50424 Data1 Data2 Data3
80336 Data1 Data2 Data3
50424 Data4 Data5 Data6
50424 Data7 Data8 Data9
80336 Data4 Data5 Data6
Is it possible for me to extract only 1 record for each staff? The result should be like this..
StaffNo Field1 Field2 Field3
50424 Data1 Data2 Data3
80336 Data1 Data2 Data3
Any idea? I used DISTINCT in sql statement but it's not working because the record is unique.
Thanx in advance..
Queries And Reporting From Corporative Database Non IT Staff
Oct 28, 2006Hi! we have no Business Intelligence solution in my job and the general manager asked for a query and reports system where he (and other section managers and non IT staff) could query the corporative database (we work in healthcare, so it's mostly about patients, clinic histories, treatments) so I will propose them SQL SERVER 2005. I'll tell you my general idea and maybe you could tell me if I'm right: Through Integration Services we will load our data from the corporative database (it's Borland's InterBase) and generate a datawarehouse (now we don't have a datawarehouse) then through Reporting Services we can query this datawarehouse to generate different reports (this reports can be generated for non-technical staff, but staff who knows quite a lot about for example the different treatments that different groups of patients follow, so this staff may want to query about which patients followed which treatment in a period of time and generate by himself a report about that). And through Analysis Services we could (in a future) generate some OLAP solutions, Data Mining etc
But for the query and report system it could be enough to start with Integration Services and Reporting Services? it's very important for this system to work efficiently in terms of time: the non-technical staff generates the query and in seconds receives the report result... some of this non IT staff who will use the system knows exactly which information we house in each InterBase table, so through this system they would like to generate their own queries and reports (this is a different level of non-IT staff who is in between a Medical doctor and a Software engineer, this staff does have some technical background specially in SQL.
So my idea is to have an SQL SERVER 2005 to which this staff gets connected via LAN (all this system runs locally in one corporative place, will not run through Internet) feeded by the InterBase corporative database and delivering efficiently queries and reports... is this possible? could I test this using the trial free 6 months version? and after that if everything's working fine how much will I have to pay for 15 persons to access the SQL SERVER 2005 for keeping using the system?