Search results for query: *

Hi Appreciate any help with the following, fairly new to SQL Server: I have a stored procedure for a report that runs a query against a view using parameters supplied by the user (in this instance, an example being the JobID). The view is fairly complex as it is a Job Costing report. When...

Hi Would appreciate any help offered on the following: We have a production database set to Full Recovery Mode, with transaction log backups, differential backups and a daily full backup. The daily full backup (which backs up to a separate server) normally takes around 4 minutes to complete...

Hi I have been asked to write to an Audit Table every time an access report is printed. The print command for all the reports in the database displays the standard print dialog box. I can obviously capture that the print button has been clicked (which then displays the print dialog box), but...

thanks denny but I need to ge the data into a table, so that the information can be viewed by management in the application they use. They want to be able to click onto a user in a combo box and view the users log-in/out date/times. This is not a problem as long as I can get the data into my...

I have been asked to record user activity for a specific database, to track who logged in/out and when. I want to write this data to an 'Audit Table'. Being new to SQL Server (2005) could someone assist and point me in the right direction. Is there a sp that can be used to capture this info or...

Paul Thanks for the speedy response, the reason for moving the db is not really a space issue, more a logical separation of the databases and logs. Which is why I wasn't sure whether this impacted on the systems db's. As mentioned fairly new to the administrative side of things, so wasn't 100%...

I have read a number of threads on this, however any clarification of the following would be very much appreciated: I have been asked to move a database to a new drive on the same server, and am aware this can be done using sp_detach_db and sp_attach_db. The question is once this has been done...

To substitute a zero value for a NULL: ISNULL(TableName.ColumnName1,0) + ISNULL(TableName.ColumnName2,0)

George Thanks for the kind offer. I actually went through the SQL in detail and eventually grasped the logic of the self join - as mentioned the data I published was an example so the code had to be modified slightly to suit the actual table structure - and it works great - the tables are not...

George Many thanks for taking the time to solve this complex issue, Your solution works great - now just trying to get to grips with understanding the code itself ! As mentioned I managed this using recordsets by moving through each record and comparing to previous to see if still same...

We have a call-out schedule which details the employee on call for any day by the hour, the table looks something like this ID EmpID CallDate CallHr 1 55 2006-12-01 1 2 55 2006-12-01 2 3 55 2006-12-01 3 4 55 2006-12-01 4 5 55 2006-12-01 5 6 55 2006-12-01 6 7 55 2006-12-01 7 8 55 2006-12-01 8...

Hi I have been asked to upgrade an Access 2000 Application to use SQL Server as the back end, tables are linked using ODBC and testing has gone quite well (after a few code amendments), however one issue I am getting is adding a new record using recordset operations then opening a form using...

Try this, replacing txtName with the name of the text box containing the memo field: Me.txtName = Me.txtName & " " & Now() The code is placed in the On Click event of the command button.

I suspect you are using a Group By query which restricts the memo text to 255 characters. You wil need to re-write the query/report if you want to return the full text. Mark...

Trustsun Sorry, had my 'form' head on, not sure exactly what you are asking for, if you want the date to be returned to always be the 'Monday' then use the following: Expr1: [mydatefield]-Weekday([mydatefield])+2 If this is not waht you want then post your sql. HTH

The code belows return the first day of the week: Me.StartDate = Me.CalPick - Weekday(Me.CalPick, vbMonday) + 1 For info CalPick is a calender control, to get the date for the end of the week you could use: Me.EndDate= Me.CalPick - Weekday(Me.CalPick, vbMonday) + 7 You should be able to...

I have used the code below successfully in an application, I notice that my code references the form property to set the scrollbar value: If Me.FrmMaintInvItems.Form.RecordsetClone.RecordCount = 0 Then Me.PageItem.Visible = False ElseIf Me.FrmMaintInvItems.Form.RecordsetClone.RecordCount <...

Boxhead Agree that my initial approach made it difficult, and can confirm this was not the approach I eventually used. The problem I had is that I have many complex queries (mostly union type) linked to a specific table and I was trying to avoid having to re-write all affected queries by this...

Don't worry guys. I found a solution, basically used nested loops. Accounts can add as many 'Types' as they like and I can calculate the Total Cost for each effective date. Private Sub CalcHourly() On Error GoTo Cal_Err Dim str1 As String Dim str2 As String Dim str3 As String Dim rst1 As...

Can anyone give me feedback on this intial approach: Create a Table with the following fields ID, EffDate, Total, Lab, Veh, Equip Create function to derive Total by counting number of fields in the table then use a loop to sum the values from col(3) to col(n) and populate 'Total' with the sum...