Search results for query: *

We have SQL 2008. We were supposed to go live with SQL 2016 at the end of March. That got put on hold when we started working from home the beginning of March. I am helping to fulfill a requirement for a dated ump. One of the fields requires that we show the results formatted as 999999999999...

I'm bit confused with the query below. Here is an example of the data set. PURGE_ACTION LOAN CLOSEOUT_STATUS PREVIOUSLOANNUM PURGE 3610878 REFINANCED PURGE 3610887 REFINANCED KEEP 3728285 REFINANCED 3610878 3610887 Note, the...

I have the following set of data. It is created using a sum of principal + interest to get the payment and it is grouped by the loan number, year of as of date, and quarter of as of date. The latter two are not shown. LOAN PAYMENT 3715142 252441 3715142 252441 3715142 252441 3715142 252441...

Two years ago I posted this - http://www.tek-tips.com/viewthread.cfm?qid=1636759 With the help provided, I was able to get the report working as requested. Today, two years later, an additional group was asked to be added to report. Unfortunately, because I do not completely understand what was...

I am using Excel 2007 The code in bold errors with the message "Run-time error '1004 Unable to get the PivotFields property fo the PivotTable Class". If I remove the filter code complete, the pivot table is created. What is causing the filter code to error? I have tried all types of things...

I am using Windows 2007 and Excel 2007 I used the Macro recorder for a pivot table. I cleaned up most of the code to not use what Microsoft generates, but I am not sure how to clean up the code for a top 10 filter and for sorting values in descending order. Below is what the recorder generated...

I am using Excel 2007 on Windows 7. The code below gets rid of everything, the row fields and the data fields, thus only leaving the header rows, eventually resulting in an error that reads "Unable to set the subtotal property of the pivot class". For Each pf In .PivotFields...

I am using SQL 2005. I have found how to get the last day of the year for a given date. select dateadd(year,datediff(year,0,getdate())+1,-1) I am trying to figure out how to, for a given date, get the end of the year for that same day. For example if the date provided is 01/10/2013, I want...

My work laptop was recently replaced. The new laptop uses Windows 7. The old laptop used XP. Both laptops use Excel 2007. Today when I went to execute a Macro that was created on the old laptop and that ran without an issue. The bold line below is where a receive the "Method or data member not...

I want one column and one row that acts as a concatenated list, separated with a carriage return. I have a table with the fields code, loancomment, commentdate, and note1. Note1 is a datatype of text. The data in the table, if I select the note1 records returns 3 rows of data. I want those...

We have Microsoft SQL Server 2005. I have been having a hard time conceptualizing what I need to do. We have fields called loan, loan_ref, and property. The loan_ref can have one or more loans. A loan can have one or more properties associated with it. A property can be associated with...

I am using Excel and Word 2007. This is my first time working with code for Word. The following code errors with error number 91. Originally the error was 462, but after adding wrdDoc, the error changed to 91. 'format each table For wrdTbl = 1 To wrdDoc.Tables.Count...

I am working on something where I want to take information from Excel (2007) and have it update Word (2007) where it is bookmarked. I have never done this before, but by using books and information online I have started the process. Here is what have: (1) The Excel worksheet has several hundred...

I am using Excel 2007. The data being extracted from the following code is in Microsoft SQL Server 2005. At the line below I am getting the error "operation is not allowed when the object is closed". I searched and searched the web, but I cannot figure out what is wrong. I did ?sSQL in the...

We are using SQL Server 2005, which has more than one database. One of the databases, we will call it X, has a stored procedure that uses many tables from another database that we will call Y. I know there is a way to get a list of tables used in a stored procedure from within the same...

I am using SQL Server 2005 We created the following function, which change the @date_to_check to the next business day, if that date is on a weekend or a holiday. NOTE, the procedure that calls the function returns 70,000+ records and with the following code the stored procedure returns...

I am using Microsoft SQL Server 2005 I am trying to create a ranking where brief has priority over actual which has priorty over priority. These are user defined types. In addition, it should be the most recent statement date that is extracted for the corresponding user defined type. The way...

I have Excel 2007 As part of a test of the conversation from one of our currentvendor systems (v9) to the vendor system upgrade (v11), where data is stored in Microsoft SQL server, one of programmers created and ran a reconciliation. One of the result sets returns rows from each of the systems...

I am using Excel 2007 In a workbook, on the first sheet, I have two option buttons and a checkbox called OptionButton1, OptionButton2, and CheckBox1, respectively. In the properties, OptionButton1 and OptionButton2 have a GroupName of RecType. The value of OptionButton1 is No The value of...

I am using Excel 2007 I am getting a subscript out of range error at the line that reads as FoundRange.Offset(0, 6).Value = FieldName(NameCount) I think the issue starts at the following line, but I do not understand why FieldName(NameCount) = DiffRange.Offset(4, 0).Value & Chr(10)...