Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. scottcabral1979

    Add Sequence Number within group

    thanks Borislav , that worked!
  2. scottcabral1979

    Add Sequence Number within group

    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...
  3. scottcabral1979

    Insurance Policy Submissions Cube

    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...
  4. scottcabral1979

    SQL 2008 R2 setup.exe does nothing

    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...
  5. scottcabral1979

    OpenXML question

    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>...
  6. scottcabral1979

    pass dynamic value to ssis package

    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...
  7. scottcabral1979

    schema design question

    Hi Johnherman, thanks for your input. 1. We do have a Customer Number for each policy and yes, a customer could have multiple policies with our company. I was thinking of building a Customer dimension to hold each customer number, address, and name information. This could be an SCD type 2...
  8. scottcabral1979

    schema design question

    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...
  9. scottcabral1979

    Upgrade to 2008 R2

    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...
  10. scottcabral1979

    Insurance Policy Snapshot

    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...
  11. scottcabral1979

    SSIS Read Excel rows and create new output file

    thanks Geoff, This sounds logical to me. The trickiest part will be to dynamically have the excel file name change, but I should be able to find some examples of that online. thanks Scott
  12. scottcabral1979

    SSIS Read Excel rows and create new output file

    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...
  13. scottcabral1979

    PowerPivot data refresh error

    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...
  14. scottcabral1979

    SSAS front end tools

    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...
  15. scottcabral1979

    multi leve fact table

    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...
  16. scottcabral1979

    select data horizontally

    Thanks Simi, This code is exactly what I was looking for to build the table dynamically based on the max number of sequence numbers. I had to update the column names to use the @cnt variable instead of hardcoding the '1'. There was also an extra column at the end before the from statement, so...
  17. scottcabral1979

    Transactional Fact Table Design

    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...
  18. scottcabral1979

    Insurance Claims Fact Table Question

    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...
  19. scottcabral1979

    get last day of month for each month between 2 dates

    Thanks, I ended up using the follwoing logic: CREATE TABLE #scabral7 ( ID BIGINT , Effective DATETIME , Expiration DATETIME ) INSERT INTO #scabral7 ( ID, Effective, Expiration) SELECT 123, '2012-01-01', '2012-09-30' SELECT ID, e, Effective, Expiration FROM...
  20. scottcabral1979

    get last day of month for each month between 2 dates

    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...

Part and Inventory Search

Back
Top