Search results for query: *

Hi, I have the following data: POL# POL_EFF_DATE 123 1-1-2012 123 1-1-2012 123 1-1-2012 123 1-1-2013 123 1-1-2013 456 1-1-2012 456 1-1-2012 456 1-1-2013 456 1-1-2013 I want to add sequence number to each group with same Pol# and Effective Date like this: POL# POL_EFF_DATE Seq 123 1-1-2012 1...

Hi, I would like to build a fact table that tracks homeowner's insurance policy submissions. This table would measure policies that were quoted and/or issued. The source data is stored by policy with a Quote Date and an Issue Date and a policy_status field. Every policy would have a quote date...

I have a Windows 7 64 bit machine running SQL Server 2008 Enterprise. I would like to upgrade it to SQL Server 2008 R2 Enterprise. I loaded the media on the machine, but when i double click on the setup.exe, it displays a command box for a split second, goes away, and then nothing happens. I...

Hi, I have the following xml file: <Root> <Policy> <PolicyNumber>123456</PolicyNumber> </Policy> <Limits> <LimitType>LOB</LimitType> <LimitAmt>1000</LimitAmt> <LimitType>PP</LimitType> <LimitAmt>5000</LimitAmt> <LimitType>LOU</LimitType>...

I have an SSIS package that has a variable called @RUN_DATE. I would like to create a sql agent job and uses the set values tab to pass a dynamic parameter to the ssis package. for example, i would like to always set the variable to the last day of the previous month. I know that If i hardcode...

Hi, I'm designing a monthly periodic snapshot fact table that will have every homeowner's insurance policy that is active at the end of each month. Each policy has many attributes including policy number, effective date, expiration date, agent, territory, distance from coast, number of family...

Hi, looking to Upgrade from SQL 2008 Enterprise to 2008 R2 Enterprise on Windows 2008 R2 Server (64 bit). Any known issues, gotchas, white papers, etc... that I should be looking for or prepare for? My guess is that an in-place upgrade should be quite easy as there should not be many changes...

Hi, I have a question about modeling a fact table representing Insurance policies. We get a lot of requests for "How many policies were effective in 2011?" or "How Many Policies were Cancelled in 2012?". My guess would be an accumulating snapshot, but how do I model policies that have had 4...

Hi, I have an excel file with following data: Agent State Exposure Insured Name Rogers Inc MA 100,000 John Smith SAN Group RI 200,000 Jim Morrison SAN Group RI 100,000 Jimi Hendrix 123 Agency MA 300,000 Mickey...

I recently setup PowerPivot for Sharepoint 2010, installed all necessary products and setup all services and permissions on the server, including the PowerPivot Unattended refresh account. I created a PowerPivot workbook which connects to our SQL Server data warehouse. I was able to save to...

Hi, I built a dimensional model with the fact and dim tables populated and created a cube using SSAS 2008. Now I would like to give the end user's the ability to drag and drop and slice and dice the data like you can using SSAS, however I'm not sure what tools are best for this. I know Excel...

Hi, I am trying to model an insurance claims process that contains 2 levels. Each claim has a main occurrence number. This is the main ID for a claim. Each occurrence number has 1 or many features. Features are what hold the measures or amounts for each claim transaction. Occurrences have...

Hi, I am trying to build a Claims Transaction Fact table for a homeowner's insurance company. My claims transactions source table is setup like this: Each Claim entered has an Occurrence. Each Occurrence can have 1 or many Features. Each Feature has 1 or more transactions. So for example...

Hi, I currently work for a property and casualty insurance company where we only deal with homeowner's insurance. I would like to build a claims transaction fact table along with all the dimensions used to describe the transactions. Being fairly new to Dimensional modeling, i have a few...

Hi, I'm trying to write some code that will get me the last day of each month for the months that fall between 2 dates. So if i have a table with a record with a begin date of 01-01-2012 and an end date of 09-14-2012, i would want a result set of the following 9 records: 01-31-2012 02-29-2012...

Hi, I have the following table: Occ_Num Feature_Num Trans_Date Peril_Desc 123 1 1-2-2012 Water 123 1 1-11-2012 Ice 123 2 1-2-2012 Other 123 2 1-13-2012 Other 123 2 1-19-2012 Wind I want to select each...

HI, I have the following table: Policy Sequence LossDate Description Amt 123 1 9-1-2012 property 100 123 2 10-1-2012 property 200 345 1 9-1-2012 property 100 345 2 10-1-2012 property 100 678 1...

Hi, I have the following data in a table: Account SEQ 12345 1 12345 2 12345 4 12345 5 12345 7 I need to fix the SEQ field so that no gaps exist, like this: Account SEQ 12345 1 12345 2 12345 3 12345 4 12345 5 Is there a way to do this with T-SQL? thanks

Hi, I am currently migrating a database to a new 64 bit windows server from a 32 bit windows server. One of my SSIS packages connects to an Oracle datbase using the ADO NET connection manager and the OracleClient Data provider. On the 32 bit server, we have an Oracle 10g express client...

Hi, We have been given a new 64 bit SQL data warehouse server with 2008 enterprise installed. Here are the specs given to us by the server admin group: *** Server Storage provisioning - two RAID-10 arrays have been configured with standby hot spares. Each array is one independent volume as...