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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by osirisa

  1. osirisa

    Please review my SP

    Do I need a variable for the temp table? Select a.station_nbr, a.station_name,a.group_code, a.beg_eff_date_DGC, a.end_eff_date_DGC, b.beg_eff_date_SES, b.end_eff_date_SES INTO #TP_DGC_vs_SES From #TP_DGC a full outer join #TP_SES b on a.station_nbr=b.station_nbr or a.group_code=...
  2. osirisa

    Please review my SP

    _____________ Ok. I created the two temp tables and Now I am trying to compare the temp tables for discrepancies. Please review my SP and let me know if I am even close to what I want to do. What's the correct syntax to compare the two temp tables. Thanks...
  3. osirisa

    Question on Temp Tables

    /* Create a Temp Table */ Create Table #TP_DGC( station_nbr char (20), station_name varchar (40), group_code char (12), beg_eff_date_DGC datetime, end_eff_date_DGC datetime) --------------Selection Gathering Table------------------- DECLARE @groupcode char (12)...
  4. osirisa

    Question on Temp Tables

    Thank you kaht appreciate it !!!
  5. osirisa

    Question on Temp Tables

    Does anyone know how to compare two temp tables using a left outer join? I have to find the diferences between Temp Table A and Temp Table B. I tried the following Select statement but is incorrect. I will apreciate if anyone can help me out in the comparison of the two temp tables...
See more

Part and Inventory Search

Back
Top