Jump to content

yeppy12

Members
  • Content Count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About yeppy12

  • Rank
    Newbie

Recent Profile Visitors

841 profile views
  1. Ahh, okay. Thanks, justsomeguy. I will try that out.
  2. So here is what I have so far...thoughts? select acct_num = ser.account_number, customer_type = cac.member_role, full_name = cac.full_name, acc.charge_off_date, external_status = acc.external_status_code_name, coff_reason = acc.charge_off_reason_code, crd.date_status_chg, cac.deceased_code, crd.upc_14, curr_bal = ser.current_balance, cac.cii_code, sys_num = spa.system_bank_identifier into #first_filters from fact.fact_cc_servicing ser join dim.dim_cc_account acc on ser.account_number = acc.account_number and acc.end_date = 99991231 join dim.dim
  3. So I read that article on insert into, but I am still confused as to how I can combine the where clauses in my query. The examples in that article do not have where clauses.
  4. I am a newbie with SQL. I wrote the code below, and I am trying to make it more efficient. As of now, I run the first select statement, copy/paste it into excel, run the second part, and then copy/paste it into excel. Is there a way to combine these queries into one? I was unsure of how to do so. I currently run the select statements separately because I want the results from the first select statement AND the results from the second statement. The second select statement just uses the temp table #first_filters created in the first select statement to get records meeting the criteria
×
×
  • Create New...