Search results

  1. G

    import unnormalized .txt coloms to row

    Hello, I import a unnormalized .txt file. I want to change the colomn in table 1(only year) in rows. My database will have then the right structure. i can not change the import file. I need to change the structure. tabel 1: Activa-id 2005 2006 2007 2008 2009 2010 1 850 935 1029 1132 1245...
  2. G

    Union All

    Hello, I want to see the numbers for a particular @Year, with totals for each Month, Account and Department. The following tables: Budget: (Year, Month, Account, Dept) (PK), Amount Commitments: CommitmentID (Identity, PK), Year, Month, Account, Dept, Amount Actuals: ActualID (Identity, PK)...
Back
Top Bottom